


Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
DP-900: MICROSOFT AZURE DATA FUNDAMENTALS Descriptive analytics - correct answer What occurred in the past Normalizing - correct answer Reduce data redundancy & Improves data integrity Does NOT eliminate relationship In batch processing, it takes longer time to process in bulk - correct answer Latency is expected Diagnostic analytics - correct answer Why events happened
Typology: Exams
1 / 4
This page cannot be seen from the preview
Don't miss anything!
Descriptive analytics - correct answer What occurred in the past Normalizing - correct answer Reduce data redundancy & Improves data integrity Does NOT eliminate relationship In batch processing, it takes longer time to process in bulk - correct answer Latency is expected Diagnostic analytics - correct answer Why events happened Prescriptive analytics - correct answer Which actions should be taken Cognitive analytics - correct answer Draw inferences from existing data and patterns, derive conclusions based on existing knowledge bases, and then add these findings back into the knowledge base for future inferences, a self-learning feedback loop Predictive analytics - correct answer What will happen in the future Massively parallel processing (MPP) engine of Az Synapse Analytics - correct answer Distributes processing across computer nodes Clustered index - correct answer is an object associated with a table that sorts and stores the data rows in table based on key values
Embed documents and query results into a SQL notebook - correct answer Azure Data Studio Date Definition Language (DDL) - correct answer Crate DB Schema (e.g.: CREATE, DROP, RENAME, ALTER) Transparent Data Encryption (TDE) - correct answer Encrypts DB to protect data at rest Az SQL managed instance benefit - correct answer native support for cross-db queries and transactions Supports project-oriented offline db dev - correct answer SQL Server data Tools (SSDT) Read only db replica to offload transactions - correct answer e.g. gen reports without affecting transactional workload Throughput for an Azure Cosmos DB account - correct answer Database or container level Azure Data Lake Storage support RBAC - correct answer RBAC at file and folder level Azure Cosmos DB API: Graph Data - correct answer Gremlin API Azure Cosmos DB API: JSON Documents - correct answer MongoDB API Azure Cosmos DB API: Key/Value data - correct answer Table API
Azure Data Factory control flow - correct answer control flow orchestrate pipeline activities that depend on the output of other pipeline activities Provision Apache Spark clusters - correct answer Azure HDInsight and Azure Databricks Compute environment for Azure Data Factory activities - correct answer A linked service Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse - correct answer PolyBase - enables SQL server instance process Transact-SQL queries that read data from external data sources