Microsoft DP-900 Exam Practice Test Instant Access

Question 1

You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.

Which type of data store should you rec ommend?

Adocument

Bkey/value

Cobject

Dcolumnar

Answer : C

Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.

https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Question 2

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

AAzure Queue storage

BAzure Data Lake Storage

CAzure table storage

DAzure Files

Answer : B

https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

Question 3

Your company is designing a data store that will contain student dat

a. The data has the following format.

Which type of data store should you use?

Agraph

Bkey/value

Cobject

Dcolumnar

Answer : D

Question 4

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

Question 5

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. (Choose three.)

NOTE: Each correct selection is worth one point.

AYou must be assigned the Reader role for the resource group that contains the database.

BYou must have SELECT access to the Products table.

CYou must have a user in the database.

DYou must be assigned the Contributor role for the resource group that contains the database.

EYour IP address must be allowed to connect to the database.

Answer : B, C, E

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15

Question 6

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 7

Which service is optimized for loT scenarios that involve streaming time series data?

ASQL Server on Azure Virtual Machines

BAzure SQL Managed Instance

CAzure SQL Database

DAzure SQL Edge

Answer : D

Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test