| Question ID 18923 | You are migrating an OLTP database from Windows Azure SQL Database to on-premise.
You are planning the installation of a Microsoft SQL Server 2012 server failover cluster.
The server has the following partitions:
You install the operating system on the C: drive.
The database solution will use row versioning, triggers, and cursors. The tempdb database
cannot be placed on the same disk subsystem as the OLTP database.
The OLTP database needs to be on the fastest disk subsystem possible. The database is
currently 200GB in size. It will not substantially increase in size in the next 3 years.
You need to plan the usage of the disk subsystems.
To which hard disk should each database belong? (To answer, drag the appropriate
database or databases to their corresponding hard disk or disks in the answer area.
Answer choices may be used once, more than once, or not at all. Answer targets may be
used once or not at all. Additionally, you may need to drag the split bar between panes or
scroll to view content.)
|
