Microsoft DP-900 Exam Questions Instant Access

Question 1

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

NOTE: Each correct selection is worth one point.

AData is processed as it is created.

BLow latency is expected

CHigh latency acceptable

DData is processed periodically

Answer : A, B

Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses.

https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/real-time-processing

Question 2

What is a characteristic of batch processing?

AThe data ingested during batch processing must be processed as soon as the data is received.

BLarge datasets must be split into batches of less than 1 GB before the data can be processed.

CThere is a noticeable time delay between ingesting data and obtaining the data processing results.

DBatch processing can only process data that is structured.

Answer : C

Question 3

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

Adescriptive

Bdiagnostic

Cpredictive

Dprescriptive

Answer : B

Question 4

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

Athe Azure Active director/ (Azure AO) account that created the database

Bthe Azure Active Directly Azure AD) administrator account

Cthe sa account

Dthe server admin login account of the logical server

Answer : D

When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.

https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Question 5

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?

Aservice principal authentication

BAzure Active Directory (Azure AD) authentication

CSQL authentication

Dcertificate authentication

Answer : B

https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

Question 6

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?

AKey/value

BGraph

CDocument

Dcolumnar

Answer : B

Data as it appears in the real world is naturally connected. Traditional data modeling focuses on defining entities separately and computing their relationships at runtime. While this model has its advantages, highly connected data can be challenging to manage under its constraints.

A graph database approach relies on persisting relationships in the storage layer instead, which leads to highly efficient graph retrieval operations. Azure Cosmos DB's Gremlin API supports the property graph model.

https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction#introduction-to-graph-databases

Question 7

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?

Astream processing

BOnline Transaction Processing (OLTP)

Cbatch processing

DOnline Analytical Processing (OLAP)

Answer : B

https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

Microsoft Azure Data Fundamentals DP-900 Exam Questions