DP-900: Microsoft Azure Data Fundamentals

Question #: 176
Topic #: 1
You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

What should you create in Power BI Desktop?

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

Selected Answer: C

Question #: 178
Topic #: 1
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

Selected Answer: A

Question #: 180
Topic #: 1
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

Selected Answer: B

Question #: 181
Topic #: 1
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

Selected Answer: C

Question #: 184
Topic #: 1
Which two features distinguish Delta Lake from Azure Data Lake Storage? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. support for batch data
B. schema enforcement
C. support for an Apache Spark runtime
D. transactional consistency
E. support for streaming data

Selected Answer: BD

Question #: 186
Topic #: 1
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

Selected Answer: B

Question #: 188
Topic #: 1
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

Selected Answer: A

Question #: 189
Topic #: 1
You have data saved in the following format.

Which format was used?

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

Selected Answer: D

Question #: 190
Topic #: 1
You have data saved in the following format.

Which format was used?

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

Selected Answer: D

Question #: 191
Topic #: 1
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

Selected Answer: C

Question #: 194
Topic #: 1
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

Selected Answer: A

Question #: 196
Topic #: 1
Which Azure Storage service implements the key/value model?

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

Selected Answer: C

Question #: 200
Topic #: 1
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

Selected Answer: D

Question #: 203
Topic #: 1
You have data saved in the following format.

Which format was used?

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

Selected Answer: B

Question #: 206
Topic #: 1
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.

Selected Answer: D

Question #: 211
Topic #: 1
What is used to define a query in a stream processing jobs in Azure Stream Analytics?

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

Selected Answer: C

Question #: 214
Topic #: 1
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.

Selected Answer: B

Question #: 215
Topic #: 1
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

Selected Answer: B

Question #: 217
Topic #: 1
Which statement is an example of Data Manipulation Language (DML)?

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

Selected Answer: B

Question #: 218
Topic #: 1
What is a characteristic of a non-relational database?

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

Selected Answer: C

Question #: 219
Topic #: 1
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

Selected Answer: D

Question #: 220
Topic #: 1
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

Selected Answer: AC

Question #: 222
Topic #: 1
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

Selected Answer: A

Question #: 223
Topic #: 1
Which Azure Cosmos DB API should you use for a graph database?

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

Selected Answer: D

Question #: 226
Topic #: 1
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

Selected Answer: D

Question #: 229
Topic #: 1
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.

Selected Answer: D

Question #: 234
Topic #: 1
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

Selected Answer: B

Question #: 238
Topic #: 1
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)

Selected Answer: D

Question #: 240
Topic #: 1
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

Selected Answer: D

Question #: 242
Topic #: 1
Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates. backups, and maintenance tasks?

A. Azure SQL Managed Instance
B. SQL Server on Azure Virtual Machines
C. Azure SQL Database
D. Azure SQL Edge

Selected Answer: A

Question #: 252
Topic #: 1
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

Selected Answer: C

Question #: 255
Topic #: 1
Which Azure Cosmos DB API should you use for a graph database?

A. Table
B. Cassandra
C. NoSQL
D. Gremlin

Selected Answer: C

Question #: 257
Topic #: 1
What is a difference between structured data and semi-structured data?

A. Structured data has a fixed schema and semi-structured data has a flexible schema.
B. Only Structured data supports entities.
C. Structured data has a flexible schema and semi-structured data has a fixed schema.
D. Only Structured data supports attributes.

Selected Answer: A

Question #: 259
Topic #: 1
A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.

Of which ACID semantic is this an example?

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

Selected Answer: C

Question #: 260
Topic #: 1
Which statement is an example of Data Manipulation Language (DML)?

A. INSERT
B. ALTER
C. DROP
D. CREATE

Selected Answer: A

Question #: 261
Topic #: 1
Which language is used to define queries in Azure Synapse Data Explorer?

A. Bash
B. PowerShell
C. KQL
D. SQL

Selected Answer: C

Question #: 267
Topic #: 1
Which Azure Cosmos DB API should you use for a graph database?

A. Azure Cosmos DB for Table
B. Azure Cosmos DB for Apache Cassandra
C. Azure Cosmos DB for NoSQL
D. Azure Cosmos DB for Apache Gremlin

Selected Answer: D

Question #: 270
Topic #: 1
A bank needs to ensure that a transaction involving debiting funds from a source account and crediting the same funds to a destination account must complete both actions. If either action falls to complete, the other action must fail.

Of which ACID semantic is this an example?

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

Selected Answer: B

Question #: 271
Topic #: 1
Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?

A. Hot to Cool
B. Hot to Archive
C. Cool to Archive
D. Archive to Cool

Selected Answer: D

Question #: 272
Topic #: 1
Which activity is most common for transactional workloads?

A. recording small units of work events in real time
B. aggregating massive amounts of data
C. producing complex reports
D. performing self-service data exploration

Selected Answer: A

Question #: 273
Topic #: 1
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

Selected Answer: C

Question #: 280
Topic #: 1
SELECT, INSERT, and UPDATE are examples of which type of SQL statement?

A. Data Definition Language (DDL)
B. Data Control Language (DCL)
C. Data Manipulation Language (DML)

Selected Answer: D

Question #: 256
Topic #: 1
In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

A. bridge
B. dimension
C. fact

Selected Answer: C

Question #: 235
Topic #: 1
In a fully denormalized database, how is data read and written for a single entity?

A. Data is read from a single table and written to a single table.
B. Data is read from multiple tables 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 multiple tables.

Selected Answer: A

Question #: 192
Topic #: 1
GRANT, REVOKE, and DENY are examples of which type of SQL statement?

A. Data Definition language (DDL)
B. Data Control Language (DCL)
C. Data Manipulation Language (DML)

Selected Answer: B

Question #: 103
Topic #: 1
Structured data where each row represents a single data entity uses which type of schema?

A. XML
B. tabular
C. blob
D. JSON

Selected Answer: B

Question #: 37
Topic #: 1
You need to implement an Azure platform as a service (PaaS) service that will host a relational database. The solution must support built-in autoscaling.

Which service should you implement?

A. Azure SQL Database
B. SQL Server on Azure Virtual Machines
C. Azure SQL Managed Instance
D. Azure SQL Edge

Selected Answer: A

Question #: 31
Topic #: 1
You have the following data.

Which type of data is this?

A. unstructured
B. semi-structured
C. structured

Selected Answer: C

Question #: 5
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

A

Question #: 4
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

C

Question #: 3
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

C

Question #: 2
Topic #: 1
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:

N Y Y

Question #: 1
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

B

Question #: 10
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

A

Question #: 9
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

A

Question #: 8
Topic #: 1
HOTSPOT –
You are reviewing the data model shown in the following exhibit.

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

Star
Dimension

Question #: 7
Topic #: 1
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:

root object
nested object
nested array

Question #: 6
Topic #: 1
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:

1 diagnostic : it answers the question “why did it happen?”
2 prescritive : it answers the question “how can we make it happen?”
3 descriptive: it answers the question “what happened'”

Question #: 17
Topic #: 1
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:

Y N Y

Question #: 15
Topic #: 1
DRAG DROP –
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.
NOTE: Each correct match is worth one point.
Select and Place:

treemap
keyinfluencer
Scatter

Question #: 14
Topic #: 1
HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

B

Question #: 13
Topic #: 1
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:

CRM – DWH – DWH

Question #: 12
Topic #: 1
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: