What should you recommend?

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

May 19, 2020 No Comments READ MORE +

Which two database options should you change to meet the requirements?

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

May 19, 2020 No Comments READ MORE +

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

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

May 19, 2020 No Comments READ MORE +

Which command should you use only during the monthly maintenance window?

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

May 19, 2020 No Comments READ MORE +

What should you include in the recommendation?

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

May 18, 2020 No Comments READ MORE +

What should you include in the recommendation?

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

May 18, 2020 No Comments READ MORE +

What should you include in the recommendation?

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

May 18, 2020 No Comments READ MORE +

What should you include in the recommendation?

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

May 17, 2020 No Comments READ MORE +

What should you recommend?

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

May 17, 2020 No Comments READ MORE +

What should you include in the recommendation?

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

May 17, 2020 No Comments READ MORE +