MS SQL Server - 11 - SSMS and Azure Data Studio MCQ

11 – SSMS and Azure Data Studio MCQ

Best of luck!

1 / 25

1. What is SSMS?

Storage System Management Studio

Structured Storage Management System

Server Security Management Software

SQL Server Management Studio

2 / 25

2. Which of the following tasks can you perform using SSMS?

Designing graphics

Managing SQL Server instances

Editing HTML files

Creating web applications

3 / 25

3. What is Azure Data Studio?

A cloud-based email service

A video conferencing software

A free, open-source, cross-platform database tool

An e-commerce platform

4 / 25

4. Which operating systems are supported by Azure Data Studio?

Linux only

macOS only

Windows only

Windows, macOS, and Linux

5 / 25

5. Which of the following is true about Azure Data Studio’s extensibility?

Extensibility is limited to Azure services.

It supports a wide range of extensions contributed by the community.

It does not support extensions or plugins.

You can only use Microsoft-developed extensions.

6 / 25

6. Which tool is more lightweight and suited for cross-platform use?

SQL Server Profiler

SSMS

Visual Studio

Azure Data Studio

7 / 25

7. What type of scripting languages can you use in SSMS for automating tasks?

PowerShell only

Python only

JavaScript only

Both PowerShell and Python

8 / 25

8. Which of the following is NOT a feature of Azure Data Studio?

Jupyter notebook integration

Built-in SQL Server Reporting Services

Git version control

Integrated terminal

9 / 25

9. Which tool is primarily designed for Windows-based development and management?

Azure Data Studio

SSMS

Visual Studio Code

SQL Server Configuration Manager

10 / 25

10. Which tool provides a customizable dashboard for monitoring and managing SQL Server instances?

SQL Server Agent

SSMS

Azure Data Studio

SQL Server Profiler

11 / 25

11. What is the primary purpose of the SQL Server Profiler tool?

Monitoring and capturing SQL Server events

Creating database diagrams

Writing T-SQL queries

Managing database security

12 / 25

12. Which tool is known for its performance tuning and troubleshooting capabilities?

Azure Data Studio

SQL Server Configuration Manager

SSMS

SQL Server Profiler

13 / 25

13. In Azure Data Studio, what is the purpose of the “Integrated Terminal”?

It generates reports.

It allows you to play video games.

It provides a command-line interface for executing queries and scripts.

It is used for sending emails.

14 / 25

14. Which tool is recommended for managing SQL Server on Linux systems?

SSMS

SQL Server Configuration Manager

SQL Server Agent

Azure Data Studio

15 / 25

15. In Azure Data Studio, what is the primary use of the “Notebooks” feature?

Sending emails

Creating music playlists

Writing poetry

Documenting and running code, queries, and visualizations

16 / 25

16. What is the primary benefit of using Azure Data Studio over SSMS for database development?

It is more suitable for enterprise-level applications.

It provides better security features.

It is a cloud-only tool.

It supports multiple platforms and is more lightweight.

17 / 25

17. What does SSMS use for managing SQL Server instances?

A web-based interface

A command-line interface

A mobile app

A graphical user interface (GUI)

18 / 25

18. In Azure Data Studio, what is the purpose of the “Source Control” tab?

It is used for playing audio files.

It is for configuring network settings.

It provides access to cloud storage.

It allows you to manage version control of your scripts and queries.

19 / 25

19. Which tool is best suited for data modeling and creating entity-relationship diagrams?

SQL Server Configuration Manager

SQL Server Profiler

SSMS

Azure Data Studio

20 / 25

20. In Azure Data Studio, what is the “SQL Server Import” extension used for?

Importing data from text files only

Importing data from cloud storage

Importing data from FTP servers

Importing data from a wide range of sources into SQL Server

21 / 25

21. Which tool offers native support for Jupyter notebooks?

SQL Server Profiler

Azure Data Studio

SQL Server Agent

SSMS

22 / 25

22. In Azure Data Studio, which language is commonly used for writing code cells in notebooks?

Python

Java

C++

Ruby

23 / 25

23. What is the purpose of the “Manage Extensions” feature in Azure Data Studio?

It is used for configuring database backups.

It allows you to create new databases.

It enables you to install and manage extensions and plugins.

It allows you to uninstall the application.

24 / 25

24. Which tool provides a more extensive set of administrative capabilities for SQL Server?

SQL Server Profiler

SSMS

Azure Data Studio

SQL Server Configuration Manager

25 / 25

25. What is the primary advantage of using Azure Data Studio for SQL Server development in a multi-platform environment?

It is lightweight and supports multiple operating systems.

It offers better security features.

It provides a more extensive set of administrative tools.

It is a cloud-only tool.

Your score is

MS SQL Server – 11 – SSMS and Azure Data Studio MCQ