Question 6 of 77

DRAG DROP -

You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server

2012 instance named SQL2012.

The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to

SQL2012 so that the development team can test their new application.

You need to migrate the database without affecting the production environment.

Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Select and Place:

    Correct Answer:

    Reference:

    http://msdn.microsoft.com/en-us/library/ms177429.aspx

Question 7 of 77

DRAG DROP -

You administer three Microsoft SQL Server 2008 R2 instances.

Database mirroring is configured in High-Safety mode with Automatic Failover between the following three servers:

✑ SQL1 is the Principal server.

✑ SQL2 is the mirror server.

✑ SQL3 is the witness server.

You need to upgrade SQL1 and SQL2 to SQL Server 2012. You need to ensure that downtime is minimized during the upgrade.

Which six actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Select and Place:

    Correct Answer:

    Reference:

    http://msdn.microsoft.com/en-us/library/bb677181.aspx

Question 8 of 77

DRAG DROP -

You administer a Microsoft SQL Server database.

You use an OrderDetail table that has the following definition:

You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only rows that contain a value in the SpecialOfferID column.

Which four Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)

Select and Place:

    Correct Answer:

    According to these references, this answer looks correct.

    References:

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

    http://msdn.microsoft.com/en-us/library/ms189280.aspx

Question 9 of 77

HOTSPOT -

You administer a Microsoft SQL Server database.

The database contains a table that has the following definition:

You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.

You need to ensure that the following requirements are met:

✑ The first row of the file contains the first row of data.

✑ Each record is of the same length.

✑ The date follows the U.S. date format.

✑ The file supports international characters.

What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Hot Area:

    Correct Answer:

    References:

    http://msdn.microsoft.com/en-us/library/ms178804.aspx

    http://msdn.microsoft.com/en-us/library/ms187828.aspx

Question 10 of 77

You administer a Microsoft SQL Server database. The database has a table named Customers owned by UserA and another table named Orders owned by

UserB. You also have a stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from both tables.

You create a new user named UserC.

You need to ensure that UserC can call the GetCustomerOrderInfo stored procedure. You also need to assign only the minimum required permissions to UserC.

Which permission or permissions should you assign to UserC? Each correct answer presents part of the solution.

    Correct Answer: A, B

    To invoke the stored procedure GetCustomerOrderInfo, UserC needs the Execute permission on the procedure itself. In addition, since the procedure accesses the Customers table which is owned by UserA, UserC will also need Select permission on the Customers table. This ensures that UserC has the minimum but sufficient permissions to call the stored procedure and access the necessary data.