070-473 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」
You have a Microsoft Azure Infrastructure as a Service (IaaS) environment that contains a 3-TB data warehouse.
You need to recommend a solution to improve the read performance of the database. The solution must maintain data integrity.
Which task should you include in the recommendation?
You need to recommend a solution to improve the read performance of the database. The solution must maintain data integrity.
Which task should you include in the recommendation?
正解：D
解答を投票する
You plan to prepare the environment for the planned new customers.
You need to deploy a base copy of DB1 for each customer in Azure.
Which cmdlets should you use in the Azure PowerShell script? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
You need to deploy a base copy of DB1 for each customer in Azure.
Which cmdlets should you use in the Azure PowerShell script? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正解：
Explanation
Box 1: Get-AzureRmSqlDatabase
The Get-AzureRmSqlDatabase cmdlet gets one or more Azure SQL databases from an Azure SQL Database Server.
Partial syntax:
Get-AzureRmSqlDatabase
[[-DatabaseName] <String>]
[-ServerName] <String>
[-ResourceGroupName] <String>
Box 2: Restore-AzureRmSqlDatabase
The Restore-AzureRmSqlDatabase cmdlet restores a SQL database from a geo-redundant backup, a backup of a deleted database, a long term retention backup, or a point in time in a live database. The restored database is created as a new database.
Partial syntax:
Restore-AzureRmSqlDatabase
[-FromLongTermRetentionBackup]
-ResourceId <String>
-ServerName <String>
-TargetDatabaseName <String>
[-Edition <String>]
[-ServiceObjectiveName <String>]
[-ElasticPoolName <String>]
[-AsJob]
[-LicenseType <String>]
[-ResourceGroupName] <String>
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Reference:
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/get-azurermsqldatabase?view=azurermps-6.7.0
https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/restore-azurermsqldatabase?view=azurermps-6
You need to identify the appropriate data architecture for App1. The solution must support the planned changes.
Which storage platforms should you identify for App1? To answer, drag the appropriate storage platforms to the correct data types. Each storage platform may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content NOTE: Each correct selection is worth one point
Which storage platforms should you identify for App1? To answer, drag the appropriate storage platforms to the correct data types. Each storage platform may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content NOTE: Each correct selection is worth one point
正解：
Explanation
You have several instances of Microsoft SQL Server on several Microsoft Azure virtual machines.
You need to implement an automated process to back up all of the virtual machines to an Azure storage account. The process must run weekly.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You need to implement an automated process to back up all of the virtual machines to an Azure storage account. The process must run weekly.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation
References:
https://blogs.technet.microsoft.com/cbernier/2014/04/28/back-up-an-azure-vm-using-microsoft-azure-automation
A marketing department manager reports that the marketing department database contains incorrect data. The manager reports that the data was correct yesterday.
You need to recommend a method to recover the data.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You need to recommend a method to recover the data.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation
Your company identifies a stored procedure that runs slowly.
You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan operator as shown in the exhibit. (Click the Exhibit button.)
The stored procedure contains the following code.
You need to improve the performance of the stored procedure.
What should you do?
You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan operator as shown in the exhibit. (Click the Exhibit button.)
The stored procedure contains the following code.
You need to improve the performance of the stored procedure.
What should you do?
正解：B
解答を投票する