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

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

List of questions

Question 181

Report
Export
Collapse

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

Charticulator
Charticulator
Power BI Desktop
Power BI Desktop
the Power BI service
the Power BI service
Power BI Report Builder
Power BI Report Builder
Suggested answer: D

Explanation:

Section: Describe an analytics workload on Azure

Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.

Reference:

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

asked 02/10/2024
Nqobile Nxumalo
42 questions

Question 182

Report
Export
Collapse

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query.

What should you create?

an index
an index
a view
a view
a scalar function
a scalar function
a table
a table
Suggested answer: B

Explanation:

Section: Describe core data concepts

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.

Reference:

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

asked 02/10/2024
Ibrahim mazou Ismael
45 questions

Question 183

Report
Export
Collapse

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 periodically
Data is processed periodically
Low latency is expected
Low latency is expected
High latency is acceptable
High latency is acceptable
Data is processed as it is created
Data is processed as it is created
Suggested answer: B, D

Explanation:

Section: Describe core data concepts

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.

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

asked 02/10/2024
Larry Severin
38 questions

Question 184

Report
Export
Collapse

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).

Which Azure service should you use to support the application?

Azure Cosmos DB
Azure Cosmos DB
Azure HDInsight
Azure HDInsight
Azure SQL Database
Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
Suggested answer: C

Explanation:

Section: Describe how to work with relational data on Azure

Azure SQL Database is relational database and a managed service.

Incorrect Answers:

A, B: Cosmos DB, HDInsight are non-relational databases.

D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing

Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

asked 02/10/2024
Peter Jennings
34 questions

Question 185

Report
Export
Collapse

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.

access to the latest features
access to the latest features
complete control over backup and restore processes
complete control over backup and restore processes
in-database machine learning services
in-database machine learning services
reduced administrative effort for managing the server infrastructure
reduced administrative effort for managing the server infrastructure
Suggested answer: A, C
asked 02/10/2024
Yedron Rojas Acosta
49 questions

Question 186

Report
Export
Collapse

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

the Azure Active Directory (Azure AD) account that created the database
the Azure Active Directory (Azure AD) account that created the database
the server admin login account of the logical server
the server admin login account of the logical server
the Azure Active Directory (Azure AD) administrator account
the Azure Active Directory (Azure AD) administrator account
the sa account
the sa account
Suggested answer: B

Explanation:

Section: Describe how to work with relational data on Azure

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.

Reference:

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

asked 02/10/2024
BRIAN SCULLION
32 questions

Question 187

Report
Export
Collapse

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

multi-master replication
multi-master replication
Availability Zones
Availability Zones
the strong consistency level
the strong consistency level
automatic failover
automatic failover
Suggested answer: B

Explanation:

Section: Describe how to work with non-relational data on Azure

With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a given region to provide high availability and resiliency to zonal failures.

Note: Azure Cosmos DB provides high availability in two primary ways. First, Azure Cosmos DB replicates data across regions configured within a Cosmos account. Second, Azure Cosmos DB maintains 4 replicas of data within a region.

Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

asked 02/10/2024
Juned Kazi
41 questions

Question 188

Report
Export
Collapse

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 resiliency if an Azure region fails
supports partitioning
supports partitioning
provides a higher storage capacity
provides a higher storage capacity
supports a multi-master model
supports a multi-master model
Suggested answer: D

Explanation:

Section: Describe how to work with non-relational data on Azure

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.

Reference:

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

asked 02/10/2024
Paola Aguirre
39 questions

Question 189

Report
Export
Collapse

Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network.

Which type of data store should you use?

graph
graph
key/value
key/value
document
document
columnar
columnar
Suggested answer: A

Explanation:

Section: Describe how to work with non-relational data on Azure

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.

Reference:

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

asked 02/10/2024
claudine Nguepnang
45 questions

Question 190

Report
Export
Collapse

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
Represent trends and patterns over time
Implement machine learning to predict future values
Implement machine learning to predict future values
Communicate the significance of data
Communicate the significance of data
Consistently implement business logic across reports
Consistently implement business logic across reports
Suggested answer: A, C

Explanation:

Section: Describe an analytics workload on Azure

Data visualization is a key component in being able to gain insight into your data. It helps make big and small data easier for humans to understand. It also makes it easier to detect patterns, trends, and outliers in groups of data. Data visualization brings data to help you find key business insights quickly and effectively.

Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization

asked 02/10/2024
eswar raj
33 questions
Total 285 questions
Go to page: of 29
Search

Related questions