things i dont know from microsoft practice exam

Unstructured data

data such as documents, images, audio data, video data, and binary files

Graph databases

These type of DBs are good for hierarchical and organizational data.

Transactional (data) workloads

These are optimized for create, read, update, and delete (CRUD) operations and relies on relationships between entities to correlate data.

Two advantages of using normalization over not using normalization

It is optimized for updates and it uses less storage space

Two DML statements that are used to MODIFY the existing data in a table

MERGE and UPDATE

Azure SQL Database

This is managed and serverless, avoids the use of Windows Server licenses, and allows for each workload to have its own instance of the service being used.

Azure SQL Managed Instance

This Azure data service is fully managed (PaaS) and is compatible with SQL Server 2016.

Azure Files

This service is used to store large amounts of files to be shared with virtual machines by using SMB. Used to share files by using NFS and SMB.

This allows you to create cloud-based network shares to make documents and other files available to multiple users.

Two characteristics of Azure Table storage are that…

Each RowKey value is unique within a table partition and Items in the same partition are stored in a RowKey order.

Azure Synapse Analytics

This service allows you to perform near real-time analytics on the operational data stored in Azure Cosmos DB

Batch processing

is used to execute complex analysis

Azure Data Lake Storage Gen2

This can be used in a stream processing architecture to persist the processed results as files. Can be used to store files.

Azure Data Explorer

This is used for the analysis of large amounts of text log data, websites, and IoT devices and uses a common querying language.

Azure Stream Analytics

This allows you to aggregate data from a specific period before it is written to a data lake

To share data models and reports created in Power BI Desktop…

…, first publish the report to the Power BI service

Azure Cosmos DB SQL API

Optimized to store and process (transform) JSON files with minimized development effort. This allows you to query the documents by using SQL-like language.

Azure SQL Database

This allows you to provision a single database on a dedicated server and has on-demand scalability.

Azure Databricks

Can run data processing for large amounts of data by using Scala

A serverless Apache Spark pool in Azure Synapse Analytics

Can run data processing for large amounts of data by using Scala

Data Lake Storage, Event Hubs, and IoT Hub

are sources commonly used to ingest data for stream processing.