Microsoft 070-473 Actual Free Exam Questions & Community Discussion
You need to implement a solution to meet the technical requirements for the database administrators.
Which three actions should you perform in sequence from the Azure portal? 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 from the Azure portal? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
Explanation
You have several SQL Server instances on Microsoft Azure virtual machines.
Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to
30 minutes. You investigate the issue and discover that when the issue occurs, there is high CPU usage on the virtual machines.
You need to be notified automatically when the performance issue occurs. You want to achieve this goal by using the minimum amount of administrative effort.
What should you configure?
Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists for up to
30 minutes. You investigate the issue and discover that when the issue occurs, there is high CPU usage on the virtual machines.
You need to be notified automatically when the performance issue occurs. You want to achieve this goal by using the minimum amount of administrative effort.
What should you configure?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Your company has an application that uses several Microsoft Azure SQL databases. New databases are added regularly as customers sign up for new services. Databases are removed regularly as customers cancel the services.
You create an auditing policy.
You plan to configure auditing for all of the databases.
You need to ensure that all of the databases are audited constantly.
Which cmdlet should you use?
You create an auditing policy.
You plan to configure auditing for all of the databases.
You need to ensure that all of the databases are audited constantly.
Which cmdlet should you use?
Correct Answer: D
Vote an answer
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.
Correct Answer:
Explanation
References:
https://msdn.microsoft.com/en-us/library/dn765131.aspx
You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine.
You need to ensure that all SQL Server audits are written to the Windows Security log.
Which two actions should you perform? Each correct answer presents part of the solution.
You need to ensure that all SQL Server audits are written to the Windows Security log.
Which two actions should you perform? Each correct answer presents part of the solution.
Correct Answer: A,B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
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 have a Microsoft Azure Database for MySQL Server named SQLDB1.
Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the database resource in Azure.
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 have a Microsoft Azure Database for MySQL Server named SQLDB1.
Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the database resource in Azure.
Does this meet the goal?
Correct Answer: B
Vote an answer
You are designing the database for a new application. The application will have 7,500 users located in New York and 2,500 users located in Paris. Users of the application will load large amounts of data into a database in their region.
You need to recommend an architecture that will minimize latency while data is loaded.
What are two possible architectures that achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
You need to recommend an architecture that will minimize latency while data is loaded.
What are two possible architectures that achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
Correct Answer: B,D
Vote an answer
You need to create a Microsoft Azure Resource manager template.
Which file format should you use?
Which file format should you use?
Correct Answer: A
Vote an answer
0
0
0
10