Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 171:

  What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

  A. denormalized data

  B. heavy writes and moderate reads

  C. light writes and heavy reads

  D. schema on write

  E. schema on read

  F. normalized data

  Correct Answer: BDF

  B: Transactional data tends to be heavy writes, moderate reads.

  D: Typical traits of transactional data include: schema on write, strongly enforced

  F: Transactional data tends to be highly normalized.

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

• Question 172:

  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

  B. blob

  C. file

  D. table

  Correct Answer: C

  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/

• Question 173:

  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

  B. graph

  C. columnar

  D. document

  Correct Answer: C

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

• Question 174:

  Which scenario is an example of a streaming workload?

  A. sending transactions that are older than a month to an archive

  B. sending transactions daily from point of sale (POS) devices

  C. sending telemetry data from edge devices

  D. sending cloud infrastructure metadata every 30 minutes

  Correct Answer: C

• Question 175:

  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

  B. columnar

  C. graph

  D. time series

  Correct Answer: A

• Question 176:

  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?

  A. Archive

  B. Hot

  C. Cool

  Correct Answer: A

  Reference: https://cloud.netapp.com/blog/azure-blob-storage-pricing-the-complete-guide-azure-cvo-blg#H1_4

• Question 177:

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

  NOTE: Each correct selection is worth one point.

  A. the throughput

  B. the read region

  C. the partition key

  D. the API

  Correct Answer: AC

  Reference: https://www.sqlshack.com/start-your-journey-with-azure-cosmos-db/

• Question 178:

  Your company is designing a data store that will contain student data. The data has the following format.

  

  Which type of data store should you use?

  A. graph

  B. key/value

  C. object

  D. columnar

  Correct Answer: D

• Question 179:

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

  A. Azure Disk Storage

  B. Azure Data Lake Storage

  C. Azure Blob storage

  D. Azure Queue storage

  Correct Answer: B

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

• Question 180:

  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. service principal authentication

  B. Azure Active Directory (Azure AD) authentication

  C. SQL authentication

  D. certificate authentication

  Correct Answer: B

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview