Hurry Up, Grab the New Year Discount - Save 25% - Ends In 00:00:00 Coupon code: NY25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location Virginia, US

Microsoft DP-900 Exam

Certification Provider: Microsoft
Exam Name: Microsoft Azure Data Fundamentals
Duration: 60 Minutes
Number of questions in our database: 167
Exam Version: Jan. 24, 2022
DP-900 Exam Official Topics:
  • Topic 1: Describe Azure Database for PostgreSQL, Azure Database for MariaDB, andAzure Database for MySQL/ Describe types of core data workloads
  • Topic 2: Describe modern data warehousing architecture and workload/ Describe the difference between batch and streaming data
  • Topic 3: Describe the components of a modern data warehouse/ Describe the characteristics of relational data
  • Topic 4: Describe the difference between a transactional and an analytics workload/ Describe basic chart types such as bar charts and pie charts
  • Topic 5: Describe how to work with non-relational data on Azure/ Identify the right data offering for a relational workload
  • Topic 6: Describe and compare PaaS, IaaS, and SaaS solutions/ Describe ELT and ETL processing
  • Topic 7: Identify Azure data services for non-relational workloads/ Describe how to work with relational data on Azure
  • Topic 8: Describe the concepts of data processing/ Describe data analytics core concepts/ Describe streaming data
  • Topic 9: Describe the types of non-relational and NoSQL data/ Describe relational data structures
  • Topic 10: Determine when a data warehouse solution is needed/ Describe relational Azure data services
  • Topic 11: Describe non-relational data offerings on Azure/ Describe the characteristics of non-relational data
  • Topic 12: Describe the difference between batch and real time/ Determine when to use non-relational data

Free Microsoft DP-900 Exam Actual Questions

The questions for DP-900 were last updated On Jan. 24, 2022

Question #1

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

Which statement should you use?

Reveal Solution Hide Solution
Correct Answer: B

Question #2

You need to store data by using Azure Table storage.

What should you create first?

Reveal Solution Hide Solution
Correct Answer: B

First create an Azure storage account, then use Table service in the Azure portal to create a table.

Note: An Azure storage account contains all of your Azure Storage data objects: blobs, files, queues, and tables.


https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-quickstart-portal

https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create

Question #3

You need to recommend a data store service that meets the following requirements:

Native SQL API access

Configurable indexes

What should you recommend?

Reveal Solution Hide Solution
Correct Answer: D

Azure Cosmos DB comes with native Core (SQL) API support.

In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy can be overridden with your own custom indexing policy.


https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-indexing-policy

Question #4

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?

Reveal Solution Hide Solution
Correct Answer: A

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 #5

What is the primary purpose of a data warehouse?

Reveal Solution Hide Solution
Correct Answer: C

Consider using a data warehouse when you need to keep historical data separate from the source transaction systems for performance reasons. Data warehouses make it easy to access historical data from multiple locations, by providing a centralized location using common formats, keys, and data models.

Query both relational and nonrelational data.


https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing


Unlock all DP-900 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now
Disscuss Microsoft DP-900 Topics, Questions or Ask Anything Related

Save Cancel