Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

DP-900: MICROSOFT AZURE DATA FUNDAMENTALS, Exams of Programming Languages

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

2023/2024

Available from 03/24/2024

star_score_grades
star_score_grades 🇺🇸

3.6

(19)

1.7K documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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
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
pf3
pf4

Partial preview of the text

Download DP-900: MICROSOFT AZURE DATA FUNDAMENTALS and more Exams Programming Languages in PDF only on Docsity!

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