Practice Free DP-900 Exam Online Questions
HOTSPOT
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
What is the primary purpose of a data warehouse?
- A . to provide answers to complex queries that rely on data from multiple sources
- B . to provide transformation services between source and target data stores
- C . to provide read-only storage of relational and non-relational historical data
- D . to provide storage for transactional line-of-business (LOB) applications
DRAG DROP
Match the types of data stores to the appropriate scenarios.
To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
At which level in Azure Cosmos DB can you configure multiple write regions and read regions?
- A . database
- B . partition
- C . collection
- D . account
In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?
- A . bridge
- B . dimension
- C . fact
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose three.)
- 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