DRAG DROP

Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.

To answer, drag the appropriate term from the column on the left to its level 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:

Box 1: Azure Storage account

Azure file shares are deployed into storage accounts, which are top-level objects that represent a shared pool of storage.

Box 2: File share

Reference: https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share

HOTSPOT

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

Reveal Solution Hide Solution

Correct Answer:

Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends.

Which type of data store should you use?

Reveal Solution Hide Solution

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

Reveal Solution Hide Solution

Which setting can only be configured during the creation of an Azure Cosmos DB account?

Reveal Solution Hide Solution

DRAG DROP

Match the types of data to the appropriate Azure data services.

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

Explanation:

Box 1: Image files

Azure Blob storage is suitable for image files.

Box 2: Key/value pairs

Azure CosmosDB table API is a key-value storage hosted in the cloud.

Box 3: Relationship between employees

One-to-many relationships between business domain objects occur frequently: for example, one department has many employees. There are several ways to implement one-to-many relationships in the Azure Table service.

Reference: https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling

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:

Which statement is an example of Data Manipulation Language (DML)?

Reveal Solution Hide Solution

You have a SQL query that combines customer data and order dat a. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query.

What should you create?

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://teachcomputerscience.com/relational-databases/