Which scenario is an example of a streaming workload?

sending telemetry data from edge devices

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

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

Online Transaction Processing (OLTP)

massively parallel processing (MPP)

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?

Scale down the data warehouse units (DWUs).

Create a user-defined restore point.

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?

Online Analytical Processing (OLAP)

Online Transaction Processing (OLTP)

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

heavy writes and moderate reads

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.

data acquisition and preparation

report sharing and distribution

data acquisition and preparation

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)

Online Analytical Processing (OLAP)

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

Microsoft SQL Server Integration Services (SSIS)

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

Data is processed as it is created

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.

in-database machine learning services

complete control over backup and restore processes

in-database machine learning services

reduced administrative effort for managing the server infrastructure

When you create an Azure SQL database, which account can always connect to the database?

the server admin login account of the logical server

the Azure Active Directory (Azure AD) account that created the database

the server admin login account of the logical server

the Azure Active Directory (Azure AD) administrator account

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

provides resiliency if an Azure region fails

provides a higher storage capacity

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

Represent trends and patterns over time

Communicate the significance of data

Represent trends and patterns over time

Implement machine learning to predict future values

Communicate the significance of data

Consistently implement business logic across reports

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?

Microsoft SQL Server Management Studio (SSMS)

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

heavy writes and moderate reads

schema defined when reading unstructured data from a database

What is the primary purpose of a data warehouse?

to provide read-only storage of relational and non-relational historical data

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

Microsoft DP-900 Practice Test 5 - Free Online Exam Prep & Questions

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

Comment (0)

Microsoft DP-900 Practice Test 5

Question

Microsoft DP-900 Practice Tests

Practice Tests