Correct Answer: B

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Correct Answer: B

A key/value store associates each data value with a unique key.

An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.

Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Correct Answer: A

Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

Correct Answer:

Box 1: Microsoft SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.

Box 2: Microsoft Visual Studio Code

Visual Studio Code is a streamlined code editor with support for development operations like debugging, task running, and version control. It aims to provide just the tools a developer needs for a quick code-build-debug cycle and leaves more

complex workflows to fuller featured IDEs, such as Visual Studio IDE.

Box 3: Azure Data Studio

Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets,

code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object

browsing experience.

Box 4: Microsoft SQL Server Data Tools (SSDT)

SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS)

reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

Reference:

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

https://code.visualstudio.com/docs/supporting/FAQ

https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

Correct Answer: