Free Microsoft 70-765 Exam Dumps Questions & Answers

You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You suspect that the current SQL Server indexes cause queries to execute slowly.
You need to identify which indexes must be created to reduce the query execution time.
Which three dynamic management views should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.sys.sysindexkeys
• B.sys.dm_db_missing_index_group_stats
• C.sys.dm_db_index_operational_stats
• D.sys.dm_db_missing_index_details
• E.sys.dm_db_index_usage_stats
• F.sys.dm_db_index_physical_stats
• G.sys.dm_db_missing_index_groups
• H.sys.indexes

You use a contained database named ContosoDb within a domain.
You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.
Which type of user should you create?

• A.login mapped to a virtual account
• B.Domain user
• C.SQL user without login
• D.User mapped to an asymmetric key

You plan to migrate on-premises Microsoft SQL Server to SQL Server on a Microsoft Azure virtual machine.
You need to ensure that the Azure virtual machine can handle the workload.
Which tool should you use for each environment? To answer, drag the appropriate tools to the correct options. Each tool may be used once. More than once, or not at all.

Correct Answer:

A company has an infrastructure that runs Microsoft SQL Server 2017 in Azure.
You need to ensure validation is performed on a memory-optimized Linux system.
Which Transact-SQL statement should you run?

• A.DBBC CHECKCATALOG
• B.DBCC CHECKTABLE
• C.DBBC CHECKALLOC
• D.DBCC CHECKSUM

You have on-premises database server.
The database files for a user database are configured as shown in the following table:

You plan to migrate the on-premises database server to Microsoft SQL Server on a Microsoft Azure virtual machine.
You need to provision storage for the virtual machine to meet the following requirements: Support the same configurations as the on-premises database server.
Provide a Service Level Agreement (SLA) for performance.
Minimize costs.
Which type of storage should you provision for each file type? To answer, drag the appropriate storage types to the correct file types. Each storage type may be used once, more than once or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Standard Storage has varying latencies and bandwidth and is only recommended for dev/test workloads.
Production workloads should use Premium Storage.
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windowssql-performance