A bank has a system that manages financial transactions.
When transferring money between accounts. the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.
Of which ACID semantic is this an example?

A. atomicity

B. durability

C. consistency

D. isolation

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
 

You need to recommend a data store service that meets the following requirements:
✑ Native SQL API access
✑ Configurable indexes
What should you recommend?

A. Azure Files

B. Azure Blob storage

C. Azure Table storage

D. Azure Cosmos DB

You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes.
What should you include in the solution?

A. Azure Blob storage

B. Azure Files

C. Azure Table storage

D. Azure Cosmos DB

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

A. Azure SQL Database

B. Azure Database for MySQL

C. Azure SQL Managed Instance

D. an Azure SQL Database elastic pool

Which Azure Cosmos DB API should you use for a graph database?

A. Table

B. Cassandra

C. Core (SQL)

D. Gremlin

DRAG DROP -
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
 

Which type of database contains nodes and edges?

A. graph

B. key/value

C. columnar

D. time series

You have a data store that has the structure shown in the following exhibit.
 
Which type of data store is this?

A. key/value

B. object data

C. graph

D. time series

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.
NOTE: Each correct selection is worth one point.

A. the throughput

B. the read region

C. the partition key

D. the API

Which Azure Cosmos DB API should you use for a graph database?

A. Table

B. Cassandra

C. NoSQL

D. Gremlin

You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. You must be assigned the Reader role for the resource group that contains the database.

B. You must have SELECT access to the Products table.

C. You must have a user in the database.

D. You must be assigned the Contributor role for the resource group that contains the database.

E. Your IP address must be allowed to connect to the database.

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.
Hot Area:
 

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 

You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?

A. You need to generate reports without affecting the transactional workload.

B. You need to audit the transactional application.

C. You need to implement high availability in the event of a regional outage.

D. You need to improve the recovery point objective (RPO).

DRAG DROP -
Match the datastore services to the appropriate descriptions.
To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
 

Which storage solution supports role-based access control (RBAC) at the file and folder level?

A. Azure Disk Storage

B. Azure Data Lake Storage

C. Azure Blob storage

D. Azure Queue storage

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

A. GRANT

B. INSERT

C. REVOKE

D. DROP

HOTSPOT
-
Select the answer that correctly completes the sentence.
 

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

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.
Hot Area:
 

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 

You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?

A. Microsoft SQL Server Data Tools (SSDT)

B. Microsoft SQL Server Management Studio (SSMS)

C. Azure Databricks

D. Azure Data Studio

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
 

HOTSPOT
-
Select the answer that correctly completes the sentence.
 

You manage an application that stores data in a shared folder on a Windows server.
You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?

A. queue

B. blob

C. file

D. table

HOTSPOT -
Select the answer that correctly completes the sentence.
 

You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?

A. Archive

B. Hot

C. Cool

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
 

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.
 

What can be used with native notebook support to query and visualize data by using a web-based interface?

A. Azure Databricks

B. pgAdmin

C. Microsoft Power BI

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
 

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.
Hot Area:
 

DRAG DROP -
Match the ACID 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.
 

HOTSPOT
-
Select the answer that correctly completes the sentence.
 

DRAG DROP -
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service from the column on the left to its requirement on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
 

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.
 

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
 

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.
Hot Area:
 

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 DB

B. Azure HDInsight

C. Azure SQL Database

D. Azure Synapse Analytics

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 

You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?

A. Online Transaction Processing (OLTP)

B. batch

C. massively parallel processing (MPP)

D. streaming

A bar chart showing year-to-date sales by region is an example of which type of analytics?

A. predictive

B. prescriptive

C. descriptive

D. diagnostic

HOTSPOT -
Select the answer that correctly completes the sentence.
 

You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?

A. Online Transaction Processing (OLTP)

B. batch processing

C. Online Analytical Processing (OLAP)

D. stream processing

You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
* Minimize maintenance effort.
* Support the Database Mail and Service Broker features.
What should you include in the solution?

A. Azure SQL Database single database

B. an Azure SQL Database elastic pool

C. Azure SQL Managed instance

D. SQL Server on Azure virtual machines

Your company is designing a data store for internet-connected temperature sensors.
The collected data will be used to analyze temperature trends.
Which type of data store should you use?

A. relational

B. time series

C. graph

D. columnar

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.
Hot Area:
 

DRAG DROP -
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.
Select and Place: