DP-900 Flashcards

1
Q

Descriptive analytics tells you
1. what is most likely to occur in the future
2. what occurred in the past
3. which actions you can perform to affect outcomes
4. why something occurred in the past

A

2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Normalization involves eliminating relationships between database tables
2. Normalizing a database reduces data redundancy
3. Normalization improves data integrity

A
  1. No
  2. Yes
  3. Yes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

An extract, transform and load (ETL) process requires:
1. a matching schema in the data source and the data target
2. a target data store powerful enough to transform data
3. data that is fully processed before being loaded to the target data store
4. that the data target be a relational database

A

3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

In batch processing
1. data is always inserted one row at a time
2. data is processed in real-time
3. latency in delivery data processing results is acceptable
4. processing can only execute serially

A

3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Transcibing audio files is an example of
1. cognitive
2. descriptive
3. predictive
4. prescriptive
analytics

A

1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Match the types of analytics that can be used to answer the business questions.
Cognitive, diagnostic, descriptive, predictive, prescriptive
1. why did sales increase last month?
2. how do I allocate my budget to buy different inventory items?
3. which people are mentioned in a company’s business documents?

A
  1. diagnostic
  2. prescriptive
  3. descriptive
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Are the Customer, Address, and Social Media objects:
a) a nested array
b) a nested object
c) a root object

A

Customer - root object
Address - nested object
Social media - nested array

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

The data model is:
- transactional model
- star schema
- snowflake schema

Customer is a [] table:
- fact
- dimension
- bridge

A
  • star
  • dimension
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q
A

distributes processing across compute nodes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
A

a clustered index

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q
A

transactional writes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q
A

yes
yes
yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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.

A

Extract: CRM system
Load: Data warehouse
Transform: Data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q
A

descriptive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all.

A

Tree map
Key influencer
Scatter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You need to create an Azure Storage account.
Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. zone-redundant storage (ZRS)
B. read-access geo-redundant storage (RA-GRS)
C. locally-redundant storage (LRS)
D. geo-redundant storage (GRS)

A

B and D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q
A

Yes
No
No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT

A

INSERT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?
A. an index
B. a view
C. a scalar function
D. a table

A

a view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q
A

simple lookups

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q
A

Image files - Azure Blob storage
Key/value pairs - Azure Table storage
Relationships - Gremlin API

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q
A
  • Azure Storage account
  • Container
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Data is processed periodically
B. Low latency is expected
C. High latency is acceptable
D. Data is processed as it is created

A

B and D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q
A

Dataset
Linked service
Pipeline

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q
A

Batch
Streaming
Batch

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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.

A

Extract: The CRM system
Load: the data warehouse
Transform: the data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.

Which type of analysis is shown in the fourth quarter?
A. predictive
B. prescriptive
C. descriptive
D. diagnostic

A

A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. CREATE
D. UPDATE

A

D Update

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q
A

descriptive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q
A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
A. az storage share create
B. az storage account create
C. az cosmosdb create
D. az storage container create

A

az storage account create

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q
A

Core (SQL)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

You need to modify a view in a relational database by adding a new column.
Which statement should you use?
A. MERGE
B. ALTER
C. INSERT
D. UPDATE

A

ALTER

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q
A

Yes
No
Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

A

IaaS
PaaS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q
A

cognitive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q
A

Graph databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
A. Azure Table storage
B. Azure Data Lake Storage
C. Azure Queue storage
D. Azure Files

A

B Azure Data Lake Storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q
A

C) a tabular form of rows and columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q
A

A stored procedure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q
A

Diagnostic
Prescriptive
Cognitive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q
A

A view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Which type of database is Azure Database for PostgreSQL?
A. Platform as a service (PaaS)
B. Infrastructure as a service (IaaS)
C. Microsoft SQL Server
D. on-premises

A

Platform as a Service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

Which storage solution supports access control lists (ACLs) at the file and folder level?
A. Azure Data Lake Storage
B. Azure Queue storage
C. Azure Blob storage
D. Azure Cosmos DB

A

Azure Data Lake Storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q
A

Treemap

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

What is a characteristic of batch processing?
A. The data ingested during batch processing must be processed as soon as the data is received.
B. Large datasets must be split into batches of less than 1 GB before the data can be processed.
C. There is a noticeable time delay between ingesting data and obtaining the data processing results.
D. Batch processing can only process data that is structured.

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q
A

MAX and MIN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
48
Q
A

Yes
Yes
No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
49
Q
A

The same set of columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
50
Q
A

A clustered index

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q
A

No
No
Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
52
Q
A

Graph databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
53
Q
A

Simple lookups

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
54
Q
A

virtual machine

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q
A

semi-structured data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
56
Q
A

semi-structured data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
57
Q

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
A. atomicity
B. isolation
C. durability
D. consistency

A

atomicity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
58
Q

Which type of data store is this?
A. key/value
B. object data
C. graph
D. time series

A

Graph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
59
Q

Which type of database contains nodes and edges?
A. graph
B. key/value
C. columnar
D. time series

A

graph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
60
Q
A

data engineer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
61
Q
A

keys

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
62
Q

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

A

UPDATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
63
Q

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.

Which Azure service should you use?
A. Azure HDInsight
B. Azure SQL Database
C. Azure Cosmos DB
D. SQL Server on Azure Virtual Machines

A

B. Azure SQL Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
64
Q

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

A

B. Azure Data Studio

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
65
Q
A

Table
View
Index

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
66
Q

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)

A

OLTP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
67
Q

When can you use an Azure Resource Manager template?
A. to automate the creation of an interdependent group of Azure resources in a repeatable way
B. to apply Azure policies for multi-tenant deployments
C. to provision Azure subscriptions
D. to control which services and feature administrators and developers can deploy from the Azure portal

A

to automate the creation of an interdependent group of Azure resources in a repeatable way

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
68
Q

You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?
A. role-based access control (RBAC)
B. Dynamic Host Configuration Protocol (DHCP)
C. Domain Name Service (DNS)
D. a database-level firewall

A

a database level firewall

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
69
Q
A

Microsoft SQL Server Management Studio (SSMS)
Azure Data Studio
Microsoft SQL Server Data Tools (SSDT)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
70
Q
A

Yes
No
Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
71
Q

Which command-line tool can you use to query Azure SQL databases?
A. sqlcmd
B. bcp
C. azdata
D. Azure CLI

A

sqlcmd

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
72
Q
A

Yes
Yes
Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
73
Q
A

Yes
Yes
Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
74
Q
A

Yes
Yes
Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
75
Q

You have the following SQL query.

INSERT INTO dbo.Products (ProductID, ProductName, Price, ProductDescription)
VALUES (1, ‘Clamp’, 12.48, ‘Workbench clamp’);

What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.

A

Table
Column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
76
Q
A

No
No
Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
77
Q

Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. UPDATE
D. CREATE

A

CREATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
78
Q
A

Yes
No
Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
79
Q

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

A

Azure SQL Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
80
Q

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database?

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

A

access to the latest features
reduced administrative effort

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
81
Q
A

No
Yes
No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
82
Q

How would you query this table to return the average sales per day?

A

SELECT, GROUP BY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
83
Q

When you create an Azure SQL database, which account can always connect to the database?
A. the Azure Active Directory (Azure AD) account that created the database
B. the server admin login account of the logical server
C. the Azure Active Directory (Azure AD) administrator account
D. the sa account

A

the server admin

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
84
Q

Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. INSERT
C. DELETE
D. DROP

A

DROP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
85
Q

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

A

Azure Data Studio

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
86
Q
A

the database to protect data at rest

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
87
Q

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

A

Azure Active Directory (Azure AD) authentication)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
88
Q

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
A. built-in high availability
B. native support for cross-database queries and transactions
C. system-initiated automatic backups
D. support for encryption at rest

A

native support for cross-database queries and transactions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
89
Q
A

a server-level firewall

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
90
Q

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

A

Microsoft SQL Server Data Tools (SSDT)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
91
Q

Match the security components to the appropriate scenarios.

A

Firewall
Authentication
Encryption

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
92
Q

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).

A

