Valid DP-900 Exam Q&A PDF DP-900 Dump is Ready (Updated 260 Questions) [Q125-Q142]

4.5/5 - (2 votes)

Valid DP-900 Exam Q&A PDF DP-900 Dump is Ready (Updated 260 Questions)

Exam Questions and Answers for DP-900 Study Guide

There are no strict prerequisites for taking the Microsoft DP-900 exam. However, it is recommended that candidates have some basic knowledge of working with data and have some experience with Azure services. Candidates can also opt to take the Microsoft Learn course on Azure Data Fundamentals before taking the exam to prepare for the test.

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

Q126. Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

graph

key/value

object

columnar

Q127. To complete the sentence, select the appropriate option in the answer area.

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

Explanation

Box 1: Yes
Like IaaS, PaaS includes infrastructure – servers, storage, and networking – but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources Box 2: Yes You manage the applications and services you develop, and the cloud service provider typically manages everything else.

Box 3: No
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft’s official answer “Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB.”

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

Reference:
https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/

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

stream processing

Online Transaction Processing (OLTP)

batch processing

Online Analytical Processing (OLAP)

Reference:
https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/

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

Explanation
Box 1: Yes
Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.
Box 2: Yes
Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.
Box 3: No

Q132. To complement the sentence, select the appropriate option in the answer area.

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

Reference:
https://azure.microsoft.com/en-us/overview/what-is-paas
https://feedback.azure.com/forums/217321-sql-database/suggestions/6931152-please-add-ability-to-temporarily-turn-off-on-sql

Q134. To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/frequently-asked-questions

Q135. To complete the sentence, select the appropriate option in the answer area.

Reference:
https://www.sqlshack.com/graph-database-implementation-with-azure-cosmos-db-using-the-api/

Q136. Select the answer that correctly completes the sentence.

Q137. What are two uses of data visualization? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.

Represent trends and patterns over time.

Communicate the significance of data.

implement machine learning to predict future values.

Consistently implement business logic across reports

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

Q138. To complete the sentence, select the appropriate option in the answer area.

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

Q139. Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

predictive

prescription

descriptive

diagnostic

Q140. To complete the sentence, select the appropriate option in the answer area.

Q141. Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right.
Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Explanation

Box 1: Tree map
Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles.

Box 2: Key influencer
A key influencer chart displays the major contributors to a selected result or value.
Box 3: Scatter
Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures — whether or not, in which order, etc.

Q142. To complete the sentence, select the appropriate option in the answer area.