[Jan 23, 2024] DP-900 Practice Exam Dumps - 99% Marks In Microsoft Exam [Q36-Q60]

Rate this post

[Jan 23, 2024] DP-900 Practice Exam Dumps – 99% Marks In Microsoft Exam

Updated Verified DP-900 Q&As – Pass Guarantee or Full Refund

Microsoft DP-900 exam covers a wide range of topics related to Microsoft Azure data services. These topics include the basics of cloud computing, data storage and management, data processing and analytics, and data security and compliance. By passing DP-900 exam, you will demonstrate your knowledge of these topics and your ability to work with Azure data services.

The DP-900 certification exam covers a wide range of topics related to data management in the cloud, including data storage options, data processing, data security and compliance, and much more. With this certification, you will be able to demonstrate your understanding of these concepts and how they can be applied to real-world scenarios.

Q36. Which statement is an example of Data Manipulation Language (DML)?

REVOKE

DISABLE

INSERT

GRANT

Section: Describe core data concepts
Explanation:
Data Manipulation Language (DML) statements:
* DELETE
* INSERT
* UPDATE
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-reference- tsql-statements

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

Q38. 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/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms
https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

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

Q40. Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

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

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

Q42. 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.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/

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

Explanation
Text Description automatically generated

Box 1: Yes
For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Box 2: No
Box 3: Yes
Box 4: Yes
Azure Cosmos DB supports multi-region writes.

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

Q45. Your company is designing a data store for internet-connected temperature sensors.
The collected data will be used to analyze temperature trends.
Which type of data store should you use?

relational

time series

graph

columnar

Section: Describe how to work with non-relational data on Azure
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.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Q46. A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SCX database from the computers. The developers require code assistance features such as intellSense.
What should the developers use ?

Azure Data Studio

sq1cmd

Microsoft SQL Server Management Studio (SSMS)

Azure Data Explorer

Q47. Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Reference:
https://docs.microsoft.com/en-us/azure/machine-learning/how-to-data-ingest-adf
https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/sqldw-walkthrough

Q48. You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount day. The output must produce the following
results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value
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

Box 1: SELECT
Box 2: GROUP BY
Example:
When used with a GROUP BY clause, each aggregate function produces a single value covering each group,
instead of a single value covering the whole table. The following example produces summary values for each
sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the
sales people in each territory, and the sum of year-to-date sales for each territory.
SELECT TerritoryID, AVG(Bonus)as ‘Average bonus’, SUM(SalesYTD) as ‘YTD sales’
FROM Sales.SalesPerson
GROUP BY TerritoryID;

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

Q50. You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?

Azure Cosmos DB

Azure HDInsight

Azure SQL Database

Azure Synapse Analytics

Section: Describe how to work with relational data on Azure
Explanation:
Azure SQL Database is relational database and a managed service.
Incorrect Answers:
A, B: Cosmos DB, HDInsight are non-relational databases.
D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing Reference:
https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

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

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

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

Q53. You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount day. The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.

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

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

Q55. Select the answer that correctly completes the sentence.

Explanation

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

Explanation

Box 1: Yes
Like IaaS, PaaS includes infrastructure – servers, storage, and networking – but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources Box 2: Yes You manage the applications and services you develop, and the cloud service providertypically manages everything else.

Box 3: No
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft’s official answer “Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Thenwhen you need it you can create a new database and import your previously exported DB.”

Q57. Select the answer that correctly completes the sentence.

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

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

Q59. Your company is designing a database that will contain session data for a website. The data will include notifications, 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?

key/value

graph

columnar

document

Section: Describe how to work with non-relational data on Azure
Explanation/Reference:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores

Q60. Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?

an Azure SQL Database elastic pool

Azure SQL Managed Instance

Azure Database for MySQL

Azure SQL Database

Loading …