MS SQL Server - 61 - Disk Storage MCQ

61 – Disk Storage MCQ

1 / 25

1. What is a data page in SQL Server?

A type of database schema

A database index

A physical storage unit for data

A virtual table

2 / 25

2. Which of the following is a property of data pages in SQL Server?

Data retrieval speed

Transaction management

Compression

Data encryption

3 / 25

3. In SQL Server, what is the purpose of a data page header?

To store table schema information

To compress data

To identify the page type and allocation unit

To store user data

4 / 25

4. Which type of data page in SQL Server contains actual user data?

Index page

GAM page

IAM page

Data page

5 / 25

5. What is the purpose of an Index Allocation Map (IAM) page in SQL Server?

To manage table schemas

To control access permissions

To map index pages to data pages

To store actual data

6 / 25

6. Which type of data page in SQL Server contains information about the structure of a table?

Data page

IAM page

GAM page

Index page

7 / 25

7. In SQL Server, what is the purpose of a Global Allocation Map (GAM) page?

To manage data encryption

To manage page allocations across all databases

To store user data

To map index pages to data pages

8 / 25

8. Which type of data page in SQL Server contains allocation information for extents?

GAM page

Data page

IAM page

Index page

9 / 25

9. What is the primary function of a Page Free Space (PFS) page in SQL Server?

To manage page allocations

To track page usage

To compress data

To store actual data

10 / 25

10. In SQL Server, what is the purpose of a Shared Global Allocation Map (SGAM) page?

To manage page allocations in a shared extent

To store user data

To map index pages to data pages

To manage data encryption

11 / 25

11. What is the purpose of editing information concerning disk storage in SQL Server?

To optimize query performance

To manage data encryption

To control user access permissions

To modify table schemas

12 / 25

12. In SQL Server, what happens when you edit information concerning disk storage?

Data layout and allocation are modified.

Data is permanently deleted.

Data is encrypted.

Data is compressed.

13 / 25

13. Which SQL Server component allows you to visually edit and manage the layout of data pages?

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

SQL Server Management Studio (SSMS)

SQL Server Analysis Services (SSAS)

14 / 25

14. What is the primary benefit of parallel processing of tasks in SQL Server?

Improved data encryption

Efficient management of data schemas

Faster data retrieval and query execution

Enhanced data compression

15 / 25

15. In SQL Server, what is the purpose of parallel processing of tasks?

To edit data schemas

To increase query concurrency and performance

To compress data

To encrypt data

16 / 25

16. What is the term for the ability of SQL Server to execute multiple tasks simultaneously on multiple processors?

Multithreading

Parallelism

Scalability

Multiprocessing

17 / 25

17. Which of the following is NOT a benefit of parallel processing in SQL Server?

Improved query performance

Enhanced concurrency

Reduced query execution time

Efficient data compression

18 / 25

18. In SQL Server, what is the primary factor that determines whether a query can benefit from parallel processing?

The type of data encryption used

The query complexity and hardware resources

The amount of data to compress

The database schema

19 / 25

19. What is the primary role of the query optimizer in SQL Server’s parallel processing?

To determine the optimal query execution plan

To encrypt data

To compress data

To manage data schemas

20 / 25

20. Which SQL Server feature allows you to control and fine-tune parallelism for specific queries?

Query Execution Plan

Query Analyzer

Resource Governor

Query Performance Monitor

21 / 25

21. In SQL Server, what is the purpose of the Resource Governor?

To control parallelism and resource usage for specific queries

To manage data encryption

To compress data

To edit database schemas

22 / 25

22. What is the primary advantage of using the Resource Governor in SQL Server?

Predictable and controlled query performance

Improved data compression

Efficient query execution plans

Better data encryption

23 / 25

23. Which SQL Server tool is used to view and analyze the execution plan of a query?

SQL Server Management Studio (SSMS)

SQL Server Query Analyzer

SQL Server Profiler

SQL Server Data Tools (SSDT)

24 / 25

24. In SQL Server, what does the execution plan show?

The query's results

The query's source code

The query's encryption settings

The steps and operations performed by the query optimizer

25 / 25

25. Which of the following is NOT a common type of data page in SQL Server?

Index page

Data page

IAM page

Query page

Your score is

MS SQL Server – 61 – Disk Storage MCQ