DP-900 Practice Test

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

Question 26

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:

Question 27

Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?

  1. predictive
  2. prescriptive
  3. descriptive
  4. diagnostic

Question 28

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

  1. REVOKE
  2. DISABLE
  3. CREATE
  4. UPDATE

Question 29

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

Question 30

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