Boost Your Performance in the Microsoft DP-900 Exam with Practice Tests

Question #1

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #2

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

A. rovides resiliency if an Azure region fails

B. upports partitioning

C. rovides a higher storage capacity

D. upports a multi-master model

View answer

Correct Answer: D

Question #3

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

A. access to the latest features

B. complete control over backup and restore processes

C. in-database machine learning services

D. reduced administrative effort for managing the server infrastructure

View answer

Correct Answer: AD

Question #4

You need to design and model a database by using a graphical tool that supports project-oriented offline database development.What should you use?

A. icrosoft SQL Server Data Tools (SSDT)

B. icrosoft SQL Server Management Studio (SSMS)

C. zure Databricks

D. zure Data Studio

View answer

Correct Answer: A

Question #5

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #6

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #7

You have an application that runs on Windows and requires access to a mapped drive.Which Azure service should you use?

A. zure Files

B. zure Blob storage

C. zure Cosmos DB

D. zure Table storage

View answer

Correct Answer: A

Question #8

You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

A. ou need to generate reports without affecting the transactional workload

B. ou need to audit the transactional application

C. ou need to implement high availability in the event of a regional outage

D. ou need to improve the recovery point objective (RPO)

View answer

Correct Answer: A

Question #9

Which statement is an example of Data Definition Language (DDL)?

A. ELECT

B. NSERT

C. ELETE

D. ROP

View answer

Correct Answer: D

Question #10

You have an application that runs on Windows and requires across to a mapped drive. Which Azure service should you use?

A. zure Cosmos DB

B. zure Table storage

C. zure Files

D. zure Blob Storage

View answer

Correct Answer: A

Question #11

DRAG DROP (Drag and Drop is not supported)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 o

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #12

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #13

HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #14

What are two uses of data visualization? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

A. zure Functions

B. icrosoft SQL Server Integration Services (SSIS)

C. olyBase

D. zure Data Factory

View answer

Correct Answer: AC

Question #15

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.Which type of authentication should you use?

A. ervice principal authentication

B. zure Active Directory (Azure AD) authentication

C. QL authentication

D. ertificate authentication

View answer

Correct Answer: B

Question #16

HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #17

You need to store data by using Azure Table storage.What should you create first?

A. n Azure Cosmos DB instance

B. storage account

C. blob container

D. table

View answer

Correct Answer: B

Question #18

HOTSPOT (Drag and Drop is not supported)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:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #19

HOTSPOT (Drag and Drop is not supported)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:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #20

DRAG DROP (Drag and Drop is not supported)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 o

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #21

DRAG DROP (Drag and Drop is not supported)Match the security components to the appropriate scenarios.To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.Select and Place:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #22

HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #23

Your company is designing a data store for internet-connected temperature sensors.The collected data will be used to analyze temperature trends.Which type of data store should you use?

A. elational

B. ime series

C. raph

D. olumnar

View answer

Correct Answer: B

Question #24

Which statement is an example of Data Definition Language (DDL)?

A. SELECT

B. JOIN

C. UPDATE

D. CREATE

View answer

Correct Answer: D

Question #25

When can you use an Azure Resource Manager template?

A. o automate the creation of an interdependent group of Azure resources in a repeatable way

B. o apply Azure policies for multi-tenant deployments

C. o provision Azure subscriptions

D. o control which services and feature administrators and developers can deploy from the Azure portal

View answer

Correct Answer: A

Question #26

You have a transactional application that stores data in an Azure SQL managed instance.When should you implement a read-only database replica?

A. ou need to generate reports without affecting the transactional workload

B. ou need to audit the transactional application

C. ou need to implement high availability in the event of a regional outage

D. ou need to improve the recovery point objective (RPO)

View answer

Correct Answer: A

Question #27

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

A. ocument

B. olumnar

C. raph

D. ime series

View answer

Correct Answer: A

Question #28

When can you use an Azure Resource Manager template?

A. to automate the creation of an interdependent group of Azure resources in a repeatable way

B. to apply Azure policies for multi-tenant deployments

C. to provision Azure subscriptions

D. to control which services and feature administrators and developers can deploy from the Azure portal

View answer

Correct Answer: A

Question #29

What are two characteristics of real-time data processing? Each correct answer present a complete solution. NOTE: Each correct selection is worth one point.

A. ee Explanation section for answer

View answer

Correct Answer: BD

Question #30

HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #31

You need to query a table named Products in an Azure SQL database.Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

A. ET

B. ALUES

C. EY

D. OIN

View answer

Correct Answer: BCE

Question #32

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #33

HOTSPOT (Drag and Drop is not supported)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:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #34

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?

A. tomicity

B. solation

C. urability

D. onsistency

View answer

Correct Answer: A

Question #35

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. zure Cosmos

B. zure Table storage

C. zure Files

D. zure Blob storage

View answer

Correct Answer: A

Question #36

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact.What should you do on the dedicated SQL pool?

A. cale down the data warehouse units (DWUs)

B. ause the pool

C. reate a user-defined restore point

D. elete the pool

View answer

Correct Answer: B

Question #37

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:

A. view

B. report

C. dataflow

D. icrosoft Power Apps

View answer

Correct Answer: A

Question #38

HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #39

Which storage solution supports role-based access control (RBAC) at the file and folder level?

