CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-900

Free DP-900 Exam Braindumps (page: 8)

Page 7 of 72
PDF with 306 Questions

DRAG DROP (Drag and Drop is not supported)
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Batch
Batch processing refers to the processing of blocks of data that have already been stored over a period of time.

Box 2: Streaming
Stream processing is a big data technology that allows us to process data in real-time as they arrive and detect conditions within a small period of time from the point of receiving the data. It allows us to feed data into analytics tools as soon as they get generated and get instant analytics results.

Box 3: Batch


Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing



DRAG DROP (Drag and Drop is not supported)
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:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



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.


Reference:

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl



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

Answer(s): A

Explanation:

Predictive, to answer the question. What will happen?


Reference:

https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/



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

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

Answer(s): D

Explanation:

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


Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements






Post your Comments and Discuss Microsoft DP-900 exam with other Community members:

DP-900 Discussions & Posts