Latest [May 15, 2023] Microsoft DP-900 Exam Practice Test To Gain Brilliante Result [Q147-Q166]

Rate this post

Latest [May 15, 2023] Microsoft DP-900 Exam Practice Test To Gain Brilliante Result

Take a Leap Forward in Your Career by Earning Microsoft DP-900

The Microsoft DP-900 (Microsoft Azure Data Fundamentals) Exam is a great entry-level certification for anyone who is looking to start a career in data management or data analytics. The exam covers a wide range of topics related to Azure data services, data storage options, data processing technologies, and data security. This certification is a great starting point for anyone who is new to Azure data services and provides a solid foundation for anyone who is looking to pursue more advanced certifications in Azure data services.

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

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

relational

columnar

graph

time series

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.

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

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

NEW QUESTION 151
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.sqlshack.com/what-is-database-normalization-in-sql-server/

NEW QUESTION 152
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

a dashboard

Microsoft Power Apps

a dataflow

a report

Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

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

Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

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

Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

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

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal

NEW QUESTION 156
You have the following JSON document.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.

Reference:
https://www.w3schools.com/js/js_json_arrays.asp
https://www.w3schools.com/js/js_json_objects.asp

NEW QUESTION 157
Which command-line tool can you use to query Azure SQL databases?

sqlcmd

bcp

azdata

Azure CLI

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=singledatabase

NEW QUESTION 158
Select the answer that correctly completes the sentence.

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

denormalized data

schema defined in a database

schema defined when reading unstructured data from a database

normalized data

light writes and heavy reads

heavy writes and moderate reads

NEW QUESTION 160
Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

NEW QUESTION 161
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

NEW QUESTION 162
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://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

NEW QUESTION 163
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

WHERE

SELECT

JOIN

NEW QUESTION 164
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

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