Microsoft Azure Data Fundamentals DP-900 Terms & Definitions

Relational data uses ____ to enforce relationships between different tables.

keys

You have an inventory management database that contains the following table. Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

UPDATE

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

Azure SQL Database

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?

Azure Data Studio

Table

A database object that holds data

View

A database object whose content is defined by a query

Index

A database object that helps improve the speed of data retrieval.

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

Online Transaction Processing (OLTP)

When can you use an Azure Resource Manager template?

to automate the creation of an interdependent group of Azure resources in a repeatable way

You have an Azure SQL database that you access directly from the Internet. You recently changed the public IP address of your computer. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure. hat is a possible cause of the issue?

a database-level firewall

Microsoft SQL Server Management Studio (SSMS)

for managing SQL Server or Azure SQL databases that support access, config. man. and admin. tasks.

Azure Data Studio

can run on-demand SQL queries and view and save results as text, JSON, or MS Excel files

Microsoft SQL Server Data Tools (SSDT)

for building Azure SQL databases, MS SQL Server relational databases, SQL Server Analysis Services (SSAS) data models, SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports.

Relational database tables contain columns and rows

Yes

Indexes in a relational database describe the data types in a table

No

A database view is a virtual table whose content is defined by a query

Yes

Which command-line tool can you use to query Azure SQL databases?

sqlcmd

Azure SQL Database includes a managed backup service.

Yes

Azure SQL Database has built-in high availability

Yes

Azure SQL Database can use Azure Defender

Yes

You can use Azure Data Studio to query a MS SQL Server big data cluster.

Yes

You can use MS SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse

Yes

You can use MySQL Workbench to query Azure Database for MariaDB databaes

Yes

PaaS database offerings in Azure provide built-in high availability

Yes

PaaS database offerings in Azure provide configurable scaling options

Yes

PaaS database offerings in Azure reduce the admin. overhead for managing hardware

Yes

You have the following SQL query.What are dbo.Products and ProductName?

- Dbo.Products:

- ProductName:

- A table

- A column

Descriptive analytics tells you

what occurred in the past

Normalization involves eliminating relationships between database tables

No

Normalizing a database reduces data redundancy

Yes

Normalization improves data integrity

Yes

An ETL process requires

data that is fully processed before being loaded to the target data store.

In batch processing,

latency in delivering data processing results is acceptable

Transcribing audio files is an example of

cognitive

Diagnostic

Why did sales increase last month?

Prescriptive

How do I allocate my budget to buy different inventory items?

Descriptive

Which people are mentioned in a company's business documents?

Customer is ____

Address is ____

Social Media is ____

- a root object

- a nested object

- a nested array

The data model is a ____

Customer is a ____

- Star schema

- dimension

The massively parallel processing (MPP) engine of Azure Synapse Analytics

distributes processing across compute nodes.

A clustered index

is an object associated with a table that sorts and stores the data rows in the table based on their key values

A relational database is appropriate for scenarios that involve a high volume of

transactional writes

Batch processing can output data to a file store

Yes

Batch processing can output data to a relational database

No

Batch processing can output data to a NoSQL database

No

Extract:

Load:

Transform:

The CRM system

The data warehouse

An in-memory data integration tool

A visualization that shows a university's current student enrollment versus the max. capacity is an example of

descriptive

Treemap

A chart of colored, nested rectangles that displays indiv. data points by size and color

Key influencer

A chart that displays the major contributors of a selected result or value

Scatter

A chart that shows the relationship between two numerical values

DML

INSERT, UPDATE, DELETE, MERGE, CALL

DDL

CREATE, ALTER, DROP, TRUNCATE AND COMMENT and RENAME

You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account?

- read-access geo-redundant storage (RA-GRS)

- geo-redundant storage (GRS)

PaaS database offerings in Azure require less setup and config. effort than IaaS database offerings

Yes

PaaS database offerings in Azure provide end users with the ability to control and update the OS version

No

All relation and non-relational PaaS database offering in Azure can be paused to reduce costs

No

Which statement is an example of Data Manipulation Language (DML)?

INSERT

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create?

a view

A key/value data store is optimized for

simple lookups

Match the types of data to the appropriate Azure data services.

- Image files

Azure Blob storage

Match the types of data to the appropriate Azure data services.

- Key/value pairs

Azure Cosmos DB Gremlin API

Match the types of data to the appropriate Azure data services.

- Relationships between employees

Azure Table storage

Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy.

Azure Resource Group

-- _____

--- _____

---- Folders

----- Files

-- Azure Storage account

--- File share

What are two characteristics of real-time data processing? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

- Low latency is expected

- Data is processed as it is created

Match the Azure Data Factory components to the appropriate descriptions.

- Dataset

A representation of data structures within data stores

Match the Azure Data Factory components to the appropriate descriptions.

- Linked service

The information used to connect to external resources

Match the Azure Data Factory components to the appropriate descriptions.

- Pipeline

A logical grouping of activities that performs a unit of work and can be scheduled.

Match the types of workloads to the appropriate scenarios.

- Batch

Data for a product catalog will be loaded every 12 hours to a data warehouse

Match the types of workloads to the appropriate scenarios.

- Streaming

Thousands of data sets per second for online purchases

Match the types of workloads to the appropriate scenarios.

- Batch

Updates to inventory data will be loaded to a data warehouse every 1 million transactions.

Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process?

Extract:

Load:

Transform:

The CRM system

The data warehouse

A standalone data analysis tool

Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?

predictive

Which statement is an example of Data Manipulation Language (DML)?

UPDATE

Creating closed caption text for audio files is an example of

descriptive

A visualization that illustrates a university's current student enrollment per dept. is an example of ____ analytics

descriptive

An ELT process requires

a target data store powerful enough to transform data.

You need to create an Azure resource to store data in Azure Table storage. Which command should you run?

az storage container create

The Azure Cosmos DB ____ API enables the user of SELECT statements to retrieve documents form Azure Cosmos DB

Core (SQL)

You need to modify a view in a relational database by adding a new column. Which statement should you use?

ALTER

ETL can reduce the transfer of sensitive data to destination systems.

No

ELT transforms data by using a compute resource independent of the source system and destination system

Yes

ELT minimizes the time it takes to copy large volumes of data to decantation systems.

No

You plan to deploy a PostgreSQL database to Azure. Which hosting model corresponds to the available deployment options?

- PostgreSQL on Azure VMS

SaaS

You plan to deploy a PostgreSQL database to Azure. Which hosting model corresponds to the available deployment options?

- Azure Database for PostgreSQl

PaaS

Column family databases

natively support the analysis of relationships between entities.

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

Azure Data Lake Storage

Relational data is stored in

a tabular form of rows and columns

A clustered index

physically sorts the data in a table based on the values in a specified column.

A block of code that runs in a database is called

a stored procedure

Why did sales increase last month?

diagnostic

Provide specific guidance on how to allocate current budget to buy different inventory items.

Prescriptive

Detect images of the company's logo included in PDF documents

Cognitive

A view

presents content defined by a query.

Which type of database is Azure Database for PostgreSQL?

Platform as a service (PaaS)

Which storage solution supports access control lists (ACLs) at the file and folder level?

Azure Data Lake Storage

A treemap

is a chart of colored rectangles. The size of the rectangles are relative to the value of each.

What is a characteristic of batch processing?

Batch processing can only process data that is structured.

In a SQL statement, ____ are examples of aggregate functions.

MAX and MIN

A job that processes sales data once daily is an example of a batch workload.

Yes

A job that calculates a rolling avg. temp. reading is an example of a streaming workload.

Yes