File Info
| Exam | Microsoft Azure Data Fundamentals |
| Number | DP-900 |
| File Name | Microsoft Azure Data Fundamentals.NetworkArmy.DP-900.2021-12-23.1e.112q.vcex |
| Size | 6.14 Mb |
| Posted | December 23, 2021 |
| Downloads | 241 |
| Download | Microsoft Azure Data Fundamentals.NetworkArmy.DP-900.2021-12-23.1e.112q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
To complete the sentence, select the appropriate option in the answer area.
Correct Answer: Exam simulator is required
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Correct Answer: Exam simulator is required
https://www.sqlshack.com/what-is-database-normalization-in-sql-server/
To complete the sentence, select the appropriate option in the answer area.
Correct Answer: Exam simulator is required
Incorrect Answers:
The data does not need to be fully processed: Often, the three ETL phases are run in parallel to save time.
For example, while data is being extracted, a transformation process could be working on data already received and prepare it for loading, and a loading process can begin working on the prepared data, rather than waiting for the entire extraction process to complete.
The target does need to be a relational database.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
To complete the sentence, select the appropriate option in the answer area.
Correct Answer: Exam simulator is required
https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/
To complete the sentence, select the appropriate option in the answer area.
Correct Answer: Exam simulator is required
https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Correct Answer: Exam simulator is required
Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships.
Box 2: Prescriptive
Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.
Incorrect Answer:
Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome
Box 3: Descriptive
Generally speaking, data analytics comes in four types:
Descriptive, to answer the question: What’s happening?
Diagnostic, to answer the question: Why’s happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
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/
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.
Correct Answer: Exam simulator is required
https://www.w3schools.com/js/js_json_arrays.asp
https://www.w3schools.com/js/js_json_objects.asp
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.
- A: zone-redundant storage (ZRS)
- B: read-access geo-redundant storage (RA-GRS)
- C: locally-redundant storage (LRS)
- D: geo-redundant storage (GRS)
Correct Answer: BD
Geo-redundant storage (GRS)
Geo-zone-redundant storage (GZRS)
B: With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region
Which statement is an example of Data Manipulation Language (DML)?
- A: REVOKE
- B: DISABLE
- C: INSERT
- D: GRANT
Correct Answer: C
DELETE
INSERT
UPDATE
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?
- A: an index
- B: a view
- C: a scalar function
- D: a table
Correct Answer: B
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views
