Microsoft Designing Database Solutions for Microsoft SQL Server 2012

1.

You need to recommend a solution that addresses the installation issues. What should you include in the recommendation?

Windows logins Server roles Contained users Database roles

2.

You need to recommend a solution that addresses the security requirement. What should you recommend?

Revoke user permissions on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures. Grant the users the SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views. Deny the users SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views. Deny the users the SELECT permission on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the storedprocedures.

3.

You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application. What should you recommend changing?

The collation of the Products table The index on the ProductName column The collation of the ProductName column The data type of the ProductName column

4.

You need to recommend a solution that addresses the concurrency requirement. What should you recommend?

Break each stored procedure into two separate procedures, one that changes Sales.Table1 and one that changes Sales.Table2. Make calls to Sales.Proc1 and Sales.Proc2 synchronously. Call the stored procedures in a Distributed Transaction Coordinator (DTC) transaction. Modify the stored procedures to update tables in the same order for all of the stored procedures.

5.

You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort. What should you include in the recommendation?

Indexed views Filegroups Table partitioning Indexes

6.

What should you recommend for the updates to Sales.TransactionHistory?

a REPEATABLE READ isolation level implicit transactions query hints a SNAPSHOT isolation level

7.

You are designing your maintenance plan. Which command should you use only during the monthly maintenance window?

DBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex) ALTER INDEX SODIndex ON SalesOrderDetail REORGANIZE ALTER INDEX SODIndex ON SalesOrderDetail REBUILD

ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON)

8.

You need to recommend a solution to back up DB1. What should you include in the recommendation?

Azure Table Storage Azure Queue storage Azure Blob storage Azure Document DB

9.

What should you create in Azure to support the creation of the backups for DB1?

an Azure Content Delivery Network (CDN) endpoint a Service Bus namespace a storage account a cloud service

10.

You need to recommend a solution to minimize the amount of time it takes to execute USP_2. What should you recommend?

A database snapshot A table variable A temporary table Snapshot isolation

Microsoft Designing Database Solutions for Microsoft SQL Server 2012

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Microsoft Designing Database Solutions for Microsoft SQL Server 2012

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner