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

Which 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