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

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.
Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.
You need to create the templates.
Solution: You use Visual Studio to create a JSON template that defines the deployment and configuration settings for the SQL Server environment.
Does the solution meet the goal?

• A.Yes
• B.No

Note: This questions is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
Your company has several Microsoft Azure SQL Database instances.
Data encryption should be allowed to be implemented by the client applications that access the data. Encryption keys should not be made available to the database engine.
You need to configure the database.
What should you implement?

• A.cell-level encryption
• B.Transparent Data Encryption
• C.Encrypting FileSystem
• D.Always Encrypted
• E.transport-level encryption
• F.BitLocker
• G.dynamic data masking

Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. There is a non- clustered index on the PurchaseTime column. The business team wants a report that displays the total number of purchases made on the current day. You need to write a query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?

• A.SELECT COUNT(*)FROM PurchasesWHERE PurchaseTime = GETDATE()
• B.SELECT COUNT(*)FROM PurchasesWHERE CONVERT(VARCHAR, PurchaseTime, 112) =CONVERT(VARCHAR, GETDATE(), 112)
• C.SELECT COUNT(*)FROM PurchasesWHERE PurchaseTime = CONVERT(DATE, GETDATE())
• D.SELECT COUNT(*)FROM PurchasesWHERE PurchaseTime >= CONVERT(DATE, GETDATE())AND PurchaseTime <DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))

You have a database named DB1 that contains a table named Table1. Table1 has 1 billion rows.
You import 10 million rows of data into Table1.After the import, users report that queries take longer than usual to execute.
You need to identify whether an out-of-date execution plan is causing the performance issue.
Which dynamic management view should you use?

• A.sys.dm_db_stats_properties
• B.sys.dm_xtp_transaction_stats
• C.sys.dm_exec_input_buffer
• D.sys.dm_db_index_operational_stats

You have Microsoft SQL Server on a Microsoft azure virtual machine that has 12 databases.
All database files are in the same Azure Blob storage account.
You need to receive an email notification if I/O operations to the database files exceed 800 MB/s for more than five minutes.
Solution: You run the Get-Counter cmdlet and specify the -counter '\physicaldisk:disk write/sec' parameter.
Does this meet the goal?

• A.Yes
• B.No