Welcome to the second part of our post on DP-900 exam dumps! In the previous post, we reviewed the initial set of sample questions and answers and assessed their relevance to the actual exam. If you haven’t read that post yet, you can find it here. Now, let’s continue our review and see what other insights we can gather from this new set of questions.
Question # 11
To complete the sentence, select the appropriate option in the answer area.

Transactional writes.
Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
Question # 12
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

- Yes
- Yes
- Yes
- Box 1: Yes – Big data solutions often use long-running batch jobs, these jobs involve reading source files from scalable storage (like HDFS, Azure Data Lake Store, and Azure Storage), processing them, and writing the output to new files.
- Box 2: Yes
- Box 3: Yes
Question # 13
DRAG DROP
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

- The CRM system
- The data warehouse
- The data warehouse
- Box 1: Data is extracted from the CRM system.
- Box 2: Data is loaded to the data warehouse.
- Box 3: In the ELT pipeline, the transformation occurs in the target data warehouse.
Question # 14
To complete the sentence, select the appropriate option in the answer area.

Descriptive.
Generally speaking, data analytics comes in four types:
- Descriptive – to answer the question: What’s happening?
- Diagnostic – to answer the question: Why’s happening?
- Predictive – to answer the question: What will happen?
- Prescriptive – to answer the question: What actions should we take?
Question # 15
DRAG DROP
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct selection is worth one point.
Select and Place:

- Treemap
- Key Influencer
- Scatter
Question # 16
You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically.
Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

- B. Read-access geo-redundant storage (RA-GRS)
- D. Geo-redundant storage (GRS)
D: Azure Storage offers two options for copying your data to a secondary region:
- Geo-redundant storage (GRS)
- Geo-zone-redundant storage (GZRS)
B: With GRS or GZRS, the data in the secondary region isn’t available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Question # 17
HOTSPOT
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

- Yes
- No
- No
Question # 18

C. Insert
There are 3 types of Relational data SQL:
- DDL (Data Definition Language) – CREATE, DROP, ALTER, RENAME, COMMENT and TRUNCATE.
- DML (Data Manipulation Language) – SELECT, INSERT INTO, DELETE, UPDATE.
- DCL (Data Control Language) – REVOKE & GRANT.
- TCL (Transactional Control Language) COMMIT & ROLLBACK
Question # 19

B. A View
A View is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Question # 20
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.

Simple lookups
Simple lookups – A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.