you need to generate reports without affecting the transactional workload

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
93
Q
A

strong consistency guarantees are required

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
94
Q
A

keys

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
95
Q
A

a view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
96
Q

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.

A

SELECT access, user in the database, IP address

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
97
Q

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
A. SET
B. JOIN
C. KEY

A

JOIN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
98
Q

Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.
What should you use?
A. Azure Application Gateway
B. Azure Traffic Manager
C. Azure DNS
D. Azure Private Link

A

Azure Private Link

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
99
Q
A

Azure SQL Database single database = a serverless configuration
Azure SQL Database Managed Instance = highest compatibility with on-prem Microsoft SQL Server
Azure SQL Database elastic pool = a low-cost, low-maintenance database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
100
Q

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
A. SELECT
B. WHERE
C. JOIN

A

WHERE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
101
Q
A

Azure Synapse Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
102
Q
A

A clustered index

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
103
Q

What are dbo.Products and ProductName?

A

A Table, a column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
104
Q
A

Primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
105
Q
A

A view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
106
Q

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

A

Azure SQL Managed Instance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
107
Q

Which setting can only be configured during the creation of an Azure Cosmos DB account?
A. geo-redundancy
B. multi-region writes
C. production or non-production account type
D. API

A

API

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
108
Q
A

Key/value
Object
Graph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
109
Q

You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level?
A. the throughput
B. the read region
C. the partition key
D. the API

A

throughput and partition key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
110
Q

Which type of data store should you use?
A. graph
B. key/value
C. object
D. columnar

A

columnar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
111
Q

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

A

Azure Data Lake Storage

112
Q

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

A

Archive

113
Q

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

A

document

114
Q
A

Gremlin API = graph data
MongoDB API = JSON
Table API = key/value

115
Q
A

enable the hierarchical namespace

116
Q
A

using Gremlin language.

117
Q

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

A. multi-master replication
B. Availability Zones
C. the strong consistency level
D. automatic failover

A

Availability Zones

118
Q

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

A. provides resiliency if an Azure region fails
B. supports partitioning
C. provides a higher storage capacity
D. supports a multi-master model

A

supports a multi-master model

119
Q

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

A

graph

120
Q
A

Yes
Yes
Yes

121
Q
A

Cosmos, Azure Files

122
Q
A

account

123
Q

You need to store data by using Azure Table storage.
What should you create first?

A. an Azure Cosmos DB instance
B. a storage account
C. a blob container
D. a table

A

a storage account

124
Q

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

A

Azure Cosmos DB

125
Q
A

No, No, Yes, Yes

126
Q
A

enable the hierarchical namespace

127
Q

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.
Which type of data store should you use?

A. graph
B. key/value
C. document
D. columnar

A

graph

128
Q

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

A

file storage

129
Q

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

A

columnar

130
Q

You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?

A. Azure Files
B. Azure Blob storage
C. Azure Cosmos DB
D. Azure Table storage

A

Azure Files

131
Q
A

No, Yes, No

132
Q

Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?

A. columnar
B. key/value
C. document
D. graph

A

document

133
Q

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

A

object

134
Q

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

A

time series

135
Q
A

Yes, Yes, Yes

136
Q
A

graph

137
Q

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. database
B. item
C. container
D. partition

A

database and container

138
Q
A

Yes, No, Yes, Yes

139
Q

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

A

self describing entities

140
Q
A

PolyBase

141
Q

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

streaming

142
Q

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

A

Pause the pool

143
Q

Which Azure Data Factory component initiates the execution of a pipeline?

A. a control flow
B. a trigger
C. a parameter
D. an activity

A

A trigger

144
Q

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?

A. stream processing
B. batch processing
C. Online Analytical Processing (OLAP)
D. Online Transaction Processing (OLTP)

A

OLAP

145
Q
A

Data movement - copy
Data transformation - mapping
Control - lookup

146
Q

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema on write
E. schema on read
F. normalized data

A

B, D, F

147
Q

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

A

report and dashboard creation, report sharing and distribution

148
Q
A

a control flow

149
Q

You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

