Microsoft DP-900 Exam Updated Material

Prévia do material em texto

DP-900 Microsoft Azure Data Fundamentals exam dumps questions are the best
material for you to test all the related Microsoft exam topics. By using the DP-900
exam dumps questions and practicing your skills, you can increase your
confidence and chances of passing the DP-900 exam.
Features of Dumpsinfo’s products
Instant Download
Free Update in 3 Months
Money back guarantee
PDF and Software
24/7 Customer Support
Besides, Dumpsinfo also provides unlimited access. You can get all Dumpsinfo
files at lowest price.
Microsoft Azure Data Fundamentals DP-900 exam free dumps questions are
available below for you to study. 
Full version: DP-900 Exam Dumps Questions
1.You have structured data in tabular format.
What represents an individual instance of a data entity?
A. a column
B. a cell
C. a row
D. a table
Answer: C
2.HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
 1 / 15
https://www.dumpsinfo.com/unlimited-access/
https://www.dumpsinfo.com/exam/dp-900
Answer:
Explanation:
Graphical userinterface, text, application
Description automatically generated
3.HOTSPOT
Select the answer that correctly completes the sentence.
Answer:
4.Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. MERGE
D. CREATE
Answer: D
 2 / 15
https://www.dumpsinfo.com/
Explanation:
Reference: https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
5.CORRECT TEXT
Select the answer that correctly completes the sentence.
Answer:
Answer as below.
6. Relationship between employyes = Azure Cosmos DB Gremlin API
7.Which component of Azure Data Factory enables you to define a sequence of activities including for
each iterators?
A. control flow
B. linked services
C. datasets
D. the integration runtime
Answer: B
8.What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct
answer presents a complete solution.NOTE: Each correct selection is worth one point. (Choose
three.)
A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema on write
E. schema on read
F. normalized data
Answer: B,D,F
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-
transaction-processing
9.You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL
database.
You need to embed documents and query results into a SQL notebook.
What should you use?
A. Microsoft SQL Server Management Studio (SSMS)
B. Azure Data Studio
 3 / 15
https://www.dumpsinfo.com/
C. Azure CLI
D. Azure PowerShell
Answer: B
Explanation:
Reference: https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-
studio/
10.Which Azure storage solution provides native support for POSIX-compliant access control lists
(ACLs)?
A. Azure Queue storage
B. Azure Data Lake Storage
C. Azure table storage
D. Azure Files
Answer: B
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
11.HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
12.CORRECT TEXT
Select the answer that correctly completes the sentence.
 4 / 15
https://www.dumpsinfo.com/
Answer:
Answer as below.
13.HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Paginated Reports
https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-
availability/
14.Your company is designing a database that will contain session data for a website. The data will
includenotifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?
A. key/value
B. graph
C. columnar
D. document
Answer: C
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-
choices/analytical-data-stores
15.Which three actions are used when performing diagnostic analytics?
 5 / 15
https://www.dumpsinfo.com/
A.• Identify data anomalies
• Collect anomaly-related data
• Discover relationships and trends that explain anomalies.
B.• Identify data anomalies
• Predict when anomalies are likely to recur
• Use analytical tools such as decision trees and regression.
C.• 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.
D.• Identify data anomalies
• Use machine learning to find patterns in large datasets.
• Discover relationships and trends that explain anomalies.
Answer: A
16.HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
17.CORRECT TEXT
Select the answer that correctly completes the sentence.
Answer:
Answer below as:
18.HOTSPOT
For each of the following statements. select Yes if the statement is true. Otherwise, select No.NOTE
 6 / 15
https://www.dumpsinfo.com/
Each correct selection is worth one point.
Answer:
19.HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question: What’s happening?
 7 / 15
https://www.dumpsinfo.com/
Diagnostic, to answer the question: Why’s happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
20.HOTSPOT
Select the answer that correctly completes the sentence.
Answer:
21.What is a difference between structured data and semi-structured data?
A. Structured data has a fixed schema and semi-structured data has a flexible schema.
B. Only Structured data supports entities.
C. Structured data has a flexible schema and semi-structured data has a fixed schema.
D. Only Structured data supports attributes.
Answer: A
22.HOTSPOT
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:
 8 / 15
