070-473 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」
Relecloud recently implemented the planned changes.
you plan to add a new customer named Fabrikam, Inc.
You need to ensure that the administrators at Fabrikam can access their data after the data loading process.
You collect the IP addresses used by the Fabrikam administrators.
Which Transact-SQL command or Azure PowerShell cmdlet should you use next?
you plan to add a new customer named Fabrikam, Inc.
You need to ensure that the administrators at Fabrikam can access their data after the data loading process.
You collect the IP addresses used by the Fabrikam administrators.
Which Transact-SQL command or Azure PowerShell cmdlet should you use next?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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?
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?
正解：D
解答を投票する
Your environment contains a Microsoft Azure virtual machine and an Azure SQL database. The virtual machine has Microsoft SQL Server installed and contains several applications. You need to recommend a solution to migrate one of the applications to the Azure SQL database. The solution must minimize downtime.
Which solution should you recommend?
Which solution should you recommend?
正解：A
解答を投票する
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?
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?
正解：D
解答を投票する
Your company has two offices located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft Azure SQL database. Currently, only the users in the London office use the database.
You plan to provide the users in the New York office with access to the database.
You need to ensure that the New York office users can access the database.
Which command should you execute?
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft Azure SQL database. Currently, only the users in the London office use the database.
You plan to provide the users in the New York office with access to the database.
You need to ensure that the New York office users can access the database.
Which command should you execute?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You need to back up the Listings database to meet the high-availability and recovery requirements.
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.
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
You are designing a hybrid data analytics solution that contains an on-premises Microsoft SQL Server environment and a Microsoft Azure SQL data warehouse.
You need to load data warehouse from the SQL Server environment as quickly as possible.
Which four 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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You need to load data warehouse from the SQL Server environment as quickly as possible.
Which four 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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
正解：
Explanation
