Free Microsoft Azure Data Fundamentals Exam DP-900 Exam Practice Test

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

• document
• columnar
• graph
• time seriesthe relationship

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)NOTE: Each correct selection is worth one point.

• denormalized data
• heavy writes and moderate reads
• light writes and heavy reads
• schema on write
• schema on read
• normalized data

Which three actions are used when performing diagnostic analytics?

• * Identify data anomalies * Collect anomaly-related data * Discover relationships and trends that explain anomalies.
• * Identify data anomalies * Predict when anomalies are likely to recur * Use analytical tools such as decision trees and regression.
• * Apply serf-learning loops to draw inferences from anomalies. * Predict when anomalies are likely to recur * Use analytical tools such as decision trees and regression.
• * Identify data anomalies * Use machine learning to find patterns in large datasets. * Discover relationships and trends that explain anomalies.

How is raw data stored in a data lakehoose?

• as tables
• as queues
• as files
• as disks

You have a SQL query that combines customer data and order data. The query includes calculated columns.You need to create a database object that would allow other users to rerun the same SQL query.What should you create?

• a scalar function
• a table
• an index
• a view

What is a characteristic of non-relational data?

• a well-defined schema
• no indexes
• self-describing entities
• no unique key values

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

• stream processing
• batch processing
• Online Analytical Processing (OLTP)
• Online Transaction Processing (OLTP)

Which Azure Data Factory component initiates the execution of a pipeline?

• a control flow
• a trigger
• a parameter
• an activity

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

• normalized data
• schema defined in a database
• schema defined when reading unstructured data from a database
• normalized data
• light writes and heavy reads
• heavy writes and moderate reads

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

• supports partitioning
• provides resiliency if art Azure region fads
• provides a higher storage capacity
• supports a multi-master model