MS SQL Server - 64 - Policy-Based Management MCQ

64 – Policy-Based Management MCQ

1 / 25

1. What is Policy-Based Management (PBM) in SQL Server?

A method for storing database backups

A tool for creating database indexes

A feature for managing database schemas

A framework for enforcing and monitoring compliance with policies

2 / 25

2. In SQL Server, what is a policy?

A database backup schedule

A set of rules and conditions

A database index

A set of database roles

3 / 25

3. What is the primary purpose of Policy-Based Management in SQL Server?

To manage database schemas

To monitor query performance

To enforce and monitor compliance with policies

To enforce security policies

4 / 25

4. Which SQL Server component is used to define and manage policies?

SQL Server Configuration Manager

SQL Server Management Studio (SSMS)

SQL Server Profiler

SQL Server Agent

5 / 25

5. What is a condition in the context of Policy-Based Management in SQL Server?

A specific database schema

A rule that defines policy compliance

A backup schedule

A database index

6 / 25

6. In SQL Server, what is the role of a facet in Policy-Based Management?

A database schema

A rule that defines policy compliance

A container for policies

A type of database backup

7 / 25

7. What does the term “faceted search” mean in the context of Policy-Based Management in SQL Server?

Searching for database roles

Searching for database indexes

Searching for policies within SQL Server

Searching for database schemas

8 / 25

8. Which of the following is NOT a common facet in Policy-Based Management in SQL Server?

Index Facet

Server Facet

Policy Facet

Database Facet

9 / 25

9. What is the purpose of a target in Policy-Based Management in SQL Server?

To identify the object or objects to be evaluated by a policy

To enforce security policies

To specify the type of database backup

To define the database schema

10 / 25

10. In SQL Server, what is a condition expression?

A logical expression that defines policy compliance

A database schema definition

A database backup schedule

A mathematical formula

11 / 25

11. Which SQL Server component is used to evaluate policies and generate compliance reports?

SQL Server Management Studio (SSMS)

SQL Server Agent

SQL Server Configuration Manager

SQL Server Profiler

12 / 25

12. What is the primary role of the Central Management Server in Policy-Based Management?

To store database backups

To centralize policy management and evaluation

To monitor query performance

To manage database schemas

13 / 25

13. In SQL Server, what does the “Check On Change” option for a policy mean?

The policy is checked when there is a change in the database.

The policy is checked only when a new database is created.

The policy is checked only during server startup.

The policy is checked periodically at predefined intervals.

14 / 25

14. What is the purpose of the “Policy Health State” in Policy-Based Management?

To evaluate the effectiveness of policies

To create database indexes

To define database schemas

To schedule database backups

15 / 25

15. In SQL Server, what is the “Check Mode” of a policy?

The mode for managing database schemas

The mode in which the policy is evaluated

The mode for database backups

The mode for creating indexes

16 / 25

16. What is the difference between “On Demand” and “On Schedule” evaluation modes in Policy-Based Management?

Both modes evaluate policies only during server startup.

"On Demand" evaluates policies only during server startup, while "On Schedule" evaluates policies when a change occurs.

Both modes evaluate policies at predefined intervals.

"On Demand" evaluates policies when a change occurs, while "On Schedule" evaluates policies at predefined intervals.

17 / 25

17. In SQL Server, what is the “Recursion Mode” in Policy-Based Management?

The mode for database backups

The mode in which child objects are evaluated

The mode for creating indexes

The mode for managing database schemas

18 / 25

18. Which SQL Server facet is used to define and evaluate policies related to server-level configurations?

Index Facet

Server Facet

Database Facet

Policy Facet

19 / 25

19. What is the purpose of the “Check Frequency” option in Policy-Based Management?

To create database indexes

To define database schemas

To manage database roles

To specify how often a policy is evaluated

20 / 25

20. In SQL Server, what is the “Enforce” action of a policy?

The action that defines database schemas

The action that enforces the policy rules

The action that manages query performance

The action that defines the policy

21 / 25

21. Which action is typically taken when a policy is evaluated and found to be non-compliant in Policy-Based Management?

The policy is automatically disabled.

The policy is ignored.

The policy is modified.

A compliance report is generated.

22 / 25

22. What is the purpose of the “Automatically fix this problem” option in Policy-Based Management?

To create database indexes

To automatically remediate policy violations

To enforce security policies

To define database schemas

23 / 25

23. Which SQL Server facet is used to define and evaluate policies related to database-level configurations?

Database Facet

Index Facet

Server Facet

Policy Facet

24 / 25

24. In SQL Server, what is the “Check On Schedule” option for a policy?

The policy is checked periodically at predefined intervals.

The policy is checked only when a new database is created.

The policy is checked when there is a change in the database.

The policy is checked only during server startup.

25 / 25

25. What is the purpose of the “Schedule” option in Policy-Based Management?

To enforce security policies

To create database indexes

To specify when a policy is evaluated in "On Schedule" mode

To define database schemas

Your score is

MS SQL Server – 64 – Policy-Based Management MCQ