DP 900 Flashcards
Open source db with built in support for temporal data
MariaDB
Azure service to aggregate and store multiple JSON files to minimize dev effort
Azure Cosmos DB (sql api for json)
This type of data workload is optimized for updates and relies on relationships between entities to correlate data
Transactional
Two advantages of using normalization for relational data
Less storage space
Optimized for updates
Two DML statements for modification of existing data
UPDATE
MERGE
Fully managed db with close to 100% parity with sql server
Azure Managed Instance
Azure services where you can control ram, I/O configurations, and CPUs
SQL server on virtual machine
An open source, hybrid relational object database system
Postgre SQL
Azure db service that handles documents, graphs, key/value pairs
Azure Cosmos databases
This azure storage service can support SMB file sharing
Azure Files
This Azure Cosmos API can utilize SQL
Apache Cassandra
Two services for pipelines in response to an event
Data factory
Azure Synapse Analytics
Two services for pre processing large batches of data using Scala
Serverless Spark pool in synapse
Databricks
Characteristic of a batch process
Complex Analysis
What service can perpetually receive data from a Kafka queue
Stream Analytics
What storage solution can support a stream processing architecture and persist processed results as files
Data Lake Storage Gen2
Utilize Apache Hadoop
HDInsight
Feature of transactional data processing guarantees concurrent processes cannot see the data in an inconsistent state
Isolation
Service is managed and serverless, avoids windows server licenses and allows for each workload to have its own instance of the service
Azure SQL database
Azure Cosmos DB API for data in column family structure
Apache Cassandra
Azure Cosmos api to process many json files every minute, while keeping it accessible by native queries
NoSQL
Type of data store using star schemas, fact tables, and dimension tables
Data warehouse
Three services for ingesting data for stream processing
Event hubs
Data lake storage
IoT hub
Data service that allows migrating an entire sql server without requiring managing the infrastructure after migration
Sql managed instance
Azure storage to store key/value pairs grouped in partitions
Azure table storage
In a stream processing architecture, what can be used to persist the results as files
Data lake storage gen2
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
Azure data explorer
Data model element representing entities by which you aggregate measures
Dimensions
