The Best Practice Test Preparation for the DP-900 Certification Exam [Q62-Q79]

Rate this post

The Best Practice Test Preparation for the DP-900 Certification Exam

DP-900 Exam Dumps, Practice Test Questions BUNDLE PACK

Microsoft DP-900 exam, also known as the Microsoft Azure Data Fundamentals exam, is a certification exam that focuses on the fundamentals of data management on the Azure cloud platform. DP-900 exam is designed for professionals who are looking to get certified in Azure data technologies and want to demonstrate their knowledge and skills in data management, data processing, and data storage on the Azure cloud.

Q62. You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?

Synapse pipelines

a Synapse SQL pool

Synapse Link

Synapse Studio

https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link

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

Q64. Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?

Azure DNS

Azure Application Gateway

Azure Private link

Azure Traffic Manager

Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.
Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary Reference:
https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

Q65. Select the answer that correctly completes the sentence.

See the answer in explanation below.
Explanation
Answer below as:

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

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

Q68. When you create an Azure SQL database, which account can always connect to the database ?

the Azure Active director/ (Azure AO) account that created the database

the Azure Active Directly Azure AD) administrator account

the sa account

the server admin login account of the logical server

When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.

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

Q70. You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact.
What should you do on the SQL pool?

Scale down the data warehouse units (DWUs).

Pause the pool.

Create a user-defined restore point.

Delete the pool

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-managecompute-overview

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

Explanation:
Box 1: Yes
Azure Databricks can consume data from SQL Databases using JDBC and from SQL Databases using the Apache Spark connector.
The Apache Spark connector for Azure SQL Database and SQL Server enables these databases to act as input data sources and output data sinks for Apache Spark jobs.
Box 2: Yes
You can stream data into Azure Databricks using Event Hubs.
Box 3: Yes
You can run Spark jobs with data stored in Azure Cosmos DB using the Cosmos DB Spark connector. Cosmos can be used for batch and stream processing, and as a serving layer for low latency access.
You can use the connector with Azure Databricks or Azure HDInsight, which provide managed Spark clusters on Azure.
Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs

Q72. Select the answer that correctly completes the sentence.

See the answer in explanation below.
Explanation:
Answer below as:

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

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

Explanation:

Expla nation:
When you create a new server in Azure SQL Database or Azure Synapse Analytics named mysqlserver, for example, a server-level firewall blocks all access to the public endpoint for the server Reference:
https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql

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

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

Q77. Select the answer that correctly completes the sentence.

Explanation:
Text, letter Description automatically generated

Q78. You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos
DB data sources by using Azure Synapse Analytics.
What should you use?

Synapse pipelines

a Synapse SQL pool

Synapse Link

Synapse Studio

Q79. What are two characteristics of real-time data processing? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.

Data is processed as it is created.

Low latency is expected

High latency acceptable

Data is processed periodically

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.

Loading …