Microsoft DP-900 Exam Questions Instant Access

Question 1

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

Aa control flow

Ba trigger

Ca parameter

Dan activity

Answer : B

https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers#trigger-execution

Question 2

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

AINSERT

BMERGE

CUPDATE

DCREATE

Answer : C

https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15

Question 3

Which service can be used to build extract, transform, and load (ETL) pipelines?

AAzure SQL Database

BAzure Pipelines

CAzure Databricks

DAzure Cosmos DB

EAzure Data Factory

Answer : E

Question 4

You need to analyze data by using Azure Databricks.

Which are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

ACreate a Microsoft Power Bl report.

BCreate an Azure Data Factory pipeline.

CUse an Apache Spark job to process data stored in an Azure Cosmos DB database.

DCreate a data flow in Azure Data Factory.

ECreate an Apache Spark job that will run in a Spark cluster.

Answer : C, E

Question 5

Which statement accurately describes data processing?

ABatch processing requires that data be processed immediately upon arrival.

BStream processing is typically used for time-critical operations that require an instant response.

CStream processing is typically used for analyzing larger datasets in less time.

DBatch processing is typically used for scenarios that require continuous, real-time insights from rapidly arriving data.

Answer : B

Question 6

You have a database that stores data in the format shown in the following table.

Of which type of database is this an example?

Adocument

Bcolumn family

Ckey-value

Drelational

Answer : B

Question 7

You have a quality assurance application that reads data from a data warehouse.

Which type of processing does the application use?

AOnline Transaction Processing (OLTP)

Bbatch processing

COnline Analytical Processing (OLAP)

Dstream processing

Answer : A

OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.

https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/

Microsoft Azure Data Fundamentals DP-900 Exam Questions