which hard disk should each database belong?

DRAG DROP
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.)

DRAG DROP
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.)

Answer:



Leave a Reply 4

Your email address will not be published. Required fields are marked *


taparany

taparany

I think tempdb should be on Partition2

AlexanderS

AlexanderS

“the tempdb database cannot be placed on the same disk subsystem as the OLTP database.”
So it has to go to the SSD disk (D)

M

M

raid level 10 offers better performance than level 5, OLTP has to go to P1, so tempdb only can go to P2

MMM

MMM

But DriverD is SSD. I think tempDB can go to DriverD.