Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

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://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

DRAG DROP

Match the types of workloads the appropriate scenario.

To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type 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:

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

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Reveal Solution Hide Solution

DRAG DROP

Match the tools to the appropriate descriptions.

To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool 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:

HOTSPOT

You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://en.wikipedia.org/wiki/Snowflake_schema

https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

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:

What should you use to build a Microsoft Power BI paginated report?

Reveal Solution Hide Solution