https://www.dumpsinfo.com/
Explanation:
Box 1: Yes
Big data solutions often use long-running batch jobs to filter, aggregate, and otherwise prepare the
data for analysis. Usually these jobs involve reading source files from scalable storage (like HDFS,
Azure Data Lake Store, and Azure Storage), processing them, and writing the output to new files in
scalable storage.
Box 2: No
Box 3: No
23.HOTSPOT
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:
24.A bank has a system that manages financial transactions.
When transferring money between accounts, the system must never retrieve a value for the source
account that reflects the balance before the transfer and a value for the destination account that
 9 / 15
https://www.dumpsinfo.com/
reflects the balance after the transfer.
Of which ACID semantic is this an example?
A. atomicity
B. isolation
C. durability
D. consistency
Answer: B
Explanation:
Isolation. See course material:
o concurrent transactions cannot interfere with one another, and must result in a consistent database
state.
o For example, while the transaction to transfer funds from one account to another is in-process,
another transaction that checks the balance of these accounts must return consistent results - the
balance-checking transaction can't retrieve a value for one account that reflects the balance before
the transfer, and a value for the other account that reflects thebalance after the transfer.
25.HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
26.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?
A. a database-level firewall
B. role-based access control (RSAC)
C. Dynamic Host Configuration Protocol (DHCP)
D. Domain Name Service (DNS)
Answer: A
Explanation:
The Azure SQL Database firewall lets you decide which IP addresses may or may not haveaccess to
 10 / 15
https://www.dumpsinfo.com/
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/
27.HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
28.1.HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Answer:
 11 / 15
https://www.dumpsinfo.com/
29.HOTSPOT
Select the answer that correctly completes the sentence.
Answer:
30.DRAG DROP
Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on
the right. Each activity type may be used once, more than once, or not at all. NOTE: Each correct
match is worth one point.
Answer:
 12 / 15
https://www.dumpsinfo.com/
31.Which two Azure services can be used to provision Spark clusters? Each correct answer presents
a complete solution. NOTE: Each correct selection is worth one point.
A. Azure Databricks
B. Azure Log Analytics
C. Azure Time Series Insights
D. Azure HDinsight
Answer: A,D
Explanation:
Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/
32.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. Low latency is expected
C. High latency acceptable
D. Data is processed periodically
Answer: A,B
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
33.HOTSPOT
Select the answer that correctly completes the sentence.
Answer:
 13 / 15
https://www.dumpsinfo.com/
34.Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft
SQL Server instances, while providing automated updates,
backups, and maintenance tasks?
A. Azure SQL Managed Instance
B. SQL Server on Azure Virtual Machines
C. Azure SQL Edge
D. Azure SQL Database
Answer: A
35.A bar chart showing year-to date sales by region is an example of which type of analytics?
A. descriptive
B. diagnostic
C. predictive
D. prescriptive
Answer: A
36.You have a transactional application that stem data in an Azure SQL managed instance. When
should you implement a read-only database replica?
A. You need to generate reports without affecting the transactional workload.
B. You need to audit the transactional application.
C. You need to implement high availability in the event of a regional outage
D. You need to improve the recovery point objective (RPO).
Answer: A
Explanation:
Use read-only replicas to offload read-only query workloads.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out
37.HOTSPOT
Select the answer that correctly completes the sentence.
Answer:
 14 / 15
https://www.dumpsinfo.com/
38.A data engineer is responsible for which task?
A. Design and build analytical models.
B. Design and implement data stores for analytical workloads.
C. Explore data to identify trends.
D. Implement policies, tools. and processes for backup and recovery plans.
Answer: B
39.What can be used with native notebook support to query and visualize data by using a web-based
interface?
A. Azure Databricks
B. pgAdmin
C. Microsoft Power Bl
Answer: A
40.Which clause should you use in a select statement to combine rows in one table with rows in
another table?
A. JOIN
B. VALUES
C. set
D. KEY
Answer: A
Explanation:
Reference: https://www.tutorialspoint.com/sql/sql-using-joins.htm
 15 / 15
https://www.dumpsinfo.com/