MS SQL Server - 10 - Azure Data Studio MCQ

10 – Azure Data Studio MCQ

Best of luck!

1 / 25

1. What is Azure Data Studio primarily used for?

Writing and executing SQL queries

Creating web applications

Developing mobile applications

Managing virtual machines

2 / 25

2. Which operating systems are supported for the installation of Azure Data Studio?

Windows and Linux only

Windows and macOS only

Windows, macOS, and Linux

macOS and Linux only

3 / 25

3. What programming language is primarily used in Azure Data Studio for writing queries and scripts?

Python

JavaScript

T-SQL

4 / 25

4. In Azure Data Studio, how can you customize the color theme of the code editor?

Through the "Color Theme" settings in the preferences

By selecting from pre-defined themes only

By editing the CSS files directly

There is no option to customize the color theme.

5 / 25

5. What is the purpose of the “Object Explorer” in Azure Data Studio?

To manage virtual machines

To write code and scripts

To explore the Azure cloud services

To browse and interact with database objects

6 / 25

6. How can you install extensions and add-ons in Azure Data Studio?

By using the Azure Portal

Through the built-in extension marketplace

By writing custom code

Only by downloading files from external websites

7 / 25

7. What is the primary function of “Database Dashboards” in Azure Data Studio?

To create new databases

To monitor database performance and health

To design web applications

To write and execute SQL queries

8 / 25

8. What is the default scripting language used in the code editor of Azure Data Studio?

Ruby

T-SQL

Python

JavaScript

9 / 25

9. In Azure Data Studio, how can you configure the font size and style of the code editor?

There is no option to configure font size and style.

By modifying the operating system settings

Through the "Editor Font" settings in the preferences

By selecting from a limited set of fixed fonts only

10 / 25

10. What is the purpose of the “Customization” feature in Azure Data Studio?

To develop custom extensions and add-ons

To change the software's core functionality

To modify the source code of Azure Data Studio

To personalize the user interface and settings

11 / 25

11. Which of the following platforms is NOT officially supported for Azure Data Studio?

macOS

Android

Windows

Linux

12 / 25

12. In Azure Data Studio, how can you switch between multiple open code editor tabs?

By clicking on the tab titles

There is no way to switch between tabs.

Through the "View" menu

By using keyboard shortcuts only

13 / 25

13. What is the main advantage of using Azure Data Studio over SQL Server Management Studio (SSMS)?

Azure Data Studio supports only T-SQL.

Azure Data Studio is free and open source.

Azure Data Studio does not support extensions.

Azure Data Studio is available for Windows only.

14 / 25

14. Which feature in Azure Data Studio allows you to create and manage database projects?

Customization

Code Editor

Object Explorer

Database Dashboards

15 / 25

15. What is the purpose of the “Server Group” feature in Azure Data Studio’s Object Explorer?

To organize and categorize database servers

To manage virtual machine instances

To configure server hardware

To group servers for cloud deployment

16 / 25

16. In Azure Data Studio, how can you connect to a remote database server?

Azure Data Studio does not support remote connections.

By specifying the server name and authentication credentials

By accessing it through a web browser

By using a USB connection

17 / 25

17. What is the primary purpose of “Database Projects” in Azure Data Studio?

To develop mobile applications

To create virtual machines

To store database schema and scripts in version control

To manage cloud services

18 / 25

18. How can you create a new database in Azure Data Studio?

By writing a T-SQL script

By using the Azure Portal

There is no way to create databases in Azure Data Studio.

By clicking the "Create Database" button in the Object Explorer

19 / 25

19. What is the purpose of the “Custom Scripts” folder in Azure Data Studio’s Object Explorer?

To manage server configurations

To store system scripts provided by Microsoft

To execute scripts automatically when Azure Data Studio starts

To store custom scripts and queries for easy access

20 / 25

20. Which of the following is NOT a common use case for Azure Data Studio?

Monitoring database performance

Managing database servers

Developing web applications

Writing and executing SQL queries

21 / 25

21. What is the main advantage of using “Snippets” in Azure Data Studio’s code editor?

They allow you to create custom themes for the code editor.

They enable database project management.

They provide code suggestions and auto-completions.

They allow you to run code without typing it manually.

22 / 25

22. Which feature in Azure Data Studio allows you to explore and visualize data stored in a database?

Customization

Code Editor

Data Explorer

Object Explorer

23 / 25

23. In Azure Data Studio, how can you enable dark mode or light mode for the user interface?

By using keyboard shortcuts

Through the "Appearance" settings in the preferences

By modifying the operating system settings

There is no option to change the user interface mode.

24 / 25

24. What is the purpose of the “Object Explorer Details” pane in Azure Data Studio?

To configure server hardware

To execute SQL scripts

To provide details about selected objects in the Object Explorer

To display execution plans

25 / 25

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

To manage database projects

To organize queries into folders

To create custom keyboard shortcuts

To write and execute SQL queries

Your score is

MS SQL Server – 10 – Azure Data Studio MCQ