Select the answer that correctly completes the sentence.
Solution:
Does this meet the goal?
Correct Answer:
A
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Solution:
Does this meet the goal?
Correct Answer:
A
Which command-line tool can you use to query Azure SQL databases?
Correct Answer:
A
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.
Solution:
Graphical user interface, text, application, chat or text message Description automatically generated
Box 1: The CRM system
Data is extracted from the CRM system. Box 2: The data warehouse
Data is loaded to the data warehouse. Box 3: A standalone data analysis tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.
Graphical user interface, text, application Description automatically generated
Does this meet the goal?
Correct Answer:
A
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Solution:
Does this meet the goal?
Correct Answer:
A