070-765 試験問題を無料オンラインアクセス

You plan to migrate a Microsoft SQL Server workload from an on-premises server to a Microsoft Azure virtual machine (VM). The current server contains 4 cores with an average CPU workload of 6 percent and a peak workload of 10 percent when using 2.4Ghz processors.
You gather the following metrics:

You need to design a SQL Server VM to support the migration while minimizing costs.
For each setting, which value should you use? To answer, select the appropriate storage option from each list in the answer area.
NOTE: Each correct selection is worth one point.

正解：

Explanation:
Data drive: Premium Storage
Transaction log drive: Standard Storage
TempDB drive: Premium Storage
Note: A standard disk is expected to handle 500 IOPS or 60MB/s.
A P10 Premium disk is expected to handle 500 IOPS.
A P20 Premium disk is expected to handle 2300 IOPS.
A P30 Premium disk is expected to handle 5000 IOPS.
VM size: A3
Max data disk throughput is 8x500 IOPS
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-windows-sizes

A company has an on-premises Microsoft SQL Server 2017 infrastructure. The storage area network (SAN) that supports the SQL infrastructure has reached maximum capacity.
You need to recommend a solution to reduce on-premises storage use without changing the application.
What should you do?

• A.Configure an Express Route connection to Microsoft Azure.
• B.Configure geo-replication on the SAN.
• C.Configure SQL Server Stretch Database in Microsoft Azure.
• D.Configure a Microsoft Azure Key Vault.

You need to ensure that the columns are protected.
What should you use?

• A.Always Encrypted
• B.Azure Key Vault
• C.persistent data masking
• D.cell-level encryption

You plan to create an AlwaysOn availability group that will have two replicas in Microsoft Azure and two onpremises replicas.
You need to ensure that a replica in Azure is always available.
Which cmdlet should you run before you deploy the virtual machines?

• A.New-AzureRmSqlDatabaseSecondary
• B.New-AzureRmSqlDatabaseCopy
• C.New-AzureRmSqlElasticPool
• D.New-AzureRmAvailabilitySet
• E.New-AzureRmVM
• F.New-AzureRmSqlServer
• G.New-AzureRmSqlServerCommunicationLink
• H.New-AzureRmLoadBalancer

You administer a Microsoft SQL Server 2014.
A process that normally runs in less than 10 seconds has been running for more than an hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?

• A.EXEC sp_who 60
• B.EXEC sp_helpdb 60
• C.DBCC INPUTBUFFER (60)
• D.SELECT * FROM sys.dm_exec_sessions WHERE sessionid = 60