070-473日本語無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions (070-473日本語版)」

質問 1

（A）sys.resource_stats

（B）sys.dm_db_missing_index_details

（C）sys.dm_exec_query_stats

（D）sys.events

正解：A 解答を投票する

質問 2

（A）Yes

（B）No

正解：B 解答を投票する

質問 3

正解：

Explanation

質問 4

（A）a maintenance plan

（B）BACKUP TO URL

（C）AlwaysOn Availability Groups

（D）AlwaysOn failover clustering

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

質問 5

（A）Set-AzureRmSqlServerFirewallRule

（B）new-AzureRmSqlServerFirewallRule

（C）sp_set_database_firewall_rule

（D）sp_set_firewall_rule

正解：B 解答を投票する

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

質問 6

正解：

Explanation

References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-monitoring-with-dmvs/

質問 7

正解：

Explanation

Box 1: mysqldump
Use common utilities and tools such as MySQL Workbench, mysqldump, Toad, or Navicat to remotely connect and restore data into Azure Database for MySQL.
Box 2: azcopy
AzCopy is a command-line tool for copying data to or from Azure Blob storage, Azure Files, and Azure Table storage, by using simple commands. The commands are designed for optimal performance. You can copy data between a file system and a storage account, or between storage accounts.
App2 is developed by using third-party open source code that is updated frequently. The database for App2 is named DB2. App2 only supports MySQL.
Reference:
https://docs.microsoft.com/en-us/azure/mysql/concepts-migrate-import-export
https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-migrate-on-premises-data?tabs=win

質問 8