Download Microsoft Azure Data Fundamentals.NetworkArmy.DP-900.2021-12-23.1e.112q.vcex

Download Exam

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.

Purchase

Coupon: MASTEREXAM
With discount: 20%



 
 



Demo Questions

Question 1

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

Correct Answer: Exam simulator is required

Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/




Question 2

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

Reference:
https://www.sqlshack.com/what-is-database-normalization-in-sql-server/




Question 3

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

Correct Answer: Exam simulator is required

In the ELT pipeline, the transformation occurs in the target data store. ELT only works well when the target system is powerful enough to transform the data efficiently. 
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




Question 4

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

Correct Answer: Exam simulator is required

Reference:
https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/




Question 5

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

Correct Answer: Exam simulator is required

Reference:
https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/




Question 6

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

Box 1: Diagnostic
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/




Question 7

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

Reference:
https://www.w3schools.com/js/js_json_arrays.asp
https://www.w3schools.com/js/js_json_objects.asp




Question 8

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

D: Azure Storage offers two options for copying your data to a secondary region:
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




Question 9

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

  • A: REVOKE
  • B: DISABLE
  • C: INSERT
  • D: GRANT

Correct Answer: C

Data Manipulation Language (DML) statements:
DELETE 
INSERT 
UPDATE 
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference-tsql-statements




Question 10

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

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases. 
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views










CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files