A. a view
B. a report
C. a dataflow
D. Microsoft Power Apps

A

a report

150
Q

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Azure Time Series Insights
B. Azure HDInsight
C. Azure Databricks
D. Azure Log Analytics

A

HGInsight and Databricks

151
Q

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

A

OLAP

152
Q

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a dataflow
E. a text box

A

a report page, a visualization, a text box

153
Q
A

Yes, No, Yes

154
Q

Which Azure Data Factory component provides the compute environment for activities?

A. SSIS packages
B. an integration runtime
C. a control flow
D. a pipeline

A

an integration runtime

155
Q
A

paginated report

156
Q

What are two uses of data visualization? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Represent trends and patterns over time
B. Implement machine learning to predict future values
C. Communicate the significance of data
D. Enforce business logic across reports

A

A and C

157
Q

You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse.
What should you use to query the files?

A. Azure Functions
B. Microsoft SQL Server Integration Services (SSIS)
C. PolyBase
D. Azure Data Factory

A

PolyBase

158
Q
A

No, No, Yes

159
Q

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema defined in a database
E. schema defined when reading unstructured data from a database
F. normalized data

A

B, D, F

160
Q

What is the primary purpose of a data warehouse?

A. to provide answers to complex queries that rely on data from multiple sources
B. to provide transformation services between source and target data stores
C. to provide read-only storage of relational and non-relational historical data
D. to provide storage for transactional line-of-business (LOB) applications

A

A

161
Q

Match the Azure services to the appropriate locations in the architecture.

A

Azure Data Factory, Azure Synapse Analytics

162
Q
A

Batch, Batch, Streaming

163
Q
A

from multiple sources is combined

164
Q
A

No, Yes, Yes

165
Q
A

Synapse, Data Lake, Database

166
Q
A

Yes, Yes, No

167
Q

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

A. Charticulator
B. Power BI Desktop
C. the Power BI service
D. Power BI Report Builder

A

Power BI Report Builder

168
Q
A

Data Factory, Synapse

169
Q
A

Yes, No, Yes

170
Q

Which scenario is an example of a streaming workload?

A. sending transactions that are older than a month to an archive
B. sending transactions daily from point of sale (POS) devices
C. sending telemetry data from edge devices
D. sending cloud infrastructure metadata every 30 minutes

A

C

171
Q
A

collect data and then process the data when a condition is met

172
Q
A

Yes, Yes, No

173
Q

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

A

descriptive

174
Q
A

Yes, No, Yes

175
Q

You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?

A. Synapse pipelines
B. a Synapse SQL pool
C. Synapse Link
D. Synapse Studio

A

Synapse Link

176
Q

What should you create in Power BI Desktop?

A. a waterfall chart
B. a ribbon chart
C. a bar chart
D. a decomposition tree

A

Waterfall chart

177
Q
A

graph

178
Q

Which type of data do the tables contain?

A. structured
B. non-relational
C. semi-structured
D. unstructured

A

Structured

179
Q
A

gremlin language

180
Q

Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache?

A. the Hot access tier
B. change feed
C. snapshots
D. versioning

A

change feed

181
Q

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

A

Managed instance

182
Q
A

C - data is fully processed

183
Q
A

D

184
Q

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.

A

CRM, DW, DW

185
Q
A

what occured in the past

186
Q

What is a function of a modern data warehouse?

A. supports batch processing only
B. supports real-time and batch processing
C. provides built-in or native online analytical processing
D. stores raw data only

A

C - provides built-in and batch processing

187
Q
A

hierarchical namespace

188
Q

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

A

Azure Databricks

189
Q

Which format was used?

A. XML
B. HTML
C. YAML
D. JSON

A

JSON

190
Q

Which format was used?

A. JSON
B. YAML
C. HTML
D. XML

A

XML

191
Q

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

A. consistency
B. atomicity
C. durability
D. isolation

A

durability

192
Q
A

strong consistency guarantees

193
Q
A

tabular form

194
Q

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

A. atomicity
B. durability
C. isolation
D. consistency

A

atomicity

195
Q
A

a clustered index

196
Q

Which Azure Storage service implements the key/value model?

