DP-900 Practice Test

DP-900 Practice Test practice questions, page 4 of 13, with answer review and explanations.

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.

  1. zone-redundant storage (ZRS)
  2. read-access geo-redundant storage (RA-GRS)
  3. locally-redundant storage (LRS)
  4. geo-redundant storage (GRS)

Question 17

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

Question 18

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

  1. REVOKE
  2. DISABLE
  3. INSERT
  4. GRANT

Question 19

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create?

  1. an index
  2. a view
  3. a scalar function
  4. a table

Question 20

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