最新的Microsoft Designing and Implementing Cloud Data Platform Solutions - 070-473免費考試真題
You have a Microsoft Azure SQL database. You need to audit the data access of the database owners who use Microsoft SQL Server Management Studio.
What should you enable?
What should you enable?
正確答案: A
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You need to tell the research project leaders how to migrate their databases.
Which task should you instruct the leaders to use from SQL Server Management Studio?
You need to tell the research project leaders how to migrate their databases.
Which task should you instruct the leaders to use from SQL Server Management Studio?
正確答案: D
說明：（僅 Fast2test 成員可見）
You have a Microsoft Azure SQL database named DB1 and a copy of DB1 named DB1Test.
You use DB1Test to test the deployment of major updates to the database.
You discover that DB1Test contains outdated data.
You need to ensure that DB1Test contains recent data from DB1.
Which two statements should you execute? Each correct answer presents part of the solution.
Not: Each correct selection is worth one point.
You use DB1Test to test the deployment of major updates to the database.
You discover that DB1Test contains outdated data.
You need to ensure that DB1Test contains recent data from DB1.
Which two statements should you execute? Each correct answer presents part of the solution.
Not: Each correct selection is worth one point.
正確答案: D,E
You have a Microsoft Azure SQL database named Database1.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
正確答案:
Explanation
You need to implement the monitoring solution for the Listings database.
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
Topic 1, ADatumCorporationOverview
General Overview
ADatumCorporation is a real estate firm that has offices throughout North America.
ADatumhas a main office and four branch offices. The main office is located in Seattle. The branch offices are located in New York, Montreal, Denver, and Vancouver.
Existing Environment
Network Infrastructure
The network contains one Active Directory domain namedADatum.com. Each office contains one domain controller.
Each office has a 100-Mbps connection to the Internet that is 20 percent saturated on average. The offices connect to each other through the Internet by using VPN appliances.
ADatumuses the public IP addresses shown in the following table.
SQL Server Infrastructure
In the main office,ADatumhosts a Microsoft SQL Server instance on a server named SQL1. SQL1 has a
400-GB database named Listings. Log-shipped copies of Listings are present in each branch office. The copies are used for reporting. Currently, all of the SQL Server instances run SQL Server 2014 Enterprise edition.
Each branch office has an application server that hosts an application named App1. App1 is configured to connect to the Listings database on each local SQL Server instance for reporting and to connect to the SQL Server instance in the main office for any updates to property listings.
The main office also has an application server that hosts App1. The application server connects to the local Listings database for reporting and for any updates to the property listings.
Historic activity of the Listings database shows a maximum of 475 concurrent requests from as many as 200 concurrent connections.
User Issues
Users report that, frequently, they are disconnected from the Listings database when they run reports. Users also report that there is an unacceptable delay between when a property listing is updated and when the updated listing appears in the listings reports.
Developers report concerns about the lack of a testing environment in which code changes can be validated before being deployed to the production Listings database.
Requirements
Business Requirements
ADatumidentifies the following business requirements:
Planned changes
ADatumplans to implement the following changes:
Technical Requirements
ADatumidentifies the following technical requirements:
High-Availability and Recovery Requirements
ADatumidentifies the following high-availability and recovery requirements:
You have an Azure SQL Database elastic database pool that contains two databases named database1 and database2.
Users of database1 report poor performance during peak business hours.
You discover that database2 consumes most of the available resources.
You need to resolve the performance issue.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Users of database1 report poor performance during peak business hours.
You discover that database2 consumes most of the available resources.
You need to resolve the performance issue.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
正確答案: A,D
You need to create a Microsoft Azure Resource manager template.
Which file format should you use?
Which file format should you use?
正確答案: A
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?
正確答案: A
You need to configure server-level access to the ListTest database. adatum What statement should you use? To answer, drag the appropriate elements to the correct locations. Each element may be used 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 may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正確答案:
Explanation
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 plan to configure auditing for a Microsoft SQL Server instance that contains 17 databases.
You need to audit all of the SELECT statements that are executed against all of the databases. The solution must ensure that all gathered information is written to the application log.
Solution: You create a Server Audit Specification in the master database.
Does this meet the goal?
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 plan to configure auditing for a Microsoft SQL Server instance that contains 17 databases.
You need to audit all of the SELECT statements that are executed against all of the databases. The solution must ensure that all gathered information is written to the application log.
Solution: You create a Server Audit Specification in the master database.
Does this meet the goal?
正確答案: A
You have a Microsoft Azure SQL database. You need to configure the database to issue an alert when DTU consumption reaches 80 percent.
What should you create?
What should you create?
正確答案: A
說明：（僅 Fast2test 成員可見）
You plan to implement row-level security for the CWDB database.
You create the fn_limitusers function under the restriction schema.
You need to create the policy.
How should you complete the policy? To answer, drag the appropriate elements to the correct locations. Each element 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.
You create the fn_limitusers function under the restriction schema.
You need to create the policy.
How should you complete the policy? To answer, drag the appropriate elements to the correct locations. Each element 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.
正確答案:
Explanation
References:
https://msdn.microsoft.com/en-us/library/dn765131.aspx