DP-900 Flashcards by Elizabeth Kahn

Descriptive analytics tells you
1. what is most likely to occur in the future
2. what occurred in the past
3. which actions you can perform to affect outcomes
4. why something occurred in the past

How well did you know this?

Not at all

Perfectly

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
1. Normalization involves eliminating relationships between database tables
2. Normalizing a database reduces data redundancy
3. Normalization improves data integrity

How well did you know this?

Not at all

Perfectly

An extract, transform and load (ETL) process requires:
1. a matching schema in the data source and the data target
2. a target data store powerful enough to transform data
3. data that is fully processed before being loaded to the target data store
4. that the data target be a relational database

How well did you know this?

Not at all

Perfectly

In batch processing
1. data is always inserted one row at a time
2. data is processed in real-time
3. latency in delivery data processing results is acceptable
4. processing can only execute serially

How well did you know this?

Not at all

Perfectly

Transcibing audio files is an example of
1. cognitive
2. descriptive
3. predictive
4. prescriptive
analytics

How well did you know this?

Not at all

Perfectly

Match the types of analytics that can be used to answer the business questions.
Cognitive, diagnostic, descriptive, predictive, prescriptive
1. why did sales increase last month?
2. how do I allocate my budget to buy different inventory items?
3. which people are mentioned in a company’s business documents?

diagnostic
prescriptive
descriptive

How well did you know this?

Not at all

Perfectly

Are the Customer, Address, and Social Media objects:
a) a nested array
b) a nested object
c) a root object

Customer - root object
Address - nested object
Social media - nested array

How well did you know this?

Not at all

Perfectly

The data model is:
- transactional model
- star schema
- snowflake schema

Customer is a [] table:
- fact
- dimension
- bridge

star
dimension

How well did you know this?

Not at all

Perfectly

distributes processing across compute nodes

How well did you know this?

Not at all

Perfectly

a clustered index

How well did you know this?

Not at all

Perfectly

transactional writes

How well did you know this?

Not at all

Perfectly

yes
yes
yes

How well did you know this?

Not at all

Perfectly

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? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all.

Extract: CRM system
Load: Data warehouse
Transform: Data warehouse

How well did you know this?

Not at all

Perfectly

descriptive

How well did you know this?

Not at all

Perfectly

Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all.

Tree map
Key influencer
Scatter

How well did you know this?

Not at all

Perfectly

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? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. zone-redundant storage (ZRS)
B. read-access geo-redundant storage (RA-GRS)
C. locally-redundant storage (LRS)
D. geo-redundant storage (GRS)

B and D

How well did you know this?

Not at all

Perfectly

Yes
No
No

How well did you know this?

Not at all

Perfectly

Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT

INSERT

How well did you know this?

Not at all

Perfectly

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. an index
B. a view
C. a scalar function
D. a table

a view

How well did you know this?

Not at all

Perfectly

simple lookups

How well did you know this?

Not at all

Perfectly

Image files - Azure Blob storage
Key/value pairs - Azure Table storage
Relationships - Gremlin API

How well did you know this?

Not at all

Perfectly

Azure Storage account
Container

How well did you know this?

Not at all

Perfectly

What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Data is processed periodically
B. Low latency is expected
C. High latency is acceptable
D. Data is processed as it is created

B and D

How well did you know this?

Not at all

Perfectly

Dataset
Linked service
Pipeline

How well did you know this?

Not at all

Perfectly

Batch
Streaming
Batch

How well did you know this?

Not at all

Perfectly

Extract: The CRM system
Load: the data warehouse
Transform: the data warehouse

How well did you know this?

Not at all

Perfectly

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?
A. predictive
B. prescriptive
C. descriptive
D. diagnostic

How well did you know this?

Not at all

Perfectly

Which statement is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. CREATE
D. UPDATE

D Update

How well did you know this?

Not at all

Perfectly

descriptive

How well did you know this?

Not at all

Perfectly

How well did you know this?

Not at all

Perfectly

You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?
A. az storage share create
B. az storage account create
C. az cosmosdb create
D. az storage container create

az storage account create

How well did you know this?

Not at all

Perfectly

Core (SQL)

How well did you know this?

Not at all

Perfectly

You need to modify a view in a relational database by adding a new column.
Which statement should you use?
A. MERGE
B. ALTER
C. INSERT
D. UPDATE

ALTER

How well did you know this?

Not at all

Perfectly

Yes
No
Yes

How well did you know this?

Not at all

Perfectly

You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.

IaaS
PaaS

How well did you know this?

Not at all

Perfectly

cognitive

How well did you know this?

Not at all

Perfectly

Graph databases

How well did you know this?

Not at all

Perfectly

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
A. Azure Table storage
B. Azure Data Lake Storage
C. Azure Queue storage
D. Azure Files

B Azure Data Lake Storage

How well did you know this?

Not at all

Perfectly

C) a tabular form of rows and columns

How well did you know this?

Not at all

Perfectly

A stored procedure

How well did you know this?

Not at all

Perfectly

Diagnostic
Prescriptive
Cognitive

How well did you know this?

Not at all

Perfectly

A view

How well did you know this?

Not at all

Perfectly

Which type of database is Azure Database for PostgreSQL?
A. Platform as a service (PaaS)
B. Infrastructure as a service (IaaS)
C. Microsoft SQL Server
D. on-premises

Platform as a Service

How well did you know this?

Not at all

Perfectly

Which storage solution supports access control lists (ACLs) at the file and folder level?
A. Azure Data Lake Storage
B. Azure Queue storage
C. Azure Blob storage
D. Azure Cosmos DB

Azure Data Lake Storage

How well did you know this?

Not at all

Perfectly

Treemap

How well did you know this?

Not at all

Perfectly

What is a characteristic of batch processing?
A. The data ingested during batch processing must be processed as soon as the data is received.
B. Large datasets must be split into batches of less than 1 GB before the data can be processed.
C. There is a noticeable time delay between ingesting data and obtaining the data processing results.
D. Batch processing can only process data that is structured.

How well did you know this?

Not at all

Perfectly

MAX and MIN

How well did you know this?

Not at all

Perfectly

Yes
Yes
No

How well did you know this?

Not at all

Perfectly

The same set of columns

How well did you know this?

Not at all

Perfectly

A clustered index

How well did you know this?

Not at all

Perfectly

No
No
Yes

How well did you know this?

Not at all

Perfectly

Graph databases

How well did you know this?

Not at all

Perfectly

Simple lookups

How well did you know this?

Not at all

Perfectly

virtual machine

How well did you know this?

Not at all

Perfectly

semi-structured data

How well did you know this?

Not at all

Perfectly

semi-structured data

How well did you know this?

Not at all

Perfectly

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
A. atomicity
B. isolation
C. durability
D. consistency

atomicity

How well did you know this?

Not at all

Perfectly

Which type of data store is this?
A. key/value
B. object data
C. graph
D. time series

Graph

How well did you know this?

Not at all

Perfectly

Which type of database contains nodes and edges?
A. graph
B. key/value
C. columnar
D. time series

graph

How well did you know this?

Not at all

Perfectly

data engineer

How well did you know this?

Not at all

Perfectly

keys

How well did you know this?

Not at all

Perfectly

A. INSERT
B. MERGE
C. UPDATE
D. CREATE

UPDATE

How well did you know this?

Not at all

Perfectly

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.

Which Azure service should you use?
A. Azure HDInsight
B. Azure SQL Database
C. Azure Cosmos DB
D. SQL Server on Azure Virtual Machines

B. Azure SQL Database

How well did you know this?

Not at all

Perfectly

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?
A. Microsoft SQL Server Management Studio (SSMS)
B. Azure Data Studio
C. Azure CLI
D. Azure PowerShell

B. Azure Data Studio

How well did you know this?

Not at all

Perfectly

Table
View
Index

How well did you know this?

Not at all

Perfectly

You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?
A. stream processing
B. batch processing
C. Online Analytical Processing (OLAP)
D. Online Transaction Processing (OLTP)

OLTP

How well did you know this?

Not at all

Perfectly

When can you use an Azure Resource Manager template?
A. to automate the creation of an interdependent group of Azure resources in a repeatable way
B. to apply Azure policies for multi-tenant deployments
C. to provision Azure subscriptions
D. to control which services and feature administrators and developers can deploy from the Azure portal

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

How well did you know this?

Not at all

Perfectly

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.
What is a possible cause of the issue?
A. role-based access control (RBAC)
B. Dynamic Host Configuration Protocol (DHCP)
C. Domain Name Service (DNS)
D. a database-level firewall

a database level firewall

How well did you know this?

Not at all

Perfectly

Microsoft SQL Server Management Studio (SSMS)
Azure Data Studio
Microsoft SQL Server Data Tools (SSDT)

How well did you know this?

Not at all

Perfectly

Yes
No
Yes

How well did you know this?

Not at all

Perfectly

Which command-line tool can you use to query Azure SQL databases?
A. sqlcmd
B. bcp
C. azdata
D. Azure CLI

sqlcmd

How well did you know this?

Not at all

Perfectly

Yes
Yes
Yes

How well did you know this?

Not at all

Perfectly

Yes
Yes
Yes

How well did you know this?

Not at all

Perfectly

Yes
Yes
Yes

How well did you know this?

Not at all

Perfectly

You have the following SQL query.

INSERT INTO dbo.Products (ProductID, ProductName, Price, ProductDescription)
VALUES (1, ‘Clamp’, 12.48, ‘Workbench clamp’);

What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.

Table
Column

How well did you know this?

Not at all

Perfectly

No
No
Yes

How well did you know this?

Not at all

Perfectly

Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. UPDATE
D. CREATE

CREATE

How well did you know this?

Not at all

Perfectly

Yes
No
Yes

How well did you know this?

Not at all

Perfectly

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?
A. Azure Cosmos DB
B. Azure HDInsight
C. Azure SQL Database
D. Azure Synapse Analytics

Azure SQL Database

How well did you know this?

Not at all

Perfectly

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database?

A. access to the latest features
B. complete control over backup and restore processes
C. in-database machine learning services
D. reduced administrative effort for managing the server infrastructure

access to the latest features
reduced administrative effort

How well did you know this?

Not at all

Perfectly

No
Yes
No

How well did you know this?

Not at all

Perfectly

How would you query this table to return the average sales per day?

SELECT, GROUP BY

How well did you know this?

Not at all

Perfectly

When you create an Azure SQL database, which account can always connect to the database?
A. the Azure Active Directory (Azure AD) account that created the database
B. the server admin login account of the logical server
C. the Azure Active Directory (Azure AD) administrator account
D. the sa account

the server admin

How well did you know this?

Not at all

Perfectly

Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. INSERT
C. DELETE
D. DROP

DROP

How well did you know this?

Not at all

Perfectly

A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as
IntelliSense.
What should the developers use?
A. sqlcmd
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Data Studio
D. Azure Data Explorer

Azure Data Studio

How well did you know this?

Not at all

Perfectly

the database to protect data at rest

How well did you know this?

Not at all

Perfectly

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?
A. service principal authentication
B. Azure Active Directory (Azure AD) authentication
C. SQL authentication
D. certificate authentication

Azure Active Directory (Azure AD) authentication)

How well did you know this?

Not at all

Perfectly

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
A. built-in high availability
B. native support for cross-database queries and transactions
C. system-initiated automatic backups
D. support for encryption at rest

native support for cross-database queries and transactions

How well did you know this?

Not at all

Perfectly

a server-level firewall

How well did you know this?

Not at all

Perfectly

You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?
A. Microsoft SQL Server Data Tools (SSDT)
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Databricks
D. Azure Data Studio

Microsoft SQL Server Data Tools (SSDT)

How well did you know this?

Not at all

Perfectly

Match the security components to the appropriate scenarios.

Firewall
Authentication
Encryption

How well did you know this?

Not at all

Perfectly

You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?
A. You need to generate reports without affecting the transactional workload.
B. You need to audit the transactional application.
C. You need to implement high availability in the event of a regional outage.
D. You need to improve the recovery point objective (RPO).

you need to generate reports without affecting the transactional workload

How well did you know this?

Not at all

Perfectly

strong consistency guarantees are required

How well did you know this?

Not at all

Perfectly

keys

How well did you know this?

Not at all

Perfectly

a view

How well did you know this?

Not at all

Perfectly

You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. You must be assigned the Reader role for the resource group that contains the database.
B. You must have SELECT access to the Products table.
C. You must have a user in the database.
D. You must be assigned the Contributor role for the resource group that contains the database.
E. Your IP address must be allowed to connect to the database.

SELECT access, user in the database, IP address

How well did you know this?

Not at all

Perfectly

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
A. SET
B. JOIN
C. KEY

JOIN

How well did you know this?

Not at all

Perfectly

Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.
What should you use?
A. Azure Application Gateway
B. Azure Traffic Manager
C. Azure DNS
D. Azure Private Link

Azure Private Link

How well did you know this?

Not at all

Perfectly

Azure SQL Database single database = a serverless configuration
Azure SQL Database Managed Instance = highest compatibility with on-prem Microsoft SQL Server
Azure SQL Database elastic pool = a low-cost, low-maintenance database

How well did you know this?

Not at all

Perfectly

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
A. SELECT
B. WHERE
C. JOIN

WHERE

How well did you know this?

Not at all

Perfectly

Azure Synapse Analytics

How well did you know this?

Not at all

Perfectly

A clustered index

How well did you know this?

Not at all

Perfectly

What are dbo.Products and ProductName?

A Table, a column

How well did you know this?

Not at all

Perfectly

Primary key

How well did you know this?

Not at all

Perfectly

A view

How well did you know this?

Not at all

Perfectly

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
A. Azure SQL Database
B. Azure Database for MySQL
C. Azure SQL Managed Instance
D. an Azure SQL Database elastic pool

Azure SQL Managed Instance

How well did you know this?

Not at all

Perfectly

Which setting can only be configured during the creation of an Azure Cosmos DB account?
A. geo-redundancy
B. multi-region writes
C. production or non-production account type
D. API

API

How well did you know this?

Not at all

Perfectly

Key/value
Object
Graph

How well did you know this?

Not at all

Perfectly

You have an Azure Cosmos DB account that uses the Core (SQL) API.
Which two settings can you configure at the container level?
A. the throughput
B. the read region
C. the partition key
D. the API

throughput and partition key

How well did you know this?

Not at all

Perfectly

Which type of data store should you use?
A. graph
B. key/value
C. object
D. columnar

columnar

How well did you know this?

Not at all

Perfectly

Which storage solution supports role-based access control (RBAC) at the file and folder level?
A. Azure Disk Storage
B. Azure Data Lake Storage
C. Azure Blob storage
D. Azure Queue storage

Azure Data Lake Storage

You need to store data in Azure Blob storage for seven years to meet your company’s compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.
Which storage tier should you use?
A. Archive
B. Hot
C. Cool

Archive

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
A. document
B. columnar
C. graph
D. time series

document

Gremlin API = graph data
MongoDB API = JSON
Table API = key/value

enable the hierarchical namespace

using Gremlin language.

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

A. multi-master replication
B. Availability Zones
C. the strong consistency level
D. automatic failover

Availability Zones

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

A. provides resiliency if an Azure region fails
B. supports partitioning
C. provides a higher storage capacity
D. supports a multi-master model

supports a multi-master model

Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network.
Which type of data store should you use?

A. graph
B. key/value
C. document
D. columnar

graph

Yes
Yes
Yes

Cosmos, Azure Files

account

You need to store data by using Azure Table storage.
What should you create first?

A. an Azure Cosmos DB instance
B. a storage account
C. a blob container
D. a table

a storage account

You need to recommend a data store service that meets the following requirements:
✑ Native SQL API access
✑ Configurable indexes
What should you recommend?

A. Azure Files
B. Azure Blob storage
C. Azure Table storage
D. Azure Cosmos DB

Azure Cosmos DB

No, No, Yes, Yes

enable the hierarchical namespace

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.
Which type of data store should you use?

A. graph
B. key/value
C. document
D. columnar

graph

You manage an application that stores data in a shared folder on a Windows server.
You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?

A. queue
B. blob
C. file
D. table

file storage

Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?

A. key/value
B. graph
C. columnar
D. document

columnar

You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?

A. Azure Files
B. Azure Blob storage
C. Azure Cosmos DB
D. Azure Table storage

Azure Files

No, Yes, No

Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?

A. columnar
B. key/value
C. document
D. graph

document

You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?

A. key/value
B. columnar
C. object
D. document

object

Your company is designing a data store for internet-connected temperature sensors.
The collected data will be used to analyze temperature trends.
Which type of data store should you use?

A. relational
B. time series
C. graph
D. columnar

time series

Yes, Yes, Yes

graph

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. database
B. item
C. container
D. partition

database and container

Yes, No, Yes, Yes

What is a characteristic of non-relational data?

A. no indexes
B. self-describing entities
C. a well-defined schema
D. no unique key values

self describing entities

PolyBase

You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?

A. Online Transaction Processing (OLTP)
B. batch
C. massively parallel processing (MPP)
D. streaming

streaming

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact.
What should you do on the dedicated SQL pool?

A. Scale down the data warehouse units (DWUs).
B. Pause the pool.
C. Create a user-defined restore point.
D. Delete the pool

Pause the pool

Which Azure Data Factory component initiates the execution of a pipeline?

A. a control flow
B. a trigger
C. a parameter
D. an activity

A trigger

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?

A. stream processing
B. batch processing
C. Online Analytical Processing (OLAP)
D. Online Transaction Processing (OLTP)

OLAP

Data movement - copy
Data transformation - mapping
Control - lookup

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema on write
E. schema on read
F. normalized data

B, D, F

Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. report and dashboard creation
B. report sharing and distribution
C. data modeling
D. data acquisition and preparation

report and dashboard creation, report sharing and distribution

a control flow

You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

A. a view
B. a report
C. a dataflow
D. Microsoft Power Apps

a report

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Azure Time Series Insights
B. Azure HDInsight
C. Azure Databricks
D. Azure Log Analytics

HGInsight and Databricks

You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?

A. Online Transaction Processing (OLTP)
B. batch processing
C. Online Analytical Processing (OLAP)
D. stream processing

OLAP

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. a report page
B. a Microsoft PowerPoint slide
C. a visualization from a report
D. a dataflow
E. a text box

a report page, a visualization, a text box

Yes, No, Yes

Which Azure Data Factory component provides the compute environment for activities?

A. SSIS packages
B. an integration runtime
C. a control flow
D. a pipeline

an integration runtime

paginated report

What are two uses of data visualization? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Represent trends and patterns over time
B. Implement machine learning to predict future values
C. Communicate the significance of data
D. Enforce business logic across reports

A and C

You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse.
What should you use to query the files?

A. Azure Functions
B. Microsoft SQL Server Integration Services (SSIS)
C. PolyBase
D. Azure Data Factory

PolyBase

No, No, Yes

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema defined in a database
E. schema defined when reading unstructured data from a database
F. normalized data

B, D, F

What is the primary purpose of a data warehouse?

A. to provide answers to complex queries that rely on data from multiple sources
B. to provide transformation services between source and target data stores
C. to provide read-only storage of relational and non-relational historical data
D. to provide storage for transactional line-of-business (LOB) applications

Match the Azure services to the appropriate locations in the architecture.

Azure Data Factory, Azure Synapse Analytics

Batch, Batch, Streaming

from multiple sources is combined

No, Yes, Yes

Synapse, Data Lake, Database

Yes, Yes, No

What should you use to build a Microsoft Power BI paginated report?

A. Charticulator
B. Power BI Desktop
C. the Power BI service
D. Power BI Report Builder

Power BI Report Builder

Data Factory, Synapse

Yes, No, Yes

Which scenario is an example of a streaming workload?

A. sending transactions that are older than a month to an archive
B. sending transactions daily from point of sale (POS) devices
C. sending telemetry data from edge devices
D. sending cloud infrastructure metadata every 30 minutes

collect data and then process the data when a condition is met

Yes, Yes, No

A bar chart showing year-to-date sales by region is an example of which type of analytics?

A. predictive
B. prescriptive
C. descriptive
D. diagnostic

descriptive

Yes, No, Yes

You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?

A. Synapse pipelines
B. a Synapse SQL pool
C. Synapse Link
D. Synapse Studio

Synapse Link

What should you create in Power BI Desktop?

A. a waterfall chart
B. a ribbon chart
C. a bar chart
D. a decomposition tree

Waterfall chart

graph

Which type of data do the tables contain?

A. structured
B. non-relational
C. semi-structured
D. unstructured

Structured

gremlin language

Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache?

A. the Hot access tier
B. change feed
C. snapshots
D. versioning

change feed

You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
* Minimize maintenance effort.
* Support the Database Mail and Service Broker features.
What should you include in the solution?

A. Azure SQL Database single database
B. an Azure SQL Database elastic pool
C. Azure SQL Managed instance
D. SQL Server on Azure virtual machines

Managed instance

C - data is fully processed

CRM, DW, DW

what occured in the past

What is a function of a modern data warehouse?

A. supports batch processing only
B. supports real-time and batch processing
C. provides built-in or native online analytical processing
D. stores raw data only

C - provides built-in and batch processing

hierarchical namespace

What can be used with native notebook support to query and visualize data by using a web-based interface?

A. Azure Databricks
B. pgAdmin
C. Microsoft Power BI

Azure Databricks

Which format was used?

A. XML
B. HTML
C. YAML
D. JSON

JSON

Which format was used?

A. JSON
B. YAML
C. HTML
D. XML

XML

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?

A. consistency
B. atomicity
C. durability
D. isolation

durability

strong consistency guarantees

tabular form

Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?

A. atomicity
B. durability
C. isolation
D. consistency

atomicity

a clustered index

Which Azure Storage service implements the key/value model?

A. Azure Queue
B. Azure Files
C. Azure Table
D. Azure Blob

Azure Table

semi-structured

from multiple sources

delays are acceptable

You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes.
What should you include in the solution?

A. Azure Blob storage
B. Azure Files
C. Azure Table storage
D. Azure Cosmos DB

Cosmos

Stores data without a fixed schema

Yes, No, Yes

Which format was used?

CSV

database administrator

database administrator

What is required to provision Azure Data Lake Storage in an Azure Storage account?

A. Versioning must be disabled.
B. Hierarchical namespace must be disabled.
C. Versioning must be enabled.
D. Hierarchical namespace must be enabled.

Hierarchical namespace must be enabled

relational data

Virtual Machines

report

1) ETL, 2) ELT, 3) Data ingestion

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

A. YAML
B. KQL
C. SQL
D. XML

SQL

elastic pool

semi-structured data

In a fully normalized database, how is data read and written for a single entity?

A. Data is read from multiple tables and written to multiple tables.
B. Data is read from a single table and written to a single table.
C. Data is read from a single table and written to multiple tables.
D. Data is read from multiple tables and written to a single table.

What is a primary characteristic of a relational database?

A. a flexible data structure
B. data is queried and manipulated by using a variant of the SQL language
C. a lack of dependencies between tables
D. a large amount of duplicate data

SQL

WHERE

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

A. GRANT
B. INSERT
C. REVOKE
D. DROP

INSERT

What is a characteristic of a non-relational database?

A. full support for Transact-SQL
B. a fixed schema
C. self-describing entities

self-describing entities

What should you use to automatically delete blobs from Azure Blob Storage?

A. archive storage
B. the change feed
C. soft delete
D. a lifecycle management policy

life cycle management

In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. a partition key
B. a range
C. a row key
D. a timestamp

a partition key and a row key

data analyst

You need to store event log data that is semi-structured and received as the logs occur.
What should you use?

A. Azure Table storage
B. Azure Queue storage
C. Azure Files

Azure Files

Which Azure Cosmos DB API should you use for a graph database?

A. Table
B. Cassandra
C. Core (SQL)
D. Gremlin

Gremlin

Yes, No, No

elastic pool

A bank has a system that manages financial transactions.
When transferring money between accounts. the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.
Of which ACID semantic is this an example?

A. atomicity
B. durability
C. consistency
D. isolation

isolation

1) ETL 2) Fact tables, 3) DW

account

A data engineer is responsible for which task?

A. Explore data to identify trends.
B. Implement policies, tools, and processes for backup and recovery plans.
C. Design and build analytical models.
D. Design and implement data stores for analytical workloads.

D - design and implement data stores

across compute nodes

cube

Scatter charts

stored procedure

Which file format has defined names and data types for each column and uses compressed columnar storage?

A. HTML
B. CSV
C. Apache Parquet
D. JSON

Apache Parquet

transactional writes

Yes, No, Yes

Which type of database can be used for semi-structured data that will be processed by an Apache Spark pool in Azure Synapse Analytics?

column-family

Which two attributes are characteristics of an analytical data workload?

highly normalized
optimized for read operations
highly denormalized

optimized for read operations, highly denormalized

Which type of data workload is optimized for updates and relies on relationships between entities to correlate data?

transactional

Which two types of applications are used in transactional systems?

line-of-business applications and live applications

Which job role is responsible for designing database solutions, creating databases, and developing stored procedures?

data engineer

Which two keys are needed to create a one-to-many relationship between two tables in a relational database?

foreign key and primary key

What are two advantages of using normalization over not using normalization in a relational database

optimizes for updates and uses less storage space

Which data service provides a fully managed database with close to 100 percent feature parity with Microsoft SQL Server?

Azure SQL Managed Instance

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

SQL Server on an Azure Virtual Machines running Windows

Which data service allows you to migrate an entire Microsoft SQL server to the cloud without requiring that you manage the infrastructure after the migration?

Azure SQL Managed Instance

Which data service allows you to control the amount of RAM, change the I/O subsystem configuration, and add or remove CPUs?

SQL Server on Azure Virtual Machines

Which data service allows you to control the amount of RAM, change the I/O subsystem configuration, and add or remove CPUs?

SQL Server on Azure Virtual Machines

Which open-source database has built-in support for temporal data?

MariaDB

Which type of Azure Storage is the least expensive option that allows you to store and edit image files?

block blobs in the Archive tier

Which type of Azure Storage is used for VHDs and is optimized for random read and write operations?

page blobs

Which type of Azure Storage is used to store large amounts of files to be shared with virtual machines by using SMB?

Azure Files

You need to process many JSON files every minute, while keeping the data from the files accessible by using native queries.

Which Azure Cosmos DB API should you use?

SQL

Which Azure Cosmos DB API is queried by using a syntax based on SQL?

Apache Cassandra

What should you use to process large amounts of data by using Apache Hadoop?

Azure HDInsight

Which two services allow you to pre-process a large volume of data by using Scala? Each correct answer presents a complete solution.

Azure Databricks and a serverless Apache Spark pool in Azure Synapse Analytics

You are processing data by using batches and streams.

What should you use to ensure that transactional consistency is enforced during the processing?

Azure Delta Lake

What should you use to define an analytical model for Microsoft Power BI?

Power BI Desktop

Which visual in Microsoft Power BI allows you to view trends, such as changes in sales over time?

a scatter plot

In the Power BI service, what should you create to share a single page with the most important visuals from reports?

a dashboard

Which type of database should you use to store sequential data in the fastest way possible?

time series

You design an application that needs to store data based on the following requirements:

Store historical data from multiple data sources
Load data on a scheduled basis
Use a denormalized star or snowflake schema

OLAP

Which two DML statements are used to modify the existing data in a table? UPDATE, SELECT, MERGE, INSERT

UPDATE and MERGE

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

SQL Server on an Azure Virtual Machine running Windows

Which type of Azure Storage is used to store large amounts of files to be shared with virtual machines by using SMB?

Azure Files

Which storage solution should you use to store unstructured documents, graph databases, and key/value pairs?

Cosmos

Which Azure Cosmos DB API should you use for data in the BSON format?

Mongo DB

Which service 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 Database

Which data service provides a fully managed database with close to 100 percent feature parity with Microsoft SQL Server?

Azure SQL Managed Instance

Which Azure Blob storage access tier should you use for data that will be used once per year and can have an access time that takes more than an hour?

Brainscape's Knowledge GenomeTM

DP-900 Flashcards

Brainscape's Knowledge Genome^TM