Free DP-900 Sample Questions — Microsoft Azure Data Fundamentals

Which three services support Apache Spark? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

• A. Azure Data Explorer
• B. Azure Synapse Analytics
• C. Azure Databricks
• D. Azure Stream Analytics
• E. Azure HDInsight

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

• A. SET
• B. VALUES
• C. KEY
• D. JOIN

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

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

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

What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?

• A. a few milliseconds
• B. a few seconds
• C. a few minutes
• D. a few hours

Which Azure Storage service implements the key/value model?

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

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

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

What is the responsibility of a database administrator?

• A. applying data cleaning routines
• B. creating data visualizations
• C. managing data integration processes
• D. storing backup copies of data

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

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

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

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

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

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

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

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

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 statement is an example of Data Manipulation Language (DML)?

• A. REVOKE
• B. DISABLE
• C. CREATE
• D. UPDATE