ExamGecko
Home Home / Microsoft / DP-900

Microsoft DP-900 Practice Test - Questions Answers, Page 17

Question list
Search
Search

List of questions

Search

Related questions











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.
document
A.
document
Answers
B.
columnar
B.
columnar
Answers
C.
graph
C.
graph
Answers
D.
time series
D.
time series
Answers
Suggested answer: A

Explanation:

Section: Describe how to work with non-relational data on Azure

You manage an application that stores data in a shared folder on a Windows server.

You need to move the shared folder to Azure Storage.

Which type of Azure Storage should you use?

A.
queue
A.
queue
Answers
B.
blob
B.
blob
Answers
C.
file
C.
file
Answers
D.
table
D.
table
Answers
Suggested answer: C

Explanation:

Section: Describe how to work with non-relational data on Azure

Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used.

Reference:

https://azure.microsoft.com/en-us/services/storage/files/

Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.

Which type of data store will provide the lowest latency to retrieve the data?

A.
key/value
A.
key/value
Answers
B.
graph
B.
graph
Answers
C.
columnar
C.
columnar
Answers
D.
document
D.
document
Answers
Suggested answer: C

Explanation:

Section: Describe how to work with non-relational data on Azure

Reference:

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

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

Which Azure service should you use?

A.
Azure Files
A.
Azure Files
Answers
B.
Azure Blob storage
B.
Azure Blob storage
Answers
C.
Azure Cosmos DB
C.
Azure Cosmos DB
Answers
D.
Azure Table storage
D.
Azure Table storage
Answers
Suggested answer: A

Explanation:

Section: Describe how to work with non-relational data on Azure

Azure Files is Microsoft's easy-to-use cloud file system. Azure file shares can be seamlessly used in Windows and Windows Server.

To use an Azure file share with Windows, you must either mount it, which means assigning it a drive letter or mount point path, or access it via its UNC path.

Reference:

https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows

Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.

Which type of data store should you use?

A.
columnar
A.
columnar
Answers
B.
key/value
B.
key/value
Answers
C.
document
C.
document
Answers
D.
graph
D.
graph
Answers
Suggested answer: C

Explanation:


You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, 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 recommend?

A.
key/value
A.
key/value
Answers
B.
columnar
B.
columnar
Answers
C.
object
C.
object
Answers
D.
document
D.
document
Answers
Suggested answer: C

Explanation:

Section: Describe how to work with non-relational data on Azure

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.

Reference:

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

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.

Which type of data store should you use?

A.
relational
A.
relational
Answers
B.
time series
B.
time series
Answers
C.
graph
C.
graph
Answers
D.
columnar
D.
columnar
Answers
Suggested answer: B

Explanation:

Section: Describe how to work with non-relational data on Azure

Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.

Reference:

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

Which scenario is an example of a streaming workload?

A.
sending transactions that are older than a month to an archive
A.
sending transactions that are older than a month to an archive
Answers
B.
sending transactions daily from point of sale (POS) devices
B.
sending transactions daily from point of sale (POS) devices
Answers
C.
sending telemetry data from edge devices
C.
sending telemetry data from edge devices
Answers
D.
sending cloud infrastructure metadata every 30 minutes
D.
sending cloud infrastructure metadata every 30 minutes
Answers
Suggested answer: C

Explanation:

Section: Describe an analytics workload on Azure

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

Which type of workload describes this scenario?

A.
Online Transaction Processing (OLTP)
A.
Online Transaction Processing (OLTP)
Answers
B.
batch
B.
batch
Answers
C.
massively parallel processing (MPP)
C.
massively parallel processing (MPP)
Answers
D.
streaming
D.
streaming
Answers
Suggested answer: D

Explanation:

Section: Describe an analytics workload on Azure

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

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.
Scale down the data warehouse units (DWUs).
A.
Scale down the data warehouse units (DWUs).
Answers
B.
Pause the pool.
B.
Pause the pool.
Answers
C.
Create a user-defined restore point.
C.
Create a user-defined restore point.
Answers
D.
Delete the pool
D.
Delete the pool
Answers
Suggested answer: B

Explanation:

Section: Describe an analytics workload on Azure

Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-overview

Total 285 questions
Go to page: of 29