[Nov-2023 Newly Released] DP-900 Dumps for Microsoft Certified: Azure Data Fundamentals Certified [Q125-Q149]

[Nov-2023 Newly Released] DP-900 Dumps for Microsoft Certified: Azure Data Fundamentals Certified [Q125-Q149]

November 30, 2023 latestexam 0 Comments

Rate this post

[Nov-2023 Newly Released] DP-900 Dumps for Microsoft Certified: Azure Data Fundamentals Certified

Updated Verified DP-900 dumps Q&As – 100% Pass

To pass the DP-900 exam, candidates need to have a good understanding of the core concepts of data storage, processing, and security. They also need to be familiar with the Azure services and tools that are used for data management and processing. DP-900 exam consists of multiple-choice questions and is designed to be completed within 60 minutes.

QUESTION 125
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

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

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

Reference:
https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql

QUESTION 128
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Explanation

Box 1: The CRM system
Data is extracted from the CRM system.
Box 2: The data warehouse
Data is loaded to the data warehouse.
Box 3: An in-memory data integration tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.

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

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

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

QUESTION 131
Select the answer that correctly completes the sentence.

Explanation

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

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

QUESTION 133
Select the answer that correctly completes the sentence.

Explanation

QUESTION 134
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Explanation
Graphical user interface, text, application, chat or text message Description automatically generated

Box 1: The CRM system
Data is extracted from the CRM system.
Box 2: The data warehouse
Data is loaded to the data warehouse.
Box 3: A standalone data analysis tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.
Graphical user interface, text, application Description automatically generated

QUESTION 135
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

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

QUESTION 136
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

QUESTION 137
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?

a table

an index

scalar function

a view

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

QUESTION 138
You have a data store that has the structure shown in the following exhibit.

Which type of data store is this?

object data

graph

key/value

time series

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

Reference:
https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql

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

Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

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

QUESTION 142
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

QUESTION 143
You have an Azure SQL database that you access directly from the Internet.
You recently changed your external IP address.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?

role-based access control (RBAC)

Dynamic Host Configuration Protocol (DHCP)

Domain Name Service (DNS)

a database-level firewall

Section: Describe how to work with relational data on Azure
Explanation
Explanation:
The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database.
When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule.
Reference:
https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/

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

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

QUESTION 146
Which three actions are used when performing diagnostic analytics?

* Identify data anomalies
* Collect anomaly-related data
* Discover relationships and trends that explain anomalies.

* Identify data anomalies
* Predict when anomalies are likely to recur
* Use analytical tools such as decision trees and regression.

* Apply serf-learning loops to draw inferences from anomalies.
* Predict when anomalies are likely to recur
* Use analytical tools such as decision trees and regression.

* Identify data anomalies
* Use machine learning to find patterns in large datasets.
* Discover relationships and trends that explain anomalies.

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