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

you use?

What is a characteristic of a non-relational database?

A serverless configuration

A database that has the highest compatibility with on-premises Microsoft SQL Server

What is a primary characteristic of a relational database?

Which database transaction property ensures that individual transactions are executed only once and

either succeed in their entirety or roll back?

Which property of a transactional workload guarantees that each transaction is treated as a single

unit that either succeeds completely or fails completely?

Which database transaction property ensures that transactional changes to a database are preserved

during unexpected operating system restarts?

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

Which type of Azure resource supports the serverless configuration of an Azure SQL database?

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

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?

What ate three characteristics of an Online Transaction Processing (OLTP) workload?

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?

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates, backups, and maintenance tasks?

A data engineer is responsible for which task?

In Microsoft Power BI, a .......................................... is a collection of visualizations that appear together on one or more pages.

....................................... is a platform as a service (PaaS) relational data service that uses massively parallel processing (MPP)

Which T-SQL statement should be used to instruct a database management system to use an index

instead of performing a full table scan?

Database backup and recovery

Enabling advanced analytic capabilities through reports

Monitoring data pipelines

In a relational database, the schema is defined before data is written to the table.

Key/value data stores are highly optimized for complex queries that contain multiple joins.

A relational database is commonly used to store and query structured data.

In a graph database, edges specify relationships between ......................

The pipeline engine used in Azure Data Factory is also available in .................................

The Azure Cosmos DB ................................. enables the use of SELECT statements to retrieve documents from Azure Cosmos DB.

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

A Microsoft Power BI ................................ enables users to create highly formatted, fixed-layout documents optimized for printing and archiving.

Batch workloads

An extract, load, and transform (ELT) process requires

Relational data uses to enforce relationships between different tables.

Varying fields for each entity in a JSON document is an example of

A ISON document that contains customer entities with a variable number of properties is an example of ......................

In an analytical model, any point where the dimensions intersect represents ...................

................................ is responsible for finding hidden patterns in data and creating graphical reports that deliver information in a useful and appealing format.

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

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

An extract , load and transform (ELT) process required ....

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

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

Batch processing can output data to a file store

Batch processing can output data to a relational database

What are two uses of data visualization? Each correct answer present a complete solution.

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

Data for online purchases will be loaded to a data warehouse as the purchase occur

Updates to inventory data will be loaded to a data warehouse every 1000 transactions

You have an e-commerce application that reads and writes data to an Azure SQL database. Which

type of processing does the application use?

What are two characteristics of real-time data processing? Each correct answer present a complete

solution.

Which two Azure services can be used to provision Spark clusters? Each correct answer presents a

complete solution.

You need to develop a solution to provide data to executives. the solution must provide an

interactive graphic interface, depict various key performance indications, and support data

exploration by using drill down.

What should you use in Microsoft Power BI?

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

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

Relational data is stored in ........