ExamGecko
Home / Microsoft / DP-900 / List of questions
Ask Question

Microsoft DP-900 Practice Test - Questions Answers, Page 21

List of questions

Question 201

Report
Export
Collapse

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

MERGE
MERGE
ALTER
ALTER
INSERT
INSERT
UPDATE
UPDATE
Suggested answer: B
asked 02/10/2024
- Paulo Fonseca
38 questions

Question 202

Report
Export
Collapse

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

Azure Table storage
Azure Table storage
Azure Data Lake Storage
Azure Data Lake Storage
Azure Queue storage
Azure Queue storage
Azure Files
Azure Files
Suggested answer: B

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

asked 02/10/2024
Yusuf Sivrikaya
39 questions

Question 203

Report
Export
Collapse

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

predictive
predictive
prescriptive
prescriptive
descriptive
descriptive
diagnostic
diagnostic
Suggested answer: D
asked 02/10/2024
Joseph Lewis
46 questions

Question 204

Report
Export
Collapse

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

geo-redundancy
geo-redundancy
multi-region writes
multi-region writes
production or non-production account type
production or non-production account type
API
API
Suggested answer: D

Explanation:

You must create a separate account for each API.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account

asked 02/10/2024
Glen Makhuvele
36 questions

Question 205

Report
Export
Collapse

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
Synapse pipelines
a Synapse SQL pool
a Synapse SQL pool
Synapse Link
Synapse Link
Synapse Studio
Synapse Studio
Suggested answer: C

Explanation:

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

asked 02/10/2024
antonio de simone
36 questions

Question 206

Report
Export
Collapse

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

Microsoft DP-900 image Question 66 90581 10022024020006000000

What should you create in Power BI Desktop?

a waterfall chart
a waterfall chart
a ribbon chart
a ribbon chart
a bar chart
a bar chart
a decomposition tree
a decomposition tree
Suggested answer: A

Explanation:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

asked 02/10/2024
Balvant Variya
37 questions

Question 207

Report
Export
Collapse

Which type of database is Azure Database for PostgreSQL?

Platform as a service (PaaS)
Platform as a service (PaaS)
Infrastructure as a service (IaaS)
Infrastructure as a service (IaaS)
Microsoft SQL Server
Microsoft SQL Server
on-premises
on-premises
Suggested answer: A

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options

asked 02/10/2024
wietse Bonnes
37 questions

Question 208

Report
Export
Collapse

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

Azure Data Lake Storage
Azure Data Lake Storage
Azure Queue storage
Azure Queue storage
Azure Blob storage
Azure Blob storage
Azure Cosmos DB
Azure Cosmos DB
Suggested answer: A

Explanation:

Azure Data Lake Storage Gen2 implements an access control model that supports both Azure role-based access control (Azure RBAC) and POSIX-like access control lists (ACLs).

Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

asked 02/10/2024
Saeed Awwad
46 questions

Question 209

Report
Export
Collapse

What is a characteristic of batch processing?

The data ingested during batch processing must be processed as soon as the data is received.
The data ingested during batch processing must be processed as soon as the data is received.
Large datasets must be split into batches of less than 1 GB before the data can be processed.
Large datasets must be split into batches of less than 1 GB before the data can be processed.
There is a noticeable time delay between ingesting data and obtaining the data processing results.
There is a noticeable time delay between ingesting data and obtaining the data processing results.
Batch processing can only process data that is structured.
Batch processing can only process data that is structured.
Suggested answer: C

Explanation:

Box 1: Yes Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record.

Box 2: No

An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view.

Box 3: Yes

A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described

https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15

asked 02/10/2024
SCOTTIE EASTER
40 questions

Question 210

Report
Export
Collapse

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

SET
SET
VALUES
VALUES
KEY
KEY
JOIN
JOIN
Suggested answer: D

Explanation:

Reference:

https://www.tutorialspoint.com/sql/sql-using-joins.htm

asked 02/10/2024
Sze Ying Tay
36 questions
Total 285 questions
Go to page: of 29

Related questions