MS SQL Server - 50 - Tracking and Data Security MCQ

50 – Tracking and Data Security MCQ

Best of luck!

1 / 25

1. What is the primary purpose of Change Tracking in SQL Server?

To create backups of databases

To monitor server performance

To track changes made to data in a table

To design database schemas

2 / 25

2. In SQL Server, which statement is true about Change Tracking?

It is designed for auditing and compliance.

It requires the use of triggers.

It captures historical data changes.

It tracks changes at the server level.

3 / 25

3. What is the primary benefit of using Change Tracking in SQL Server?

It simplifies auditing and detecting data changes.

It provides real-time data synchronization.

It automatically creates database backups.

It tracks every individual data modification.

4 / 25

4. In SQL Server, how can you enable Change Tracking for a database?

By creating a new database schema

Using the ALTER DATABASE statement

Through the Configuration Manager tool

By running the CHECKDB command

5 / 25

5. Which SQL Server view can be used to query Change Tracking information for a table?

sys.change_tracking_tables

sys.dm_change_tracking_databases

sys.dm_change_tracking_states

sys.change_tracking

6 / 25

6. What is the primary purpose of Data Security in SQL Server?

To control access and protect sensitive data

To monitor server performance

To design database schemas

To create database backups

7 / 25

7. Which statement is true about Data Security in SQL Server?

It is used for designing database schemas.

It is only concerned with database backups.

It involves controlling access to data and protecting it from unauthorized access.

It focuses on improving query performance.

8 / 25

8. What is the primary benefit of using the “WITH CHECK OPTION” clause when creating a View in SQL Server?

To create a backup of the View

To generate execution plans for the View

To check the availability of the View

To ensure that data modifications through the View comply with the View's filter criteria

9 / 25

9. In SQL Server, what is the primary purpose of the “SCHEMABINDING” option when creating a View?

It simplifies the process of creating backups.

It allows the View to reference tables in any schema.

It binds the View to the schema of referenced objects and prevents schema changes.

It improves query performance.

10 / 25

10. Which SQL Server statement is true about Data Encryption?

Data Encryption protects data at rest but not during transmission.

Data Encryption protects data both at rest and during transmission.

Data Encryption is not supported in SQL Server.

Data Encryption is used only for monitoring server performance.

11 / 25

11. What is the primary purpose of Transparent Data Encryption (TDE) in SQL Server?

To create physical copies of data

To simplify complex queries

To monitor server performance

To protect data at rest by encrypting the entire database

12 / 25

12. In SQL Server, which statement is true about SQL Server Audit?

SQL Server Audit is used for auditing and compliance.

SQL Server Audit is not used for monitoring server performance.

SQL Server Audit is used for creating database backups.

SQL Server Audit tracks changes made to data.

13 / 25

13. What is the primary purpose of Column-level Encryption in SQL Server?

To monitor server performance

To simplify complex queries

To encrypt specific columns to protect sensitive data

To create physical copies of data columns

14 / 25

14. In SQL Server, which statement is true about Dynamic Data Masking?

Dynamic Data Masking dynamically masks sensitive data to limit exposure.

Dynamic Data Masking is used for monitoring server performance.

Dynamic Data Masking is used for creating backups.

Dynamic Data Masking permanently alters data in the database.

15 / 25

15. What is the primary benefit of using the “MASKED WITH FUNCTION” option in Dynamic Data Masking?

It creates a backup of the masked data.

It improves query performance.

It masks data using a custom masking function.

It allows access to the original unmasked data.

16 / 25

16. In SQL Server, what is the primary benefit of Row-Level Security (RLS)?

RLS simplifies complex queries.

RLS restricts data access based on user roles and filters.

RLS is used for creating backups.

RLS improves query performance by creating indexes.

17 / 25

17. Which statement is true about Data Security in SQL Server?

Data Security focuses on designing database schemas.

Data Security is primarily concerned with query performance.

Data Security involves controlling access to data and protecting it from unauthorized access.

Data Security is used for creating database backups.

18 / 25

18. In SQL Server, what is the primary purpose of the “GRANT” statement?

To assign server-level permissions to users

To create physical copies of data

To track changes made to data

To create a new database schema

19 / 25

19. What is the primary benefit of using Change Tracking in SQL Server?

It simplifies auditing and detecting data changes.

It provides real-time data synchronization.

It tracks every individual data modification.

It automatically creates database backups.

20 / 25

20. In SQL Server, which statement is true about the “DENY” statement?

It is used to remove a user from a role.

It is used to grant permissions to a user or role.

It provides ownership of the securable.

It is used to explicitly deny specific permissions to a user or role.

21 / 25

21. What is the primary purpose of the “WITH CHECK OPTION” clause when creating a View in SQL Server?

To generate execution plans for the View

To create a backup of the View

To check the availability of the View

To ensure that data modifications through the View comply with the View's filter criteria

22 / 25

22. In SQL Server, what is the primary purpose of the “SCHEMABINDING” option when creating a View?

It allows the View to reference tables in any schema.

It improves query performance.

It simplifies the process of creating backups.

It binds the View to the schema of referenced objects and prevents schema changes.

23 / 25

23. Which SQL Server statement is true about Data Encryption?

Data Encryption is not supported in SQL Server.

Data Encryption protects data both at rest and during transmission.

Data Encryption is used only for monitoring server performance.

Data Encryption protects data at rest but not during transmission.

24 / 25

24. What is the primary purpose of Transparent Data Encryption (TDE) in SQL Server?

To monitor server performance

To create physical copies of data

To protect data at rest by encrypting the entire database

To simplify complex queries

25 / 25

25. What is the primary purpose of the “WITH CHECK OPTION” clause when creating a View in SQL Server?

To check the availability of the View

To generate execution plans for the View

To create a backup of the View

To ensure that data modifications through the View comply with the View's filter criteria

Your score is

MS SQL Server – 50 – Tracking and Data Security MCQ