DP-900 Free Practice Test

For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

Select the answer that correctly completes the sentence.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

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

1. A. REVOKE
2. B. DISABLE
3. C. CREATE
4. D. UPDATE

Correct Answer: D
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
BULK INSERT DELETE INSERT SELECT UPDATE MERGE

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

1. A. denormalized data
2. B. schema defined in a database
3. C. schema defined when reading unstructured data from a database
4. D. normalized data
5. E. light writes and heavy reads
6. F. heavy writes and moderate reads

Correct Answer: ABF

To complete the sentence, select the appropriate option in the answer area.

Solution:
A View

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A