Microsoft Designing and Implementing Cloud Data Platform Solutions (070-473日本語版) - 070-473日本語 Exam Practice Test
Correct Answer:
Explanation
Box 1: Sys.dm_io_virtual_file_stats
Sys.dm_io_virtual_file_stats returns I/O statistics for data and log files.
Box 2:
Page reads/sec indicates the number of physical database page reads that are issued per second. This statistic displays the total number of physical page reads across all databases. Because physical I/O is expensive, you may be able to minimize the cost, either by using a larger data cache, intelligent indexes, and more efficient queries, or by changing the database design.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-io-virtual-
https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-cpu-usage?view=sql-ser
Correct Answer:
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
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Correct Answer:
Explanation
Box 1. Create a VHD from the SQL Server's C: Drive. The databases will be included on the C: drive by default.
Box 2. Use the Add-AzureVHD cmdlet to upload the VHD to Azure.
Box 3. Create a virtual machine using the uploaded VHD.
Correct Answer:
Explanation
Box 1: Azure Database for MySQL
Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service.
Box 2:
Incorrect Answres:
Not Azure Database for MySQL
You can create an Azure Database for MySQL server in one of three different pricing tiers: Basic, General Purpose, and Memory Optimized.
Scenario: 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. None of the developers at Tailspin Toys are skilled in using MySQL. DB2 is supported by a team of external developers.
DB2 is 20 GB and is expected to reach 50 GB during the next five years. DB2 has a storage performance requirement of 200 IOPs.
DB2 must be highly available.
Reference:
https://docs.microsoft.com/en-us/azure/mysql/concepts-pricing-tiers
https://azure.microsoft.com/en-us/services/mysql/