Updated Dec 07, 2021 DP-900  Exam Dumps - PDF Questions and Testing Engine

New (2021) Microsoft DP-900  Exam Dumps

NEW QUESTION 83
Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?

• A. relational
• B. time series
• C. columnar
• D. graph

Answer: B

Explanation:
Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

 

NEW QUESTION 84
What are two characteristics of real-time data processing? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.

• A. Data is processed as it is created.
• B. High latency acceptable
• C. Data is processed periodically
• D. Low latency is expected

Answer: A,D

Explanation:
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

 

NEW QUESTION 85
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

• A. denormalized data
• B. heavy writes and moderate reads
• C. schema on read
• D. light writes and heavy reads
• E. normalized data
• F. schema on write

Answer: B,C,F

Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

 

NEW QUESTION 86
For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

Answer:

Explanation:

 

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

• A. JOIN
• B. CREATE
• C. SELECT
• D. MERGE

Answer: B

 

NEW QUESTION 88
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/faq

 

NEW QUESTION 89
For each of the following statements. select Yes if the statement is true. Otherwise, select No.
NOTE Each correct selection is worth one point.

Answer:

Explanation:

 

NEW QUESTION 90
You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.) NOTE: Each correct selection is worth one point.

• A. You must be assigned the Reader role for the resource group that contains the database.
• B. Your IP address must be allowed to connect to the database.
• C. You must have a user in the database.
• D. You must be assigned the Contributor role for the resource group that contains the database.
• E. You must have SELECT access to the Products table.

Answer: B,C,E

Explanation:
Explanation
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-data

 

NEW QUESTION 91
Which Azure Data Factory component provides the compute environment for activities?

• A. a control flow
• B. a pipeline
• C. an integration runtime
• D. a linked service

Answer: C

Explanation:
Section: Describe an analytics workload on Azure
Explanation:
The Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the following data integration capabilities across different network environments:
* Data Flow
* Data movement
* Activity dispatch
* SSIS package execution
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

 

NEW QUESTION 92
You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?

• A. object
• B. key/value
• C. document
• D. columnar

Answer: A

Explanation:
Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

 

NEW QUESTION 93
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

 

NEW QUESTION 94
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?

• A. stream processing
• B. Online Analytical Processing (OLAP)
• C. batch processing
• D. Online Transaction Processing (OLTP)

Answer: B

Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

 

NEW QUESTION 95
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A. database
• B. container
• C. item
• D. partition

Answer: A,B

 

NEW QUESTION 96
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

 

NEW QUESTION 97
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?

• A. Graph
• B. Key/value
• C. Document
• D. columnar

Answer: A

Explanation:
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

 

NEW QUESTION 98
What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A. Data is processed periodically
• B. Data is processed as it is created
• C. Low latency is expected
• D. High latency is acceptable

Answer: B,C

Explanation:
Section: Describe core data concepts
Explanation:
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

 

NEW QUESTION 99
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

 

NEW QUESTION 100
What are two characteristics of real-time data processing? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.

• A. High latency acceptable
• B. Data is processed as it is created.
• C. Data is processed periodically
• D. Low latency is expected

Answer: C,D

 

NEW QUESTION 101
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

 

NEW QUESTION 102
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.

• A. a dataflow
• B. a text box
• C. a visualization from a report
• D. a report page
• E. a Microsoft PowerPoint slide

Answer: B,C,D

 

NEW QUESTION 103
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

 

NEW QUESTION 104
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

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

 

NEW QUESTION 105
......

The DP-900: Microsoft Azure Data Fundamentals exam is designed for the individuals pursuing the Microsoft Certified: Azure Data Fundamentals certification. This test evaluates their foundational knowledge of core concepts of data and how these are implemented with the use of Microsoft Azure data services. The associated certificate is an ideal choice for those professionals who want to start a career in the IT field with the main focus on working with data in Cloud. The successful candidates with this certification can continue their journey by earning more advanced options such as Microsoft Certified: Azure Data Engineer Associate or Microsoft Certified: Azure Database Administrator Associate. However, it is important to mention that this exam is not a requirement for any of these certificates.

This is a foundational certification exam, so it does not require any prerequisites. However, the potential candidates should have a good knowledge of the concepts of non-relational and relational data as well as different categories of data workloads, including analytical and transactional.

 

Updated Verified Pass DP-900 Exam - Real Questions & Answers: https://www.vce4dumps.com/DP-900-valid-torrent.html

Best Way To Study For Microsoft DP-900 Exam Brilliant DP-900 Exam Questions PDF: https://drive.google.com/open?id=1wGg9IzFuURi2Sy3iumqukK6m-uYZ1-M6