DP-900 3

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

1. append blobs in the Archive tier
2. append blobs in the Cool tier
3. block blobs in the Archive tier
4. block blobs in the Cool tier
Which type of Azure Storage is used to store large amounts of files to be shared with
virtual machines by using SMB?

1. Azure Data Lake Storage Gen2
2. Azure Files
3. Azure Storage page blobs
4. Azure Table storage
Which two storage solutions can be mounted in Azure Synapse Analytics and used to
process large volumes of data? Each correct answer presents a complete solution.
Select all answers that apply.

1. Azure Blob storage
2. Azure Data Lake Storage
3. Azure Files
Which type of blob should you use to store data blocks that are added to a file
frequently but cannot be deleted?

1. append
2. block
3. page
Which storage solution should you use to store unstructured documents, graph
databases, and key/value pairs?

1. Azure Cosmos DB
2. Azure Files
3. Azure SQL
Which Azure Cosmos DB API should you use for data in a column-family storage
structure?

1. Apache Cassandra
2. Apache Gremlin
3. MongoDB
4. Table
Which Azure Cosmos DB API should you use for data in the BSON format?

1. Apache Cassandra
2. Apache Gremlin
3. MongoDB
4. Table
Which Azure Cosmos DB API should you use for data in key/value tables?

1. Apache Cassandra
2. Apache Gremlin
3. MongoDB
4. Table
Which Azure Cosmos DB API is queried by using a syntax based on SQL?

1. Apache Cassandra
2. Apache Gremlin
3. MongoDB
4. Table
Which Azure Cosmos DB API allows you to work with vertices and edges?

1. Apache Cassandra
2. Apache Gremlin
3. NoSQL
4. Table
What should you use to create and run data ingestion pipelines?

1. Azure Cosmos DB
2. Azure Data Factory
3. Azure Databricks
4. Azure HDInsight
What should you use to process large amounts of data by using Apache Hadoop?

2. Azure Databricks
3. Azure HDInsight
4. Azure Synapse Analytics
Which type of data store uses star schemas, fact tables, and dimension tables?

1. data lake
2. data warehouse
3. cube
4. relational database
Which two services allow you to create a pipeline to process data in response to an
event? Each correct answer presents a complete solution.

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

1. A serverless Apache Spark pool in Azure Synapse Analytics
2. Azure Databricks
3. A dedicated SQL pool in Azure Synapse Analytics
4. The serverless SQL pool in Azure Synapse Analytics
What should you create first for an integration process that copies data from
Microsoft Excel files to Parquet files by using Azure Data Factory?

1. a dataset
2. a linked service
3. a pipeline
4. an activity
What is a characteristic of stream processing?

1. All the data in a dataset is processed.
2. Latency is measured in seconds or milliseconds.
3. Stream processing can handle large datasets.
4. Stream processing is used to perform complex analysis.
What is a characteristic of batch processing?

1. Batch processing handles small datasets based on a time window.
2. Batch processing is used to perform complex analysis.
3. Batch processing processes individual events.
4. Latency is measured in seconds or milliseconds.
Which three services can be used to ingest data for stream processing? Each correct
answer presents a complete solution.

1. Azure Data Lake Storage
2. Azure Event Hubs
3. Azure Functions
4. Azure IoT Hub
5. Azure SQL Database
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?

1. Azure Cosmos DB
2. Azure Data Explorer
4. Azure Stream Analytics
Which type of visual in Microsoft Power BI should you use to identify the correlation
between two numeric measures?

1. bar charts
2. line charts
3. pie charts
4. scatter plots
In the Power BI service, what should you create to share a single page with the most
important visuals from reports?

1. a dashboard
2. a dataset
3. a scorecard
4. a workspace
You need to share a report that you created in Microsoft Power BI Desktop with
other users.
What should you do first?

1. Create a workspace.
2. Create an app.
3. Open the report in a web browser.
4. Publish the report to the Power BI service.
Which type of visual in Microsoft Power BI should you use to display a single value,
such total sales?

1. bar chart
2. card
3. pie chart
4. table
Which Azure data service allows you to store document, graph, and column-family
databases?

1. Azure Cosmos DB
4. HBase in HDInsight
Which Azure data service allows you to store images, PDF files, and static JSON files?

1. Azure Cosmos DB for Apache Gremlin
You have data stored in two tables in a database.
You create a relationship between the tables.
Which type of data do you have?

1. semi-structured
2. structured
3. unstructured
You have data that describes products and is stored in JSON documents. The
product structure changes over time as new attributes are added.
Which type of data do you have?

1. semi-structured
2. structured
3. unstructured
Which is the best type of database to use for an organizational chart?

3. columnar
4. graph
Which service allows you to store data as a graph database?

1. Azure Cosmos DB
3. Azure SQL Managed Instance
Which two types of file store data in columnar format? Each correct answer presents
a complete solution.

1. Avro
2. CSV
3. Parquet
4. ORC
Which Azure Cosmos DB API allows you to implement a non-relational database and
model nodes that have relationships between them?

1. Apache Gremlin
2. MongoDB
3. NoSQL
4. Table
What are three properties of analytical data workloads? Each correct answer presents
a complete solution.

