Free Microsoft Azure Data Fundamentals Exam DP-900 Exam Practice Test

What should you use to automatically delete blobs from Azure Blob Storage?

• soft delete
• archive storage
• the change feed
• a lifecycle management policy

What is a difference between structured data and semi-structured data?

• Structured data has a fixed schema and semi-structured data has a flexible schema.
• Only Structured data supports entities.
• Structured data has a flexible schema and semi-structured data has a fixed schema.
• Only Structured data supports attributes.

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?

• graph
• key/value
• document
• columnar

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

• container
• item
• database
• partition

You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?

• Azure Cosmos
• Azure Table storage
• Azure Files
• Azure Blob storage

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

• SQL Server on Azure Virtual Machines
• Azure SQL Managed Instance
• Azure SQL Database
• Azure SQL Edge

Which statement is an example of Data Manipulation Language (DML)?

• REVOKE
• DISABLE
• CREATE
• UPDATE

In Azure Table storage, each row in a table must be uniquely identified by which two components?Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

• a timestamp
• a range
• a row key
• a partition key

You need to create an Azure Storage account.Data in the account must replica outside the Azure region automatically.Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one pint.

• read-access geo-redundant storage (RA_GRS)
• zone-redundant storage (ZRS)
• geo-redundant storage (GRS)
• locally-redundant storage (LRS)

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

• a few milliseconds
• a few seconds
• a few minutes
• a few hours