GitHub - Ditectrev/DP-900

A Microsoft Power BI [...] enables users to create highly formatted, fixed-layout documents archiving.

dashboard.
interactive report.
paginated report.
subscription.

Platform as a service (PaaS) database offerings in Azure provide built-in high availability.

Yes.
No.

Platform as a service (PaaS) database offerings in Azure provite configuration scaling options.

Yes.
No.

Platform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware.

Yes.
No.

Which scenario is an example of a streaming workload?

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

Stream processing has access to the most recent data received or data within a rolling time window.

Yes.
No.

Batch processing must occur immediately and have latency in the order of second or milliseconds.

Yes.
No.

Stream processing in used for simple response functions, aggregates, or calculations such as rolling averages.

Yes.
no.

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?

Azure Cosmos D3.
Azure Synapse Analytics.
Azure HCMmtghi.
Azure SQL Database.

Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems.

Yes.
No.

Extract, load, and transform (ELT) transforms data by using a compute resource independent of the source system and destination system.

Yes.
No.

Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems.

Yes.
No.

A visualization that shows a university's current student enrollment versus the maximum capacity is an example of [...] analytics.

cognitive.
descriptive.
predictive.
prescriptive.

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

Azure FilesB.
Azure Blob storageC.
Azure Table storageD.
Azure Cosmos DB.

Batch processing can output data to a file store.

Yes.
No.

Batch processing can output data to a relational database.

Yes.
No.

Batch processing can output data to a NoSQL database.

Yes.
No.

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Native support for cross-database queries and transactions.
Built-in high availability.
System-Initiated automatic backups.
Support for encryption at rest.

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense. What should the developers use?

Azure Data Studio.
Sq1cmdC.
Microsoft SQL Server Management Studio (SSMS).
Azure Data Explorer.

Batch workloads [...].

process data in memory, row-by-row.
collect and process data at most once a day.
process data as new data is received in near real-time.
collect data and then process the data when a condition is met.

A block of code that runs In a database Is callea [...].

a stored procedure.
a table.
a view.
an index.

Match the types of activities to the appropriate Azure Data Factory activities.

Copy: Data movement. Mapping data flow: Data transformation. Until: Control.
Copy: Data transformation. Mapping data flow: Data movement. Until: Control.
Copy: Data movement. Mapping data flow: Control. Until: Data transformation.
Copy: Data transformation. Mapping data flow: Control. Until: Data movement.

You have the following SQL query. INSERT INTO dbo. Products (ProductID, ProductName, Price, ProductDescription) Values (1,'Calmp',12.48,'workbench clamp');

Dbo. Products: A table. ProductName: A column.
Dbo. Products: A table. ProductName: An index.
Dbo. Products: An index. ProductName: A database.
Dbo. Products: A database. ProductName: A table.

Relational data is stored in [...].

A file system as unstructured data.
A hierarchal folder structure.
A tabular form of rows and columns.
Comma-separated value (CSV) files.

A key/value data store is optimized for [...].

Enforcing constraints.
Simple lookups.
Table joins.
Transactions.

You can query a graph database iv in Azure Cosmos DB [...].

As a JSON document by using a SQL-like language.
As a partitioned row store by using Cassandra Query Language (CQL).
As a partitioned row store by using Language-Integrated Query (LINQ).
As nodes and edges by using the Gremlin language.

Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS.

Yes.
No.

Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks.

Yes.
No.

Azure Data Studio can be used to restore a database.

Yes.
No.

Which command should you run?

Az scorage share create.
Az scorage account creace.
Az cosmosdb creace.
Az scorage concainer creace.

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.

Container.
Item.
Catabase.
Partition.

You need to create a visualization of running sales totals per quarter as shown in the following exhibit. What should you create in Power BI Desktop?

A waterfall chart.
A waterfall chart.
A bar chart.
A decomposition tree.

Physically sorts the data in a table based on the values in specified column [...].

A view.
A clustered index.
A stored procedure.
A nonclustered index.

In an object associated with a table that sorts and stores the data rows in the table based on their ket values [...].

A clustered index.
A FileTable.
A foreing key.
A stored procedure.

A job that processes sales data once daily in na example of a batch workload.

Yes.
No.

A job that calculates a rolling average temperature readling in an example of a streaming workload.

Yes.
No.

A job that calculates average revenue per product for the last month in an example pf a streaming workload.

Yes.
No.

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

Online Transaction Processing (OLTP)
Batch processing.
Online Analytical Processing (OLAP).
Stream processing.

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

Key/value.
Graph.
Documentd.
Columnar.

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?

Archive.
Hot.
Cool.

To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation [...].

Enable the hierarchical namespace.
Set Account kind to BlobStorage.
Set Performance to Premium.
Set Replication to Read-access geo-redundant storage (RA-GRS).

[...] Prevent access to an Azure SQL database from another network.

Authentication.
Firewall.
Encryption.

[...] Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database.

Authentication.
Firewall.
Encryption.

[...] Ensure that sensitive data never appears as plain text in an Azure SQL database.

Authentication.
Firewall.
Encryption.

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

You.
No.

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

Yes
No.

You can use MySQL Workbench to query Azure Database for MariaDB databases.

Yes.
No.

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

changes to realtionships between entites.
geographically distributed writes.
transactional writes.
writes that have varying data structures.

The Azure Cosmos DB API in configured separately for each database in an Azure Cosmos DB account.

Yes.
No.

Partition keys are used in Azure Cosmos DB to opyimize queries.

Yes.
No.

Items contained in the same Azure Cosmos DB logical partition can different partition keys.

Yes.
No.

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

Online Transaction Processing (OLTP).
Batch.
Massively parallel processing (MPP).
Streaming.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

INSERT.
MERGE.
UPDATE.
CREATE.

Match the types of data stores to the appropriate scenarios. [...] Application users and their and default language.

Graph.
Object.
Key/value.

Match the types of data stores to the appropriate scenarios. [...] Medical images and their associated metadata.

Graph.
Object.
Key/value.

Match the types of data stores to the appropriate scenarios. [...] Employee data that shows the realtionships between employees.

Graph.
Object.
Key/value.

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?

Document.
Columnar.
Graph.
Time series.

Azure Table storage supports multiple read replicas.

Yes.
No.

Azure Table storage supports multiple write regions.

Yes.
No.

The Azure Cosmos DB Table API supports multiple read replicas.

Yes.
No.

The Azure Cosmos DB Table API supports multiple write regions.

Yes.
No.

Match the types of workloads the appropriate scenario. [...] Data for a product catalog vail be loaded every 12 hours to a data warehouse.

Batch.
Micro-batch
Streaming.
Workload Type.

Match the types of workloads the appropriate scenario. [...] Data for online purchases will be loaded to a Gata warehouse as the purchases occur.

Batch.
Micro-batch
Streaming.
Workload Type.

Match the types of workloads the appropriate scenario. Updates to inventory data will be loaded to adata warehouse every 1,000 transactions.

Batch.
Micro-batch
Streaming.
Workload Type.

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

Azure HDInsight.
Azure SQL Database.
Azure Cosmos DB.
SQL Server on Azure virtual machines.

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Azure SQL Database Hyperscale.
Azure SQL managed instance.
Azure SQL Database serveless.
Azure SQL Database elastic pod.

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

Control flow.
Linked services.
Datasets.
The integration runtime.

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?

Microsoft SQL Server Management Studio (SSMS).
Azure Data Studio.
Azure CLID.
Azure PowerShell.

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. (Choose three.)

What are two uses of data visualization?

Represent trends and patterns over time.
Communicate the significance of data.
Implement machine learning to predict future values.
Consistently implement business logic across reports.

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

Predictive.
Prescription.
Descriptive.
Diagnostic

Which three actions are used when performing diagnostic analytics?

Identify data anomalies. Collect anomaly-related data. Discover relationships and trends that explain anomalies.
Identify data anomalies. Predict when anomalies are likely to recur. Use analytical tools such as decision trees and regression.
Apply serf-learning loops to draw inferences from anomalies. Predict when anomalies are likely to recur. Use analytical tools such as decision trees and regression.
Identify data anomalies. Use machine learning to find patterns in large datasets. Discover relationships and trends that explain anomalies.

Platform as a service (PaaS) database offerings in Azure require less seup and configuration effort than infrastructure as a service (IaaS) database offering [...].

Yes.
No.

Platform as a service (PaaS) database offerings in Azure provide administrators with the ability to control adn update the operating system version [...].

Yes.
No.

All platform as a service (PaaS) database offerings in Azure can be paused to reduce version [...].

Yes.
No.

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?

Synapse pipelines.
A Synapse SQL pool.
Synapse Link.
Synapse Studio.

Select the answer that correctly completes the sentence. A [...] in a chcat of colored rectangles. The size of the rectangles represent the relative value of each item. The chart can be hierarchical, displaying data as a set of rectangles nest within the main rectangle.

line chart.
matrix.
scatter.
treemap.

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?

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

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Complete control over backup and restore processes.
Access to the latest features.
In-database machine learning services.
Reduced administrative effort for managing the server infrastructure.

Which statement is an example of Data Definition Language (DDL)?

SELECT.
INSERT.
DELETE.
DROP.

Azure Databricks is an Apache Spark-based collaborative analytics platform.

Yes.
No.

Azure Analysis Services is used for transactional workloads.

Yes.
No.

Azure Data Factory orchestrates data integration workflows.

Yes.
No.

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

REVOKE.
DISABLE.
CREATE.
UPDATE.

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

Azure Queue storage.
Azure Data Lake Storage.
Azure table storage.
Azure Files.

What is a possible cause of the issue?

A database-level firewall.
role-based access control (RSAC).
Dynamic Host Configuration Protocol (DHCP).
Domain Name Service (DNS).

Which setting can only be configured during the creation of an Azure Cosmos DB account?

Geo-redundancy.
Multi-region writes.
Production or non-reduction account type.
API.

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

Azure Cosmos DB.
Azure Table storage.
Azure Files.
Azure Blob Storage.

[...] is a virtual table that contains content definey by a querty.

A heap.
A stored procedure.
A view.
An index.

What is the primary purpose of a data warehouse?

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

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

Azure Data Lake Storage.
Azure Cosmos DB.
Azure Queue storage.
Azure Blob storage.

Azure SQL managed instance supports cross-database queries.

Yes.
No.

Azure SQL managed instance supports user-created backups.

Yes.
No.

Azure SQL managed instance databases can be restored to SQL Server on a Azure virtual machine.

Yes.
No.

A representation of data structures within data stores.

The information used to connect to external resources.

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

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

A linked service.
An integration runtime.
A control flow
A pipeline

Application users and their default language.

Graph.
Object.
Key/value.

Medical images and their associated metadata.

Graph.
Object.
Key/value.

Employee data that shows the relationship between employees.

Graph.
Object.
Key/value.

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

Azure Files.
Azure Blob storage.
Azure Cosmos DB.
Azure Table storage.

Cognitive Diagnostic Diagnostic Predictive Descriptive Cognitive Predictive

Prescriptive

Why did sales increase last month?

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

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

Preprocess & model

Logs, structured

data, and other data Azur ‘Azure Data Microsoft

snictaes Lake Storage Power Bl

","

Statements Yes You must apply patches to Azure SQL databases regularly. O

You need a Microsoft 365 subscription to create an Azure O SQL database.

You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases. ie)

","

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. (Choose three.)A . ","

A . denormalized dataB . ","
B . heavy writes and moderate readsC . ","
C . light writes and heavy readsD . ","
D . schema on writeE . schema on readF . normalized data","
E . schema on readF . normalized data","
F . normalized data","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "

Which three actions are used when performing diagnostic analytics?A . ","

If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates.

If you have a platform as a service (PaaS) database in Azure, backups are performed automatically.

If you have a platform as a service (PaaS) database in Azure, you are responsible for upgrading the database engine.

Yes

No

","

Descriptive

ening?

Diagnostic

bx

==

Predictive Prescriptive

‘ake?

What actions sho

","

PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Statements You can copy a dashboard between Microsoft Power BI workspaces. A Microsoft Power BI dashboard can only display visualizations from a single dataset.

A Microsoft Power BY dashboard can display visualizations from a Microsoft Excel workbook

Yes fe) [e)

||

No ro}

","

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 . ","

What should you use?A . ","

A . Microsoft SQL Server Management Studio (SSMS)B . ","
B . Azure Data StudioC . ","
C . Azure CLID . ","
D . Azure PowerShell","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "ProductName | Quantity

Productl 100 Product2 129

Product3 | 176

","

Which statement is an example of Data Definition Language (DDL)?A . ","

You can query a graph database Iv

in Azure Cosmos DB | as a JSON document by using a SQL-like language.

as a partitioned row store by using Cassandra Query Language (CQL). as a partitioned row store by using Language-Integrated Query (LINQ). as nodes and edges by using the Gremlin language.

","

At which level in Azure Cosmos DB can you configure multiple write regions and read regions?A . ","

Azure Cosmos DB

Extract Transform Load (ETL)

Azure Data

Data warehouse

","

Which statement is an example of Data Manipulation Language (DML)?A . ","

Which storage solution supports role-based access control (RBAC) at the file and folder level?A . ","

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

A . Represent trends and patterns over time.B . ","
B . Communicate the significance of data.C . ","
C . implement machine learning to predict future values.D . ","
D . Consistently implement business logic across reports","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Answer Area

You can query a graph database Iv

in Azure Cosmos DB | as a JSON document by using a SQL-like language.

as a partitioned row store by using Cassandra Query Language (CQL). as a partitioned row store by using Language-Integrated Query (LINQ). as nodes and edges by using the Gremlin language.

","

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?A . ","

A . Azure SQL Database HyperscaleB . ","
B . Azure SQL managed instanceC . ","
C . Azure SQL Database servelessD . ","
D . Azure SQL Database elastic pod","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "APIs

Answer Area

Cassandra API

Gremlin API

MongoDB API

Table API

MongoDB API

Graph data JSON documents Key/value data

","

Which three actions are used when performing diagnostic analytics?A . ","

What should you use in Microsoft Power BI?A . ","

The massively parallel processing (MPP) engine of Azure

Synapse Analytics lv distributes processing across compute nodes. distributes processing across control nodes. redirects client connections across compute nodes. redirects client connections across control nodes.

","

An extract, transform, and load (ETL) process requires lv

a matching schema in the data source and the data target.

a target data store powerful enough to transform data.

data that is fully processed before being loaded to the target data store. that the data target be a relational database.

","

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?A . ","

Dbo. Products: 4

A column A database A table

An index

ProductName: lv

Acolumn A database A table An index

","

Which storage tier should you use?A . ","

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. (Choose two.)A . ","

Which type of Azure Storage should you use?A . ","

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

A . multi-master replicationB . ","
B . Availability ZonesC . ","
C . automatic failoverD . ","
D . the strong consistency level","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "An extract, load, and transform (ELT) process requires |» data pipeline that includes a transformation engine,

","

Which type of processing does the application use?A . ","

A . Online Transaction Processing (OLTP)B . ","
B . batch processingC . ","
C . Online Analytical Processing (OLAP)D . ","
D . stream processing","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Activity Types Answer Area

Control Data movement Copy

Data movement Data transformation | Mapping data flow

Data transformation Control Until

","

PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Statements Pg The Azure Cosmos DB API Is configured separately for each database in an Azure Cosmos Fos DB account. Partition keys are used in Azure Cosmos DB to optimize queries. ° Items contained in the same Azure Cosmos DB logical partition can have different partition °

‘keys.

™m

to!

","

Which clause should you use in a select statement to combine rows in one table with rows in another table?A . ","

What should you use to build a Microsoft Power BI paginated report?A . ","

Statements Yes

Platform as a service (PaaS) database offerings in Azure

provide built-in high availability. © Platform as a service (PaaS) database offerings in Azure (e) provide configurable scaling options.

Platform as a service (PaaS) database offerings in Azure fe)

reduce the administrative overhead for managing hardware.

","

Which statement should you use?A . ","

T

Transparent Data iv

Encryption (TDE) encrypts | a column to protect data at rest and in transit.

queries and their results in order to protect data in transit. the database to protect data at rest.

the server to protect data at rest.

","

Transcribing audio files is an example of cognitive

descriptive predictive prescriptive

","

Which type of data store will provide the lowest latency to retrieve the data?A . ","

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

What should the developers use?A . ","

Which type of data store should you recommend?A . ","

Which storage solution supports role-based access control (RBAC) at the file and folder level?A . ","

Answer Area

Cassandra API

Gremlin API

MongoDB API

Table API

Graph data JSON documents Key/value data

","

You can query a graph database

\v in Azure Cosmos DB

as a JSON document by using a SQL-like language.

as a partitioned row store by using Cassandra Query Language (CQL). as a partitioned row store by using Language-Integrated Query (LINQ). as nodes and edges by using the Gremlin language.

","

PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "‘Answer Azure Analysis ‘Services Extract Transform Load (ETL) Synepee ‘Azure Data Azure’ ap | Analytics Auure

Cosmos DB

","

Which Azure service should you use?A . ","

A . Azure Cosmos DBB . ","
B . Azure Table storageC . ","
C . Azure FilesD . ","
D . Azure Blob Storage","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Statements Yes No You can copy a dashboard between Microsoft Power BI workspaces. O° [o) A Microsoft Power BI dashboard can only display visualizations from a single dataset. O Ke) A Microsoft Power BY dashboard can display visualizations from a Microsoft Excel | fe) | fe}

workbook

","

Which type of data store should you recommend?A . ","

Graph Key/value Object Object Key/value Graph

Application users and their default language Medical images and their associated metadata

Employee data that shows the relationships between employees

","

Which three actions are used when performing diagnostic analytics?A . ","

Which setting can only be configured during the creation of an Azure Cosmos DB account?A . ","

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

What should you use in Microsoft Power BI?A . ","

Transparent Data lv

Encryption (TDE) encrypts | a column to protect data at rest and in transit.

queries and their results in order to protect data in transit. the database to protect data at rest.

the server to protect data at rest.

","

Which statement is an example of Data Definition Language (DDL)?A . ","

What should the developers use?A . ","

Dbo. Products:

ProductName:

\v

Acolumn A database A table An index

lv Acolumn A database A table An index

","

Which type of data store should you use?A . ","

Which three actions are used when performing diagnostic analytics?A . ","

Which type of data store should you use?A . ","

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

Which storage tier should you use?A . ","

|w is a virtual table that contains content defined by a query

A heap

A stored procedure Aview

An index

","

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

A . Represent trends and patterns over time.B . ","
B . Communicate the significance of data.C . ","
C . implement machine learning to predict future values.D . ","
D . Consistently implement business logic across reports","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "

Which Azure Data Factory component provides the compute environment for activities?A . ","

You can query a graph database

\v in Azure Cosmos DB

as a JSON document by using a SQL-like language.

as a partitioned row store by using Cassandra Query Language (CQL). as a partitioned row store by using Language-Integrated Query (LINQ). as nodes and edges by using the Gremlin language.

","

Cognitive | | Diagnostic | Diagnostic Predictive Descriptive Cognitive Predictive Prescriptive

Why did sales increase last month? How do I allocate my budget to buy different inventory items?

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

","

Which type of Azure Storage should you use?A . ","

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

At which level in Azure Cosmos DB can you configure multiple write regions and read regions?A . ","

If you have a platform as a service (PaaS) database in Azure,

you are responsible for applying operating system updates.

If you have a platform as a service (PaaS) database in Azure,

backups are performed automatically.

If you have a platform as a service (PaaS) database in Azure,

you are responsible for upgrading the database engine.

Yes

No

","

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?A . ","

","

What is the primary purpose of a data warehouse?A . ","

A . to provide answers to complex queries that rely on data from multiple sourcesB . ","
B . to provide transformation services between source and target data storesC . ","
C . to provide read-only storage of relational and non-relational historical dataD . ","
D . to provide storage for transactional line-of-business (LOB) applications","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Answer Area Statements

Platform as a service (PaaS) database offerings in Azure provide built-in high availability.

Platform as a service (PaaS) database offerings in Azure provide configurable scaling options.

Platform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware.

Yes

No

","

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

ion oer

=

reste

Answer Area | Dataset

|i

i a

| A representation of data structures within data stores

‘The information used to connect to extemal resources

A logical grouping of activites that performs 2 unit of work and can be scheduled

","

An extract, transform, and load (ETL) process

requires

a matching schema in the data source and the data target.

a target data store powerful enough to transform data.

data that is fully processed before being loaded to the target data store. that the data target be a relational database.

","

Which statement is an example of Data Manipulation Language (DML)?A . ","

","

The massively parallel processing (MPP) engine of Azure

Synapse Analytics

distributes processing across compute nodes. distributes processing across control nodes. redirects client connections across compute nodes. redirects client connections across control nodes.

","

Transcribing audio files is an example of

fw analytics.

cognitive descriptive predictive prescriptive

","

Which type of data store will provide the lowest latency to retrieve the data?A . ","

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. (Choose two.)A . ","

Control Data movement Copy

Data movement Data transformation | Mapping data flow

Data transformation Control Until

","

What is a possible cause of the issue?A . ","

A . a database-level firewallB . ","
B . role-based access control (RSAC)C . ","
C . Dynamic Host Configuration Protocol (DHCP)D . ","
D . Domain Name Service (DNS)","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "

Which clause should you use in a select statement to combine rows in one table with rows in another table?A . ","

Descriptive

bx

Diagnostic Predictive _ Prescriptive

{O

","

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 . ","

A . containerB . ","
B . itemC . ","
C . databaseD . ","
D . partition","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Statements Yes ‘Azure SQL managed instance supports cross-database queries,

Azure SQL managed instance supports user-created backups. °

b] Azure SQL managed instance databases can be restored to SQL Server on an Azure virtua To!

machine.

o tol o ‘Oo.

","

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. (Choose three.)A . ","

A . denormalized dataB . ","
B . heavy writes and moderate readsC . ","
C . light writes and heavy readsD . ","
D . schema on writeE . schema on readF . normalized data","
E . schema on readF . normalized data","
F . normalized data","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Answer Area

Statements Yes No Azure Table storage supports multiple read replicas. [e) () Azure Table storage supports multiple write regions. a [e) The Azure Cosmos DB Table API supports multiple read replicas. (© fe) The Azure Cosmos DB Table API supports multiple write regions. © Oo

","

Statements

When ingesting data from Azure Data Lake Storage across Azure regions, you will incur costs for bandwidth.

You can use blob, table, and file storage in the same Azure Storage account.

You implement Azure Data Lake Storage by creating an Azure Storage account.

Yes

(e)

[e)

No

","

The data model is a [answer choice]. lv

transactional model star schema snowflake schema

Customer is a [answer choice] table. lv

fact dimension bridge

","

What is a possible cause of the issue?A . ","

A . a database-level firewallB . ","
B . role-based access control (RSAC)C . ","
C . Dynamic Host Configuration Protocol (DHCP)D . ","
D . Domain Name Service (DNS)","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "

What should you use?A . ","

Which storage tier should you use?A . ","

A pipeline is a representation of a data structure within Azure Data Factory

Azure Data Factory pipelines can execute other pipelines

A processing step within an Azure Data Factory pipeline is an activity

Yes

No

","

foved-layout documents q

‘enables users to create highly formatted hiving.

","

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

A . descriptiveB . ","
B . diagnosticC . ","
C . predictiveD . ","
D . prescriptive","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "A visualization that shows a university s current student enrollment

versus the maximum capacity is an example of

v analytics.

cognitive descriptive predictive prescriptive

","

PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Statements. ‘Azure Databricks can consume data from Azure SQ Databate.

Azure Databricks can consume data from Azure Event Hubs.

‘Azure Databricks can consume data from Azure Cosmos DB.

Yes

","

Which Azure Data Factory component initiates the execution of a pipeline?A . ","

What should you use in Microsoft Power BI?A . ","

Which Azure service should you use?A . ","

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 . ","

Relational database tables contain columns and rows Indexes in a relational database describe the data types in a table

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

Yes [e) {e)

e)

No

","

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.) NOTE: Each correct selection is worth one point.A . ","

A . You must be assigned the Reader role for the resource group that contains the database.B . ","
B . You must have SELECT access to the Products table.C . ","
C . You must have a user in the database.D . ","
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.","
E . Your IP address must be allowed to connect to the database.","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Data for a product catalog will be loaded ‘every 12 hours to a data warehouse.

~ | Data for online purchases will be loaded to a Gata warehouse as the purchases occur.

= Updates to inventory data will be loaded to a ata warehouse every 1,000 transactions.

","

Which Azure service should you use?A . ","

Relational data is stored in [fae pyuema vaativciored aaa, [ [a tierarchal folder strocture.

","

PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Statements Azure Data Studio can be used to query an Arure SQL database from a device that runs macs.

Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL

‘Azure Data Studio can be used to restore a database.

Yes °

°

io® a te

of yol

r. aoe

°

","

When can you use an Azure Resource Manager template?A . ","

A . to automate the creation of an interdependent group of Azure resources in a repeatable wayB . ","
B . to automate the creation of an interdependent and develop can deploy from the Azure portalC . ","
C . To provision Azure subscriptions and apply policies for multi-tenant deploymentsD . ","
D . To set complex permissions automatically on existing objects in an Azure subscription","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Answer Area

You can query a graph database

\v in Azure Cosmos DB

as a JSON document by using a SQL-like language.

as a partitioned row store by using Cassandra Query Language (CQL). as a partitioned row store by using Language-Integrated Query (LINQ). as nodes and edges by using the Gremlin language.

","

An extract, transform, and load (ETL) process

requires

a matching schema in the data source and the data target.

a target data store powerful enough to transform data.

data that is fully processed before being loaded to the target data store. that the data target be a relational database.

","

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

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.A . ","

A . report and dashboard creationB . ","
B . report sharing and distributionC . ","
C . data modelingD . ","
D . data acquisition and preparation","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Activity Types Answer Area

Control Data movement Copy

Data movement Data transformation | Mapping data flow

Data transformation Control Until

","

What should the developers use?A . ","

Statements A pipeline is a representation of a data structure within Azure Data Factory.

Azure Data Factory pipelines can execute other pipelines,

A processing step within an Azure Data Factory pipeline is an activity,

","

Which type of processing does the application use?A . ","

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

When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a lv

graph.

table. partition key. document.

","

Extract

arget

Transformation engine

Data source 2

","

Statements

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

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

You can use MySQL Workbench to query Azure Database for MariaDB databases.

Yes

°

[e)

fe)

No

","

Which type of data store should you recommend?A . ","

What should you create?A . ","

A . a tableB . ","
B . an indexC . ","
C . scalar functionD . ","
D . a view","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME","
PLEASE_DELETE_ME" "Statements Yes ‘Azure SQL managed instance supports cross-database queries,

Azure SQL managed instance supports user-created backups. °

b] Azure SQL managed instance databases can be restored to SQL Server on an Azure virtua To!

machine.

o tol o ‘Oo.

","

Which type of data store should you use?A . ","

Which type of workload describes this scenario?A . ","

In Azure Data Factory, you can use |v. to orchestrate pipeline

acontrol flow

a dataset

a linked service

an integration runtime

activities that depend on the output of other pipeline activities.

","

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
images		images
.gitignore		.gitignore
README.md		README.md

Ditectrev/DP-900

Folders and files

Latest commit

History

Repository files navigation

A Microsoft Power BI [...] enables users to create highly formatted, fixed-layout documents archiving.

Platform as a service (PaaS) database offerings in Azure provide built-in high availability.

Platform as a service (PaaS) database offerings in Azure provite configuration scaling options.

Platform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware.

Which scenario is an example of a streaming workload?

Stream processing has access to the most recent data received or data within a rolling time window.

Batch processing must occur immediately and have latency in the order of second or milliseconds.

Stream processing in used for simple response functions, aggregates, or calculations such as rolling averages.

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?

Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems.

Extract, load, and transform (ELT) transforms data by using a compute resource independent of the source system and destination system.

Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems.

A visualization that shows a university's current student enrollment versus the maximum capacity is an example of [...] analytics.

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

Batch processing can output data to a file store.

Batch processing can output data to a relational database.

Batch processing can output data to a NoSQL database.

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense. What should the developers use?

Batch workloads [...].

A block of code that runs In a database Is callea [...].

Match the types of activities to the appropriate Azure Data Factory activities.

You have the following SQL query. INSERT INTO dbo. Products (ProductID, ProductName, Price, ProductDescription) Values (1,'Calmp',12.48,'workbench clamp');

Relational data is stored in [...].

A key/value data store is optimized for [...].

You can query a graph database iv in Azure Cosmos DB [...].

Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS.

Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks.

Azure Data Studio can be used to restore a database.

Which command should you run?

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.

You need to create a visualization of running sales totals per quarter as shown in the following exhibit. What should you create in Power BI Desktop?

Physically sorts the data in a table based on the values in specified column [...].

In an object associated with a table that sorts and stores the data rows in the table based on their ket values [...].

A job that processes sales data once daily in na example of a batch workload.

A job that calculates a rolling average temperature readling in an example of a streaming workload.

A job that calculates average revenue per product for the last month in an example pf a streaming workload.

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

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

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?

To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation [...].

[...] Prevent access to an Azure SQL database from another network.

[...] Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database.

[...] Ensure that sensitive data never appears as plain text in an Azure SQL database.

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

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

You can use MySQL Workbench to query Azure Database for MariaDB databases.

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

The Azure Cosmos DB API in configured separately for each database in an Azure Cosmos DB account.

Partition keys are used in Azure Cosmos DB to opyimize queries.

Items contained in the same Azure Cosmos DB logical partition can different partition keys.

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

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

Match the types of data stores to the appropriate scenarios. [...] Application users and their and default language.

Match the types of data stores to the appropriate scenarios. [...] Medical images and their associated metadata.

Match the types of data stores to the appropriate scenarios. [...] Employee data that shows the realtionships between employees.

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?

Azure Table storage supports multiple read replicas.

Azure Table storage supports multiple write regions.

The Azure Cosmos DB Table API supports multiple read replicas.

The Azure Cosmos DB Table API supports multiple write regions.

Match the types of workloads the appropriate scenario. [...] Data for a product catalog vail be loaded every 12 hours to a data warehouse.

Match the types of workloads the appropriate scenario. [...] Data for online purchases will be loaded to a Gata warehouse as the purchases occur.

Match the types of workloads the appropriate scenario. Updates to inventory data will be loaded to adata warehouse every 1,000 transactions.

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

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

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?

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. (Choose three.)

What are two uses of data visualization?

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

Which three actions are used when performing diagnostic analytics?

Platform as a service (PaaS) database offerings in Azure require less seup and configuration effort than infrastructure as a service (IaaS) database offering [...].

Platform as a service (PaaS) database offerings in Azure provide administrators with the ability to control adn update the operating system version [...].

All platform as a service (PaaS) database offerings in Azure can be paused to reduce version [...].