Microsoft DP-900 Exam Practice Test Instant Access

Question 1

You have an application that runs on Windows and requires across to a mapped drive.

Which Azure service should you use?

AAzure Cosmos DB

BAzure Table storage

CAzure Files

DAzure Blob Storage

Answer : A

Question 2

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.

Acomplete control over backup and restore processes

Baccess to the latest features

Cin-database machine learning services

Dreduced administrative effort for managing the server infrastructure

Answer : B, C

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.

https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Question 3

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

Aa few milliseconds

Ba few seconds

Ca few minutes

Da few hours

Answer : A

Question 4

You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.

What should you use?

ASynapse pipelines

Ba Synapse SQL pool

CSynapse Link

DSynapse Studio

Answer : C

https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link

Question 5

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 6

You need to gather real-time telemetry data from a mobile application.

Which type of workload describes this scenario?

AOnline Transaction Processing (OLTP)

Bbatch

Cmassively parallel processing (MPP)

Dstreaming

Answer : D

https://docs.microsoft.com/en-in/azure/azure-monitor/overview

Question 7

What are two uses of data visualization? Each correct answer present a complete solution.

NOTE: Each correct selection is worth one point.

ARepresent trends and patterns over time.

BCommunicate the significance of data.

Cimplement machine learning to predict future values.

DConsistently implement business logic across reports

Answer : A, B

Data visualization is a key component in being able to gain insight into your data. It helps make big and small data easier for humans to understand. It also makes it easier to detect patterns, trends, and outliers in groups of data.

Data visualization brings data to help you find key business insights quickly and effectively.

https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization

Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test