A. Azure Queue
B. Azure Files
C. Azure Table
D. Azure Blob

A

Azure Table

197
Q
A

semi-structured

198
Q
A

from multiple sources

199
Q
A

delays are acceptable

200
Q

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

A

Cosmos

201
Q
A

Stores data without a fixed schema

202
Q
A

Yes, No, Yes

203
Q

Which format was used?

A

CSV

204
Q
A

database administrator

205
Q
A

database administrator

206
Q

What is required to provision Azure Data Lake Storage in an Azure Storage account?

A. Versioning must be disabled.
B. Hierarchical namespace must be disabled.
C. Versioning must be enabled.
D. Hierarchical namespace must be enabled.

A

Hierarchical namespace must be enabled

207
Q
A

relational data

208
Q
A

Virtual Machines

209
Q
A

report

210
Q
A

1) ETL, 2) ELT, 3) Data ingestion

211
Q

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

A. YAML
B. KQL
C. SQL
D. XML

A

SQL

212
Q
A

elastic pool

213
Q
A

semi-structured data

214
Q

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.

A

D

215
Q

What is a primary characteristic of a relational database?

A. a flexible data structure
B. data is queried and manipulated by using a variant of the SQL language
C. a lack of dependencies between tables
D. a large amount of duplicate data

A

SQL

216
Q
A

WHERE

217
Q

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

A. GRANT
B. INSERT
C. REVOKE
D. DROP

A

INSERT

218
Q

What is a characteristic of a non-relational database?

A. full support for Transact-SQL
B. a fixed schema
C. self-describing entities

A

self-describing entities

219
Q

What should you use to automatically delete blobs from Azure Blob Storage?

A. archive storage
B. the change feed
C. soft delete
D. a lifecycle management policy

A

life cycle management

220
Q

In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. a partition key
B. a range
C. a row key
D. a timestamp

A

a partition key and a row key

221
Q
A

data analyst

222
Q

You need to store event log data that is semi-structured and received as the logs occur.
What should you use?

A. Azure Table storage
B. Azure Queue storage
C. Azure Files

A

Azure Files

223
Q

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

A. Table
B. Cassandra
C. Core (SQL)
D. Gremlin

A

Gremlin

224
Q
A

Yes, No, No

225
Q
A

elastic pool

226
Q

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

A

isolation

227
Q
A

1) ETL 2) Fact tables, 3) DW

228
Q
A

account

229
Q

A data engineer is responsible for which task?

A. Explore data to identify trends.
B. Implement policies, tools, and processes for backup and recovery plans.
C. Design and build analytical models.
D. Design and implement data stores for analytical workloads.

A

D - design and implement data stores

230
Q
A

across compute nodes

231
Q
A

cube

232
Q
A

Scatter charts

233
Q
A

stored procedure

234
Q

Which file format has defined names and data types for each column and uses compressed columnar storage?

A. HTML
B. CSV
C. Apache Parquet
D. JSON

A

Apache Parquet

235
Q
A

transactional writes

236
Q
A

Yes, No, Yes

237
Q

Which type of database can be used for semi-structured data that will be processed by an Apache Spark pool in Azure Synapse Analytics?

A

column-family

238
Q

Which two attributes are characteristics of an analytical data workload?

  • highly normalized
  • optimized for read operations
  • highly denormalized
A

optimized for read operations, highly denormalized

239
Q

Which type of data workload is optimized for updates and relies on relationships between entities to correlate data?

A

transactional

240
Q

Which two types of applications are used in transactional systems?

A

line-of-business applications and live applications

241
Q

Which job role is responsible for designing database solutions, creating databases, and developing stored procedures?

A

data engineer

242
Q

Which two keys are needed to create a one-to-many relationship between two tables in a relational database?

A

foreign key and primary key

243
Q

What are two advantages of using normalization over not using normalization in a relational database

A

optimizes for updates and uses less storage space

244
Q

Which data service provides a fully managed database with close to 100 percent feature parity with Microsoft SQL Server?

A

Azure SQL Managed Instance

245
Q

Which data service allows you to use every feature of Microsoft SQL Server in the cloud?

