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

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

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

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

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

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

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/

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

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

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

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