DP-900 Free Exam Questions & Answers PDF Updated on Jan-2022
Latest DP-900 Exam Dumps Recently Updated 143 Questions
Microsoft DP-900 Practice Test Questions, Microsoft DP-900 Exam Practice Test Questions
The Microsoft DP-900 exam is a qualifying test for obtaining the Microsoft Certified: Azure Data Fundamentals certification. This exam is intended for the entry-level professionals looking to take up a career path in the IT field. Although it is not a requirement for any advanced-level certificate, the DP-900: Microsoft Azure Data Fundamentals test is a great foundation to prepare the individuals for other Azure role-based options. Thus, the certified candidates can pursue two certifications: Azure Data Engineer Associate or Azure Database Administrator Associate.
NEW QUESTION 57
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
NEW QUESTION 58
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:
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 59
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 60
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:
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
NEW QUESTION 61
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.
Hot Area:
Answer:
Explanation:
Section: Describe an analytics workload on Azure
NEW QUESTION 62
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 63
You have a SQL query that combines customer data and order dat
a. 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. a table
- B. scalar function
- C. a view
- D. an index
Answer: C
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.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views
NEW QUESTION 64
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
Disadvantages of non-relational databases include: Data Consistency - non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
NEW QUESTION 65
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point
Answer:
Explanation:
Reference:
https://en.wikipedia.org/wiki/Snowflake_schema
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/
NEW QUESTION 66
What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
- A. built-in high availability
- B. support for encryption at rest
- C. system-Initiated automatic backups
- D. native support for cross-database queries and transactions
Answer: D
NEW QUESTION 67
Match the Azure services to appropriate requirements.
To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 68
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 69
Match the security components to the appropriate scenarios.
To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component 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/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure
NEW QUESTION 70
You manage an application that stores data in a shared folder on a Windows server.
You need to move the shared folder to Azure Storage.
Which type of Azure Storage should you use?
- A. queue
- B. file
- C. blob
- D. table
Answer: B
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation:
Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used.
Reference:
https://azure.microsoft.com/en-us/services/storage/files/
NEW QUESTION 71
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://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/
https://azure.microsoft.com/en-us/services/sql-database/#product-overview
NEW QUESTION 72
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 73
......
Microsoft DP-900 Real 2022 Braindumps Mock Exam Dumps: https://www.examtorrent.com/DP-900-valid-vce-dumps.html
DP-900 Exam Questions | Real DP-900 Practice Dumps: https://drive.google.com/open?id=1PU4f6Tsvd9gwK8lMnXPsMMrB0UTryICG
