Microsoft Azure DP-900 Exam Preparation

Question # 1 (Sentence completion)

Select the answer that correctly completes the sentence.
Objects in which things about data should be captured and stored are called: ____________.

A. tables
B. entities
C. rows
D. columns

Question # 2 (Sentence completion)
Select the answer that correctly completes the sentence.
You need to process data that is generated continuously and near real-time responses are required.
You should use _________.

A. batch processing
B. scheduled data processing
C. buffering and processing
D. streaming data processing

Question # 3 (Matching)

You are evaluating data processing approaches.

Match the data processing approaches on the left to the requirements on the right.

Question # 4 (Multiple choice)

Select the answer that correctly completes the sentence.
The technique that provides recommended actions that you should take to achieve a goal or target is called _____________ analytics.

A. descriptive
B. diagnostic
C. predictive
D. prescriptive

Question # 5 (Matching)

Match the data processing objects on the left to the requirements on the right.
Data processing objects Descriptions

A. Tables

B. Indexes

C. Views

D. Keys 

_____ 1. Create relationships.

_____ 2. Improve processing speed for data searches.

_____ 3. Store instances of entities as rows.

_____ 4. Display data from predefined queries.

Question # 6 (Sentence completion)
Select the answer that correctly completes the sentence.
The process of splitting an entity into more than one table to reduce data redundancy is called: _____________.

A. deduplication
B. denormalization
C. normalization
D. optimization

Question # 7 (Sentence completion)
Select the answer that correctly completes the sentence.
Azure SQL Database is an example of ________________ -as-a-service.

A. platform
B. infrastructure
C. software
D. application

Question # 8 (Matching)
You need to query an Azure SQL database.
Match the query tools on the left to the correct scenarios on the right.
Query Tools Descriptions

A. Azure Data Studio

B. Azure Query editor

C. SQL Server Data Tools _

____ 1. Query data while working within a Visual Studio project.

_____ 2. Query data located in a non-Microsoft platform.

_____ 3. Query data from within the Azure portal.

Question # 9 (Sentence completion)

Select the answer that correctly completes the sentence.
The act of increasing or decreasing the resources that are available for a service is called: _____________.

A. computing
B. provisioning
C. networking
D. scaling

Question # 10 (Matching)
You are creating queries to retrieve data from an Azure SQL database.
Match the SQL clauses or functions on the left to the requirements on the right.
SQL clauses Descriptions

A. JOIN

B. WHERE

C. SUM

D. COUNT _____ 1. Filter records.

_____ 2. Combine rows from multiple tables.

_____ 3. Calculate the total value of a numeric column.

_____ 4. Determine the number of rows retrieved.

Question # 11 (Multiple choice)

What are three characteristics of non-relational data? Each correct answer presents a complete solution.

A. Forced schema on data structures

B. Flexible storage of ingested data

C. Entities are self-describing

D. Entities may have different fields

E. Each row has the exact same columns

Question # 12 (Sentence completion)

Select the answer that correctly completes the sentence.

You have data that consists of JSON-based documents.

You need to store the data in an Azure environment that supports efficient non-key, field-based searching.

You should use _______________________ as the data store.

A. Azure Table Storage

B. Azure Blob Storage

C. Azure File Storage

D. Azure Cosmos DB

Question # 13 (Multiple Choice)

You need to create a graph database.

Which Azure data service should you use?

A. Azure Table

B. Azure Cosmos DB

C. Azure Blob

D. Azure File

Question # 14 (Sentence completion)

Select the answer that correctly completes the sentence.

You use Azure Table Storage as a non-relational data store.

You need to optimize data retrieval. You should use ______________________________ as query criteria.

A. only partition keys

B. only row keys

C. partition keys and row keys

D. only properties

Question # 15 (Multiple Choice)

You need to use JavaScript Object Notation (JSON) files to provision Azure storage.

What should you use?

A. Azure portal

B. Azure command-line interface (CLI)

C. Azure PowerShell

D. Azure Resource Manager (ARM) templates

Question # 16 (Multiple Choice)

For which reason should you deploy a data warehouse?

A. Record daily sales transactions.

B. Perform sales trend analyses.

C. Print sales orders.

D. Search status of sales orders.

Question # 17 (Multiple Choice)

Which two Azure data services support Apache Spark clusters? Each correct answer presents a complete solution.

A. Azure Synapse Analytics

B. Azure Cosmos DB

C. Azure Databricks

D. Azure Data Factory

Question # 18 (Multiple Choice)

You design a data ingestion and transformation solution by using Azure Data Factory service.  You need to get data from an Azure SQL database.

Which two resources should you use? Each correct answer presents part of the solution.

A. Linked service

B. Copy data activity

C. Dataset

D. Azure Databricks notebook

Question # 19 (Multiple Choice)

Which Azure Data Factory component should you use to represent data that you want to ingest for processing?

A. Linked services

B. Datasets

C. Pipelines

D. Notebooks

Question # 20 (Multiple Choice)

You are designing reports by using Microsoft Power BI.

For which three scenarios can you create Power BI reports as paginated reports? Each correct answer presents a complete solution.

A. a report that has a table visual with an ability to print all the data in the table

B. a report that has a table visual with an ability to see all the data in the table

C. a report with a repeatable header and footer

D. a report that is formatted to fit well on a printed page

E. a report that uses only Power BI visual