PART 1: DP-900: Microsoft Azure Data Fundamentals

1- Descriptive analytics tells you.....

• What is most likely to occur In the future

• What occurred in the past

• Which actions you can perform to affect outcomes

• Why something occurred in the past

3- An extract, transform, and load (ETL) process requires.......

• a matching schema in the data source and the data target
• a target data store powerful enough to transform data
• data that is fully processed before being loaded to the target data store.
• that the data target be a relational database

4- To complete the sentence, select the appropriate option in the answer area In batch processing,

• Data is always inserted one row at a time
• Data is processed in real-time
• Latency in delivering data processing results is acceptable
• Processing can only excute serially

5- Transcribing audio files is an example of…..analytics.

• cognitive
• descriptive
• predictive
• prescriptive

9- The massively parallel processing (MPP) engine of Azure Synapse Analytics .........

• distributes processing across compute nodes.
• distributes processing across control nodes.
• redirects client connections across compute nodes.
• redirects client connections across control nodes.

10- ….....is an object associated with a table that sorts and stores the data rows in the table based on their key values.

• A clustered index
• A FileTable
• A foreign key
• A stored procedure

11- A relational database is appropriate for scenarios that involve a high volume of…...

• changes to relationships between entities
• geographically distributed writes
• transactional writes
• writes that have varying data structures

14- A visualization that shows a university's current student enrollment versus the maximum capacity is an example of…..analytics.

• cognitive
• descriptive
• predictive
• prescriptive

16- 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.

• A. zone-redundant storage (ZRS)

• B. read-access geo-redundant storage (RA-GRS)

• C. locally-redundant storage (LRS)

• D. geo-redundant storage (GRS)

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

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