Exam 70-764 topic 1 question 167 discussion

Actual exam question from Microsoft's 70-764

Question #: 167
Topic #: 1

DRAG DROP -
You plan to deploy a database by using SQL Server 2014. Your company identifies the following requirements for the database:
✑ The name of all stored procedures must start with "usp_"always.
✑ All distribution statistics must be updated daily.
You need to identify which feature must be used to meet each database requirement.
Which features should you identify? To answer, drag the appropriate feature to the correct database requirement in the answer area.
Select and Place:

Show Suggested Answer

Suggested Answer:

- Policy-Based Management Each Stored Procedure that are created and that will be created has to have prefix "USP_".
- Maintenance plans create a workflow of the tasks required to make sure that your database is optimized, regularly backed up, and free of inconsistencies.

by TheSwedishGuy at Jan. 29, 2020, 3:04 p.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 5 months ago

To enforce the naming policy, used Policy Based Management. Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL Server instances. It's used for monitoring and enforcing a standard set of policies for SQL Server throughout an organization.

upvoted 2 times

...