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 2

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


God

God

SQL Server Binaries : C
OLTP DB : Partition(1)
Tempdb : D
Database Backups: Partition(2)