70-465 exam

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...

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...

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 serviceView AnswerAnswer: 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 AnswerAnswer: D...

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 rolesView AnswerAnswer: C Explanation: * Scenario: Installation Issues The current version of the ERP application requires that several SQL Server logins...

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,...

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 viewView AnswerAnswer: A Explanation: * Scenario: System administrators must be able to run real-time reports on...

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 DBView AnswerAnswer: C Explanation: For SQL Server the Azure Blob Storage service offers a better alternative to the...

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...

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 AnswerAnswer: A Explanation: * Scenario: You must encrypt the backup files to meet...