Microsoft DP-900 Exam Questions Instant Access

Question 1

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?

ASynapse pipelines

Ba Synapse SQL pool

CSynapse Link

DSynapse Studio

Answer : C

https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link

Question 2

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

ASELECT

BINSERT

CDELETE

DDROP

Answer : D

Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:

ALTER

Collations

CREATE

DROP

DISABLE TRIGGER

ENABLE TRIGGER

RENAME

UPDATE STATISTICS

TRUNCATE TABLE

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Question 3

You have a SQL query that combines customer data and order dat

a. 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?

Aa scalar function

Ba table

Can index

Da view

Answer : D

Question 4

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

Abridge

Bdimension

Cfact

Answer : C

Question 5

What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?

Aa few milliseconds

Ba few seconds

Ca few minutes

Da few hours

Answer : A

Question 6

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

Asupports partitioning

Bprovides resiliency if art Azure region fads

Cprovides a higher storage capacity

Dsupports a multi-master model

Answer : D

Multi-master support for Azure Cosmos DB is now available in all public regions.

Azure CosmosDB table API is a key-value storage hosted in the cloud. It's a part of Azure Cosmos DB, that is Microsoft's multi-model database.

https://docs.microsoft.com/en-us/azure/cosmos-db/table-support

Question 7

Which statement accurately describes data processing?

ABatch processing requires that data be processed immediately upon arrival.

BStream processing is typically used for time-critical operations that require an instant response.

CStream processing is typically used for analyzing larger datasets in less time.

DBatch processing is typically used for scenarios that require continuous, real-time insights from rapidly arriving data.

Answer : B

Microsoft Azure Data Fundamentals DP-900 Exam Questions