1. Read and write operations are optimized.
2. Read operations are optimized.
3. They calculate business metrics over time.
4. They operate on current data.
5. They operate on historical data.
Which feature of transactional data processing guarantees that concurrent processes

cannot see the data in an inconsistent state?

1. atomicity
2. consistency
3. durability
4. isolation
Which job role is responsible for troubleshooting index performance, provisioning

access to databases, and backing up databases?

1. database administrator
2. database analyst
3. database engineer
4. database user
Which job role is responsible for creating reports from a database and using OLAP
cubes?

2. database analyst
3. database engineer
4. database user
Which job role is responsible for managing the security of the data in a database,
implementing backup and recovery plans, and monitoring the performance of
database solutions?

2. data analyst
3. data engineer
Which job role is responsible for managing data privacy, monitoring data stores, and
monitoring data pipelines?

2. data analyst
3. data engineer
What are two advantages of using normalization over not using normalization in a
relational database? Each correct answer presents a complete solution.

1. provides storage for non-structured data
2. optimizes for complex reads
3. optimizes for updates
4. uses less storage space
Which SQL operation is used to combine the content of two tables based on a
shared column?

1. `HAVING`
2. INTERSECT
3. JOIN
4. UNION
Select the answer that correctly completes the sentence.
[Answer choice] is a process to reduce duplicate data in a database and ensure data
integrity.

1. Indexing
2. Normalization
3. Projecting
4. Refactoring
You have a complex query that selects data from multiple tables.
Which three database objects should allow you to reuse the query definition? Each
correct answer presents a complete solution.

1. a function
2. a stored procedure
3. a table
4. a temporary table
5. a view
Which three statements accurately describe the properties of a table in a relational

database? Each correct answer presents a complete solution.

1. All columns must contain values.
2. A table can have a primary key build on multiple columns.
3. A table can have only one foreign key.
4. Each column must have a datatype.
5. Each row in a table has the same number of columns.
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?

3. SQL Server on Azure Virtual Machines running Linux
4. SQL Server on Azure Virtual Machines running Windows Server
What is fully managed and does not require changes to a database for migration?

3. SQL Server on Azure Virtual Machines running Linux
4. SQL Server on Azure Virtual Machines running Windows
Which three open-source databases are available as platform as a service (PaaS) in

Azure? Each correct answer presents a complete solution.

1. Cockroach DB
2. CouchDB
3. MariaDB
4. MySQL
5. PostgreSQL
Which data service allows you to control the amount of RAM, change the I/O
subsystem configuration, and add or remove CPUs?

3. SQL Server on Azure Virtual Machines
Which open-source database is a hybrid relational-object database?

1. MariaDB
2. MySQL
3. Oracle Database
4. PostgreSQL
Which open-source database has built-in support for temporal data?

1. MariaDB
2. MySQL
3. Oracle Database
4. PostgreSQL
Which SQL engine is optimized for IoT scenarios?

2. Azure SQL Edge
4. SQL Server on Azure Virtual Machines
Which data integration service allows you to orchestrate data flow without coding?

2. Azure Data Lake
3. Azure Databricks
4. Azure HDInsight
In a stream processing architecture, what can you use to persist the processed results
as files?

2. Azure Databricks
3. Azure Event Hubs
You are processing data by using batches and streams.
What should you use to ensure that transactional consistency is enforced during the
processing?

2. Azure Delta Lake
Which service allows you to aggregate data over a specific time window before the
data is written to a data lake?

1. Azure Cosmos DB
2. Azure Event Hubs
4. Azure Stream Analytics

DP-900 3

Uploaded by

Copyright:

Available Formats

DP-900 3

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

DP-900 3

Uploaded by

Copyright:

Available Formats

Which type of Azure Storage is the least expensive option that allows you to store

and edit image files?

Select only one answer.

Select only one answer.

Select all answers that apply.

Select only one answer.

Select only one answer.

Select only one answer.

Select only one answer.

Select only one answer.

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

Select only one answer.

Select only one answer.

Select only one answer.

Select only one answer.

Select all answers that apply.

Select all answers that apply.

Select only one answer.

What is a characteristic of stream processing?

Select only one answer.

Select only one answer.

Select all answers that apply.

Select only one answer.

Select only one answer.

Select only one answer.

What should you do first?

Select only one answer.

Select only one answer.

Select only one answer.

Select only one answer.

You have data stored in two tables in a database.

You create a relationship between the tables.

Which type of data do you have?

Select only one answer.

Which type of data do you have?

Select only one answer.

Which is the best type of database to use for an organizational chart?

Select only one answer.

Which service allows you to store data as a graph database?

Select only one answer.

Select all answers that apply.

Select only one answer.

Select all answers that apply.

Which feature of transactional data processing guarantees that concurrent processes

Select only one answer.

Which job role is responsible for troubleshooting index performance, provisioning

Select only one answer.

Select only one answer.

Select only one answer.

Select only one answer.

Select all answers that apply.

Select only one answer.

Select the answer that correctly completes the sentence.

Select only one answer.

Select all answers that apply.

Which three statements accurately describe the properties of a table in a relational

Select all answers that apply.

Select only one answer.

Select only one answer.

Which three open-source databases are available as platform as a service (PaaS) in