A. zure Disk Storage

B. zure Data Lake Storage

C. zure Blob storage

D. zure Queue storage

View answer

Correct Answer: B

Question #40

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #41

HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #42

DRAG DROP (Drag and Drop is not supported)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.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #43

Select the answer that correctly completes the sentence.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #44

Which statement is an example of Data Manipulation Language (DML)?

A. EVOKE

B. ISABLE

C. REATE

D. PDATE

View answer

Correct Answer: D

Question #45

HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #46

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #47

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

A. ulti-master replication

B. vailability Zones

C. he strong consistency level

D. utomatic failover

View answer

Correct Answer: B

Question #48

DRAG DROP (Drag and Drop is not supported)Match the terms to the appropriate descriptions.To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.Select and Place:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #49

DRAG DROP (Drag and Drop is not supported)Match the types of workloads to the appropriate scenarios.To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #50

HOTSPOT (Drag and Drop is not supported)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:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #51

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. tream processing

B. atch processing

C. nline Analytical Processing (OLAP)

D. nline Transaction Processing (OLTP)

View answer

Correct Answer: D

Question #52

DRAG DROP (Drag and Drop is not supported)Match the types of activities to the appropriate Azure Data Factory activities.To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.NOTE: Each correct match is worth one point.Select and Place:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #53

Which statement is an example of Data Manipulation Language (DML)?

A. EVOKE

B. ISABLE

C. NSERT

D. RANT

View answer

Correct Answer: C

Question #54

What ate 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. ormalized data

B. chema defined in a database

C. chema defined when reading unstructured data from a database

D. ormalized data

E. ight writes and heavy reads

View answer

Correct Answer: ACF

Question #55

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).Which Azure service should you use to support the application?

A. Azure Cosmos DB

B. Azure HDInsight

C. Azure SQL Database

D. Azure Synapse Analytics

View answer

Correct Answer: C

Question #56

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #57

Which storage solution supports access control lists (ACLs) at the file and folder level?

A. zure Data Lake Storage

B. zure Cosmos DB

C. zure Queue storage

D. zure Blob storage

View answer

Correct Answer: A

Question #58

What is a characteristic of batch processing?

A. he data ingested during batch processing must be processed as soon as the data is received

B. arge datasets must be split into batches of less than 1 GB before the data can be processed

C. here is a noticeable time delay between ingesting data and obtaining the data processing results

D. atch processing can only process data that is structured

View answer

Correct Answer: D

Question #59

You need to create an Azure resource to store data in Azure Table storage. Which command should you run?

A. ee Explanation section for answer

View answer

Correct Answer: D

Question #60

HOTSPOT (Drag and Drop is not supported)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.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #61

HOTSPOT (Drag and Drop is not supported)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:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #62

DRAG DROP (Drag and Drop is not supported)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.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #63

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

A. control flow

B. trigger

C. parameter

D. n activity

View answer

Correct Answer: B

Question #64

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #65

You have an Azure Cosmos DB account that uses the Core (SQL) API.Which two settings can you configure at the container level? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

A. raph

B. ey/value

C. bject

D. olumnar

View answer

Correct Answer: AC

Question #66

You have data saved in the following format.Which format was used?

A. AML

B. TML

C. ML

D. SON

View answer

Correct Answer: B

Question #67

Which type of database is Azure Database for PostgreSQL?

A. latform as a service (PaaS)

B. nfrastructure as a service (laaS)

C. icrosoft SQL Server

D. n-premises

View answer

Correct Answer: A

Question #68

HOTSPOT (Drag and Drop is not supported)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:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #69

HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #70

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #71

DRAG DROP (Drag and Drop is not supported)Match the Azure SQL services to the appropriate use cases.To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.NOTE: Each correct match its worth one point.Select and Place:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #72

HOTSPOT (Drag and Drop is not supported)To complete the sentence, select the appropriate option in the answer area.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #73

HOTSPOT (Drag and Drop is not supported)For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #74

HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:

A. ee Explanation section for answer

View answer

Correct Answer: A

Question #75

Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit.Which type of analysis is shown for the fourth quarter?

A. redictive

B. rescription

C. escriptive

D. iagnostic

View answer

Correct Answer: A

Question #76

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

A. uilt-in high availability

B. ative support for cross-database queries and transactions

C. ystem-initiated automatic backups

D. upport for encryption at rest

View answer

Correct Answer: B

Question #77

You need to modify a view in a relational database by adding a new column. Which statement should you use?

A. ERGE

B. LTER

C. NSERT

D. PDATE

View answer

Correct Answer: B

Question #78

HOTSPOT (Drag and Drop is not supported)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:

A. ee Explanation section for answer

View answer

Correct Answer: A

DON'T WANT TO MISS A THING?

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE!
Get Now

Boost Your Performance in the Microsoft DP-900 Exam with Practice Tests

View The Updated DP-900 Exam Questions

View The Updated Microsoft Exam Questions

View Answers after Submission

DON'T WANT TO MISS A THING?

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE! Get Now

Boost Your Performance in the Microsoft DP-900 Exam with Practice Tests

View The Updated DP-900 Exam Questions

View The Updated Microsoft Exam Questions

View Answers after Submission

100% Pass Cisco, PMP, CISA, CISM, AWS Practice test on SALE!
Get Now