Microsoft DP-900 Exam Questions Instant Access

Question 1

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?

AAzure Cosmos DB

BAzure Synapse Analytics

CAzure HDInsight

DAzure SQL Database

Answer : D

Azure SQL Database is relational database and a managed service.

https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

Question 2

You need to design and model a database by using a graphical tool that supports project-oriented offline

database development.

What should you use?

AMicrosoft SQL Server Data Tools (SSDT)

BMicrosoft SQL Server Management Studio (SSMS)

CAzure Databricks

DAzure Data Studio

Answer : A

https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-serverver15

Question 3

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

Acontrol flow

Blinked services

Cdatasets

Dthe integration runtime

Answer : A

Question 4

You need to create an Azure resource to store data in Azure Table storage.

Which command should you run?

Aaz scorage share create

Baz scorage account creace

Caz cosmosdb creace

Daz scorage concainer creace

Answer : D

https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest

Question 5

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

Asupports partitioning

Bprovides resiliency if art Azure region fads

Cprovides a higher storage capacity

Dsupports a multi-master model

Answer : D

Multi-master support for Azure Cosmos DB is now available in all public regions.

Azure CosmosDB table API is a key-value storage hosted in the cloud. It's a part of Azure Cosmos DB, that is Microsoft's multi-model database.

https://docs.microsoft.com/en-us/azure/cosmos-db/table-support

Question 6

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

Astream processing

Bbatch processing

COnline Analytical Processing (OLTP)

DOnline Transaction Processing (OLTP)

Answer : D

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

Question 7

You need to store data in Azure Blob storage for seven years to meet your company's compliance

requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.

Which storage tier should you use?

AArchive

BHot

CCool

Answer : A

Microsoft Azure Data Fundamentals DP-900 Exam Questions