DP-900 AZURE DATA FUNDAMENTALS

An Index

Allows you to search for data in a table more efficiently. Improves performance of a query accessing a table with many rows

SELECT-INTO

Copies all rows / results from one table to a new table. Does an insert into a table

3 database objects allow you to reuse the query definition

A function, stored procedure, and view

Which three statements accurately describe the properties of a table in a relational database?

1,)A table can have a primary key build on multiple columns. 2.)Each column must have a datatype. 3.)Each row in a table has the same number of columns.

a virtual table based on the results of a SELECT query.

A view

A data service that provides a fully managed relational database with close to 100 percent feature parity with Microsoft SQL Server

Azure SQL Database

Three open-source databases are available as platform as a service (PaaS) in Azure

MariaDB, MySQL, PostgreSQL

A data service allows you to use every feature of Microsoft SQL Server in the cloud

SQL Server on an Azure Virtual Machines running Windows

An open-source database has built-in support for temporal data and enables applications to query data as the data appeared in previous points in time.

MariaDB

A SQL engine is optimized for IoT scenarios that must work with streaming time series data

Azure SQL Edge

A type of Azure Storage is the least expensive option that allows you to store new or modified image files

block blobs in the Archive tier

Two storage solutions can be mounted in Azure Synapse Analytics and used to process large volumes of data

Azure Data Lake Storage and Azure Blob Storage.

Two characteristics of Azure Table storage?

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

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

Azure Files

A native API in Cosmos DB. It manages data in the JSON format.

NoSQL

A storage solution that allows you to aggregate data stored in JSON files for use in analytical reports without additional development effort?

Azure Cosmos DB

A data structure allows you to store data in a two-column format without requiring a complex database management system, used for simple lookups based on a single key to obtain a single value.

Key/Value store

stores data in BSON format

MongoDB

best option for CRUD operations and uses the least amount of storage space.

Relational Database

used to store sequential data

Time Series Database

used for snowflake schemas with historical data

OLAP Database

allows you to store data as a graph database.

Azure Cosmos DB

are used to store semi and unstructured, tabular data comprising rows and columns processed by an Apache Spark pool in Azure Synapse Analytics

column-family

three properties of analytical data workloads

historical data, are optimized for read operations, and calculate business metrics over time

responsible for designing database solutions, creating databases, and developing stored procedures?

Database Engineer

responsible for troubleshooting index performance, provisioning access to databases, and backing up databases

Database Administrator

responsible for creating reports from a database and using OLAP cubes

Database Analyst

two DML statements are used to modify the existing data in a table

MERGE and UPDATE

a platform as a service (PaaS) service that is compatible with SQL Server 2016.

Azure SQL Managed Instance

allows you to create a single database that can scale up and down without downtime

SQL Azure SQL Database

process large amounts of data by using Apache Hadoop

Azure HDInsight

A data store uses star schemas, fact tables, and dimension tables

Data Warehouse

allows you to orchestrate data flow without coding by using pipelines

Azure Data Factory

two services allow you to create a pipeline to process data in response to an event

Azure Data Factor and Azure Synapse Analytics

two services allow you to pre-process a large volume of data by using Scala?

Azure Databricks and serverless Apache Spark pool in Azure Synapse Analytics

a characteristic of batch processing

Complex analysis can be performed

service you use to retrieve data from a Kafka queue, process the data, and write the data to Azure Data Lake

Azure Stream Analytics

three services can be used to ingest data for stream processing

Data Lake Storage, Event Hubs, and IoT Hub

data model element represents the entities by which you want to aggregate measures in Microsoft Power BI?

Dimension

type of visual in Microsoft Power BI should you use to display a single value, such total sales

card