You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.

You need to embed documents and query results into a SQL notebook.

What should you use?

Reveal Solution Hide Solution

DRAG DROP

Match the terms to the appropriate descriptions.

To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://en.wikipedia.org/wiki/Table_(database)#:~:text=A%20table%20is%20a%20collection,table%20format%20within%20a%20database.&text=In%20relational%20databases%2C%20and%20flat,a%20row%20and%20column%20intersect.

https://en.wikipedia.org/wiki/View_(SQL)

https://en.wikipedia.org/wiki/Database_index#:~:text=A%20database%20index%20is%20a,maintain %20the%20index%20data%20structure.

Which command-line tool can you use to query Azure SQL databases?

Reveal Solution Hide Solution

HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/

HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms

https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

HOTSPOT

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/

https://azure.microsoft.com/en-us/services/sql-database/#product-overview

Which statement is an example of Data Definition Language (DDL)?

Reveal Solution Hide Solution

HOTSPOT

To complete the sentence, select the appropriate option in the answer area.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure

SQL database.

Which type of authentication should you use?

Reveal Solution Hide Solution

HOTSPOT

To complete the sentence, select the appropriate option in the answer area.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql