Category: 70-465

You need to recommend a solution that addresses the concurrency requirement. What should you recommend?A . Break each stored procedure into two separate procedures, one that changes Sales.Table1 and one that changes Sales.Table2.B . Make calls to Sales.Proc1 and Sales.Proc2 synchronously.C . Call the stored procedures in a Distributed Transaction Coordinator (DTC) transaction.D ....

You need to change the ProdDB database. Which two database options should you change to meet the requirements? Each correct answer presents part of the solution. Choose two.A . CONTAINS FILESTREAMB . Change recovery model to FULLC . CONTAINMENT = PARTIALD . Change recovery model to BULK_LOGGEDE . COLLATE IF . MEMORYG . CONTAINS...

What should you create in Azure to support the creation of the backups for DB1?A . an Azure Content Delivery Network (CDN) endpointB . a Service Bus namespaceC . a storage accountD . a cloud service View Answer Answer: C...

You are designing your maintenance plan. Which command should you use only during the monthly maintenance window?A . DBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex)B . ALTER INDEX SODIndex ON SalesOrderDetail REORGANIZEC . ALTER INDEX SODIndex ON SalesOrderDetail REBUILDD . ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON) View Answer Answer: D Explanation: *...

You need to recommend a solution that addresses the installation issues. What should you include in the recommendation?A . Windows loginsB . Server rolesC . Contained usersD . Database roles View Answer Answer: C Explanation: * Scenario: Installation Issues The current version of the ERP application requires that several SQL Server logins be set...

You need to recommend a disaster recovery solution for the Dev database. What should you include in the recommendation?A . The simple recovery model and full backupsB . The bulk-logged recovery model and full backupsC . The full recovery model, full backups, and differential backupsD . The full recovery model, full backups, and transaction...

You need to recommend a database reporting solution that meets the business requirements. What should you include in the recommendation?A . Data collectionB . Performance MonitorC . A maintenance planD . A dynamic management view View Answer Answer: A Explanation: * Scenario: System administrators must be able to run real-time reports on disk usage....

You need to recommend a solution to back up DB1. What should you include in the recommendation?A . Azure Table StorageB . Azure Queue storageC . Azure Blob storageD . Azure Document DB View Answer Answer: C Explanation: For SQL Server the Azure Blob Storage service offers a better alternative to the often used...

You need to recommend a solution that addresses the security requirement. What should you recommend?A . Revoke user permissions on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures.B . Grant the users the SELECT permission on the tables. Create views that retrieve data from...

You need to recommend a feature to support your backup solution. What should you include in the recommendation?A . Transparent Data Encryption (TDE)B . Column-level encryptionC . An NTFS file permissionD . A Secure Sockets Layer (SSL) View Answer Answer: A Explanation: * Scenario: You must encrypt the backup files to meet regulatory compliance...