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

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

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

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 3
You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

• A. INSERT
• B. MERGE
• C. UPDATE
• D. CREATE

Answer: C

NEW QUESTION 4
Match the types of workloads to the appropriate scenarios.
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.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 5
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 6
You need to create an Azure Storage account.
Data in the account must replica outside the Azure region automatically.
Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one pint.

• A. read-access geo-redundant storage (RA_GRS)
• B. zone-redundant storage (ZRS)
• C. geo-redundant storage (GRS)
• D. locally-redundant storage (LRS)

Answer: AC

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

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

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

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 9
You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level? Each correct answer presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.

• A. the throughput
• B. the read region
• C. the partition key
• D. the API

Answer: AC

NEW QUESTION 10
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?

• A. Microsoft SQL Server Management Studio (SSMS)
• B. Azure Data Studio
• C. Azure CLI
• D. Azure PowerShell

Answer: B

NEW QUESTION 11
Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use?

• A. Key/value
• B. Graph
• C. Document
• D. columnar

Answer: B

NEW QUESTION 12
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

• A. document
• B. columnar
• C. graph
• D. time series

Answer: A

NEW QUESTION 13
You have the following SQL query.

NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

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

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 15
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure service should you use to support the application?

• A. Azure Cosmos D3
• B. Azure Synapse Analytics
• C. Azure HCMmtghi
• D. Azure SQL Database

Answer: B

NEW QUESTION 16
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 17
......