DP 900

Question 1

Open source db with built in support for temporal data

Answer 1

MariaDB

Question 2

Azure service to aggregate and store multiple JSON files to minimize dev effort

Answer 2

Azure Cosmos DB (sql api for json)

Question 3

This type of data workload is optimized for updates and relies on relationships between entities to correlate data

Answer 3

Transactional

Question 4

Two advantages of using normalization for relational data

Answer 4

Less storage space
Optimized for updates

Question 5

Two DML statements for modification of existing data

Answer 5

UPDATE
MERGE

Question 6

Fully managed db with close to 100% parity with sql server

Answer 6

Azure Managed Instance

Question 7

Azure services where you can control ram, I/O configurations, and CPUs

Answer 7

SQL server on virtual machine

Question 8

An open source, hybrid relational object database system

Answer 8

Postgre SQL

Question 9

Azure db service that handles documents, graphs, key/value pairs

Answer 9

Azure Cosmos databases

Question 10

This azure storage service can support SMB file sharing

Answer 10

Azure Files

Question 11

This Azure Cosmos API can utilize SQL

Answer 11

Apache Cassandra

Question 12

Two services for pipelines in response to an event

Answer 12

Data factory
Azure Synapse Analytics

Question 13

Two services for pre processing large batches of data using Scala

Answer 13

Serverless Spark pool in synapse
Databricks

Question 14

Characteristic of a batch process

Answer 14

Complex Analysis

Question 15

What service can perpetually receive data from a Kafka queue

Answer 15

Stream Analytics

Question 16

What storage solution can support a stream processing architecture and persist processed results as files

Answer 16

Data Lake Storage Gen2

Question 17

Utilize Apache Hadoop

Answer 17

HDInsight

Question 18

Feature of transactional data processing guarantees concurrent processes cannot see the data in an inconsistent state

Answer 18

Isolation

Question 19

Service is managed and serverless, avoids windows server licenses and allows for each workload to have its own instance of the service

Answer 19

Azure SQL database

Question 20

Azure Cosmos DB API for data in column family structure

Answer 20

Apache Cassandra

Question 21

Azure Cosmos api to process many json files every minute, while keeping it accessible by native queries

Answer 21

NoSQL

Question 22

Type of data store using star schemas, fact tables, and dimension tables

Answer 22

Data warehouse

Question 23

Three services for ingesting data for stream processing

Answer 23

Event hubs
Data lake storage
IoT hub

Question 24

Data service that allows migrating an entire sql server without requiring managing the infrastructure after migration

Answer 24

Sql managed instance

Question 25

Azure storage to store key/value pairs grouped in partitions

Answer 25

Azure table storage

Question 26

In a stream processing architecture, what can be used to persist the results as files

Answer 26

Data lake storage gen2

Question 27

Service for on demand analysis of large volumes of data from text logs, websites, and IoT devices by using a common querying language for all sources

Answer 27

Azure data explorer

Question 28

Data model element representing entities by which you aggregate measures

Answer 28

Dimensions