1. Which tool is commonly used for administering and managing SQL Server databases? A) SQL Server Integration Services (SSIS) B) SQL Server Reporting Services (SSRS) C) SQL Server Management Studio (SSMS) D) SQL Server Analysis Services (SSAS) 2. What is the primary purpose of SQL Server Profiler in SSMS? A) To design database schemas B) To manage database backups C) To monitor and capture database events and queries D) To optimize SQL queries 3. In SSMS, which option allows you to generate a script to backup a SQL Server database? A) Database Diagrams B) Object Explorer C) Query Editor D) Maintenance Plans
1. Which tool is commonly used for administering and managing SQL Server databases?
A) SQL Server Integration Services (SSIS)
B) SQL Server Reporting Services (SSRS)
C) SQL Server Management Studio (SSMS)
D) SQL Server Analysis Services (SSAS)
2. What is the primary purpose of SQL Server Profiler in SSMS?
A) To design
B) To manage database backups
C) To monitor and capture database events and queries
D) To optimize SQL queries
3. In SSMS, which option allows you to generate a script to backup a SQL Server database?
A) Database Diagrams
B) Object Explorer
C) Query Editor
D) Maintenance Plans
4. Which SQL Server feature in SSMS helps you track changes to database tables, such as inserts, updates, and
deletes?
A) SQL Server Profiler
B) SQL Server Agent
C) Change Data Capture (CDC)
D) Extended Events
ADI632 – Formative Assessment 3 Semester 2 Paper 2023 | V1.0 Page 4 of 6
5. In SSMS, which performance monitoring tool provides real-time information about SQL Server instances and their
performance metrics?
A) SQL Server Configuration Manager
B) SQL Server Profiler
C) SQL Server Agent
D) SQL Server Management Studio Activity Monitor
2.1 What is Data Access Control in SQL Server?
A) A feature that allows users to access data without any restrictions.
B) The process of controlling and regulating user access to SQL Server databases to ensure data security.
C) A tool for automatically generating SQL queries.
D) The process of creating backups of database files.
2.2 What does the term "Backup and Restore" refer to in SQL Server management?
A) The process of securing the SQL Server instance with a firewall.
B) The process of creating duplicate copies of data for testing purposes.
C) The process of making copies of database files to protect against data loss and facilitate recovery.
D) The process of importing data from external sources into SQL Server.
2.3 What is Auditing in SQL Server?
A) The process of creating automated reports in SQL Server.
B) A feature that allows users to edit and delete data without restrictions.
C) The process of tracking and logging database activities and events for security and compliance purposes.
D) A tool for optimizing SQL queries.
2.4 What is SQL Server Profiler used for in the context of managing and monitoring SQL Server instances?
A) To manage user access permissions.
B) To create and manage database backups.
C) To monitor and capture database events and queries for analysis and troubleshooting.
D) To automatically generate SQL queries.
2.5 What is a SQL Server Instance?
A) A specific version of SQL Server software.
B) A collection of database tables.
C) A logical container that represents a separate installation of SQL Server on a computer.
D) A backup file format used by SQL Server.
Step by step
Solved in 4 steps
