Which two features should you enable?

Correct Answer for the Question – Which two features should you enable? is given below You need to implement a solution to meet the technical requirements for the encryption of the data in App1.Which two features should you enable? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.An application named … Read more

Your company has a Microsoft SQL Server database hosted on a Microsoft Azure virtual machine.

Correct Answer for the Question – Your company has a Microsoft SQL Server database hosted on a Microsoft Azure virtual machine. is given below Your company has a Microsoft SQL Server database hosted on a Microsoft Azure virtual machine.You create several reports that display data from the database.Users report that the reports are slow to display … Read more

Which Transact-SQL statement should you run?

Correct Answer for the Question – Which Transact-SQL statement should you run? is given below You plan to create a data warehouse in Microsoft Azure for development purposes.The data warehouse must not exceed 10 terabytes (TB) in size. You must minimize costs for the environment.You need to create the data warehouse.Which Transact-SQL statement should you run?EDITION … Read more

What should you implement?

Correct Answer for the Question – What should you implement? is given below Your company’s data warehouse contains several Microsoft SQL Server instances.You need to prevent unauthorized users from restoring backups of SQL Server database.What should you implement? BitLocker Drive Encryption (BitLocker) Cell-level encryption Transparent Data Encryption (TDE) Dynamic Data Masking Correct Answer The Correct Answer … Read more

What should you enable?

Correct Answer for the Question – What should you enable? is given below You need to ensure that the performance statistics for the research department are collected. What should you enable?References:https://azure.microsoft.com/en-gb/documentation/articles/sql-database-query-performance/ Query Performance Insight Scale and Configuration Dynamic Data Masking Index advisor Correct Answer The Correct Answer for this Question is Query Performance Insight Explanation The … Read more

What should you configure?

Correct Answer for the Question – What should you configure? is given below You have several SQL Server instances on Microsoft Azure virtual machines.Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to 30 minutes. You investigate the issue and discover that when the issue occurs, there is … Read more

What is the best design to achieve the goal?

Correct Answer for the Question – What is the best design to achieve the goal? is given below You have an organizational data mart that contains 3.5 TB of uncompressed data.The size of the data is expected to grow 2 TB annually. Reporting is performed only during business hours.You plan to move the data to the … Read more

Which service tier should you identify?

Correct Answer for the Question – Which service tier should you identify? is given below You have an application named App1 that connects to a Microsoft Azure SQL database named AppDB1. App1 uses columnstore indexes as part of the database schema.You plan to deploy another Azure SQL database named AppDBDev that will be used as the … Read more

Which command should you use?

Correct Answer for the Question – Which command should you use? is given below You have a Microsoft Azure SQL database named DB1.You need to monitor DB1 to identify all regressed queries.Which command should you use?Queries with multiple plans? These queries are especially interesting because they are candidates for regressions due to plan choice change. The … Read more

Which view should you query?

Correct Answer for the Question – Which view should you query? is given below You have an application named App1 that uses a Microsoft Azure SQL database.Some users report that they receive messages similar to the following error message: ‘oeTransaction (Process ID65) was deadlocked on locked resources with another process and has been chosen as the … Read more