A

SQL Server on an Azure Virtual Machines running Windows

246
Q

Which data service allows you to migrate an entire Microsoft SQL server to the cloud without requiring that you manage the infrastructure after the migration?

A

Azure SQL Managed Instance

247
Q

Which data service allows you to control the amount of RAM, change the I/O subsystem configuration, and add or remove CPUs?

A

SQL Server on Azure Virtual Machines

247
Q

Which data service allows you to control the amount of RAM, change the I/O subsystem configuration, and add or remove CPUs?

A

SQL Server on Azure Virtual Machines

248
Q

Which open-source database has built-in support for temporal data?

A

MariaDB

249
Q

Which type of Azure Storage is the least expensive option that allows you to store and edit image files?

A

block blobs in the Archive tier

250
Q

Which type of Azure Storage is used for VHDs and is optimized for random read and write operations?

A

page blobs

251
Q

Which type of Azure Storage is used to store large amounts of files to be shared with virtual machines by using SMB?

A

Azure Files

252
Q

You need to process many JSON files every minute, while keeping the data from the files accessible by using native queries.

Which Azure Cosmos DB API should you use?

A

SQL

253
Q

Which Azure Cosmos DB API is queried by using a syntax based on SQL?

A

Apache Cassandra

254
Q

What should you use to process large amounts of data by using Apache Hadoop?

A

Azure HDInsight

255
Q

Which two services allow you to pre-process a large volume of data by using Scala? Each correct answer presents a complete solution.

A

Azure Databricks and a serverless Apache Spark pool in Azure Synapse Analytics

256
Q

You are processing data by using batches and streams.

What should you use to ensure that transactional consistency is enforced during the processing?

A

Azure Delta Lake

257
Q

What should you use to define an analytical model for Microsoft Power BI?

A

Power BI Desktop

258
Q

Which visual in Microsoft Power BI allows you to view trends, such as changes in sales over time?

A

a scatter plot

259
Q

In the Power BI service, what should you create to share a single page with the most important visuals from reports?

A

a dashboard

260
Q

Which type of database should you use to store sequential data in the fastest way possible?

A

time series

261
Q

You design an application that needs to store data based on the following requirements:

Store historical data from multiple data sources
Load data on a scheduled basis
Use a denormalized star or snowflake schema

A

OLAP

262
Q

Which two DML statements are used to modify the existing data in a table? UPDATE, SELECT, MERGE, INSERT

A

UPDATE and MERGE

263
Q

Which data service allows you to use every feature of Microsoft SQL Server in the cloud?

A

SQL Server on an Azure Virtual Machine running Windows

264
Q

Which type of Azure Storage is used to store large amounts of files to be shared with virtual machines by using SMB?

A

Azure Files

265
Q

Which storage solution should you use to store unstructured documents, graph databases, and key/value pairs?

A

Cosmos

266
Q

Which Azure Cosmos DB API should you use for data in the BSON format?

A

Mongo DB

267
Q

Which service is managed and serverless, avoids the use of Windows Server licenses, and allows for each workload to have its own instance of the service being used?

A

Azure SQL Database

268
Q

Which data service provides a fully managed database with close to 100 percent feature parity with Microsoft SQL Server?

A

Azure SQL Managed Instance

269
Q

Which Azure Blob storage access tier should you use for data that will be used once per year and can have an access time that takes more than an hour?

A

Archive

270
Q

What are two characteristics of Azure Table storage?

A

Each RowKey value is unique within a table partition.
Items in the same partitions are stored in a row key order.

271
Q

Which Azure Cosmos DB API is queried by using a syntax based on SQL?

A

Cassandra

272
Q

Which service can you use to perpetually retrieve data from a Kafka queue, process the data, and write the data to Azure Data Lake?

A

Stream Analytics

273
Q

Which service allows you to perform on-demand analysis of large volumes of data from text logs, websites and IoT devices by using a common querying language for all the data sources?

A

Azure Data Explorer

274
Q

Which service allows you to aggregate data over a specific time window before the data is written to a data lake?

A

Azure Stream Analytics