You have the following two tables of customer data.
 
 
Which type of data do the tables contain?

A. structured

B. non-relational

C. semi-structured

D. unstructured

A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as
IntelliSense.
What should the developers use?

A. sqlcmd

B. Microsoft SQL Server Management Studio (SSMS)

C. Azure Data Studio

D. Azure Data Explorer

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

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact.
What should you do on the dedicated SQL pool?

A. Scale down the data warehouse units (DWUs).

B. Pause the pool.

C. Create a user-defined restore point.

D. Delete the pool

You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?

A. key/value

B. columnar

C. object

D. document

HOTSPOT -
Select the answer that correctly completes the sentence.
 

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

You have a banking application that transfers money in to and out of accounts.
Of which type of solution is this is an example?

A. online transaction processing (OLTP)

B. online analytical processing (OLAP)

C. extract, transform and load (ETL)

D. a data warehouse

HOTSPOT
-
Select the answer that correctly completes the sentence.
 

What is a characteristic of non-relational data?

A. no indexes

B. self-describing entities

C. a well-defined schema

D. no unique key values

Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. report and dashboard creation

B. report sharing and distribution

C. data modeling

D. data acquisition and preparation

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?

A. service principal authentication

B. Azure Active Directory (Azure AD) authentication

C. SQL authentication

D. certificate authentication

In a fully normalized database, how is data read and written for a single entity?

A. Data is read from multiple tables and written to multiple tables.

B. Data is read from a single table and written to a single table.

C. Data is read from a single table and written to multiple tables.

D. Data is read from multiple tables and written to a single table.

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 -
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
-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
 

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:
 

HOTSPOT
-
Select the answer that correctly completes the sentence.
 

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 -
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 are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. access to the latest features

B. complete control over backup and restore processes

C. in-database machine learning services

D. reduced administrative effort for managing the server infrastructure

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.
 

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 -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
 

A retail point of sale (POS) system is an example of which type of solution?

A. a data warehouse

B. online analytical processing (OLAP)

C. extract, transform, and load (ETL)

D. online transaction processing (OLTP)

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:
 

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

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

A. graph

B. key/value

C. document

D. columnar

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

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:
 

Which type of Azure resource supports the serverless configuration of an Azure SQL database?

A. SQL Server on Azure Virtual Machines

B. an Azure SQL Database elastic pool

C. a single database in Azure SQL Database

D. Azure SQL Managed Instance

Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?

A. key/value

B. graph

C. columnar

D. document

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

HOTSPOT -
You have the following JSON document.
 
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Hot Area:
 

You have structured data in tabular format.
What represents an individual instance of a data entity?

A. a column

B. a table

C. a cell

D. a row

You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?

A. stream processing

B. batch processing

C. Online Analytical Processing (OLAP)

D. Online Transaction Processing (OLTP)

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 -
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 -
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
-
Select the answer that correctly completes the sentence.
 

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

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

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

Which Azure Storage service implements the key/value model?

A. Azure Queue

B. Azure Files

C. Azure Table

D. Azure Blob

HOTSPOT
-
Select the answer that correctly completes the sentence.
 

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

DRAG DROP -
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place: