070-473無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」

質問 1

You are evaluating whether an Azure SQL Database elastic database pool suits your workload and usage patterns.
What are two possible ways to identify the elastic database transaction units (eDTUs)? Each correct answer presents a complete solution.

（A）Aggregate data from sys.dm_os_wait_stats.

（B）Aggregate data from sys.dm_db_resource_stats.

（C）Aggregate data from sys.dm_os_performance_counters.

（D）Run the Database Engine Tuning Advisor.

（E）Run the Service Tier Advisor.

正解：B、C 解答を投票する

質問 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the CREATE DB command from the mysql command prompt.
Does this meet the goal?

（A）Yes

（B）No

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

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. "Transaction (Process ID
65) was dedicated on locked resources with another process and has been chosen as the deadlock victim.
Rerun the transaction."
You need to identity the cause of the error.
Which view should you query?

（A）sys.resource_stats

（B）sys.dm_tran_locks

（C）sys.event_log

（D）sys.dm_os_wait_stats

正解：D 解答を投票する

質問 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result these questions will not appear in the review screen.
You have a Microsoft Azure Database for MySQL Server named SQLDB1.
Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the database resource in Azure.
Does this meet the goal?

（A）Yes

（B）No

正解：B 解答を投票する

質問 5

You have a Microsoft Azure SQL database.
You discover that the workload grows over time.
You are evaluating whether to switch to a higher service tier for the database.
You need to examine the system utilization trends over time.
Which dynamic management view should you query?

（A）sys.resource_stats

（B）sys.dm_db_missing_index_details

（C）sys.dm_exec_query_stats

（D）sys.events

正解：A 解答を投票する

質問 6

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 data.
You create an index.
You need to identify whether the performance of the reports significantly improves.
Which tool should you use?

（A）Query Store

（B）Database Engine Tuning Advisor

（C）SQL Server Profiler

（D）Live Query Statistics

正解：D 解答を投票する

質問 7

You have a Microsoft SQL Server database named DB1 in the data center of your company.
You export DB1 to a script file.
You need to import DB1 to a Microsoft Azure SQL database.
What should you use?

（A）dtutil.exe

（B）mssql-scripter.exe

（C）ssms.exe

（D）SqlLogShip.exe

正解：D 解答を投票する

質問 8

You manage a large Microsoft Azure SQL database. The database contains data that changes several thousand times each day.
You need to ensure that the performance of the database stays consistent when the data changes.
What should you do?

（A）Clear the procedure cache of the database.

（B）Enable Extended Events for the server that contains the database.

（C）Update the statistics of all the tables in the database.

（D）Run a consistency check on the tables in the database.

正解：D 解答を投票する

質問 9

You recently implemented a Microsoft Azure SQL data warehouse.
You discover that during peak hours, the data warehouse takes longer than expected to generate reports.
You need to reduce the amount of time it takes to generate the reports.
What should you do from the Azure portal?

（A）Increase the number of Database Throughput Units (DTUs).

（B）Increase the number of Data Warehouse Units (DWUs).

（C）Add storage to the data warehouse.

正解：A 解答を投票する

質問 10

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the az sql db create command from Azure Cloud Shell.
Does this meet the goal?

（A）Yes

（B）No

正解：B 解答を投票する

070-473 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」

弊社を連絡する

関連リンク

トップ試験