Welcome to our review of DP-900 exam dumps, group three edition! In this blog post, we’ll take a look at a new set of practice questions and answers for the DP-900 certification exam, and evaluate their relevance to the actual test. Whether you’re a first-time test taker or renewing your certification, the goal is to provide you with insights that will help you prepare for the exam. We’ll also include link to the original source for your convenience. So, let’s dive into these exam dumps and get ready for success on your DP-900 certification exam!
Question # 1
Select the answer that correctly completes the sentence.
Objects in which things about data should be captured and stored are called: _________.
A. tables
B. entities
C. rows
D. columns
B – Entities
Question # 2
To complete the sentence, select the appropriate option in the answer area.
Transactional writes
Question # 3
Which Azure Data Factory component should you use to represent data that you want to ingest for processing?
A. Link services
B. Datasets
C. Pipelines
D. Notebooks
B – Datasets
Question # 4
You design a data ingestion and transformation solution by using Azure Data Factory service. You need to get data from an Azure SQL database.
Which two resources should you use?
A. Link service
B. Copy data activity
C. Dataset
D. Azure Databricks notebook
A – Link service, and
B – Copy data activity
A. Link service: A link service is used to connect to external data sources and make them available to the Azure Data Factory service. In this case, you need to use a link service to connect to the Azure SQL database as a source for your data.
B. Copy data activity: The copy data activity is used to move data from a source to a destination. In this case, you can use the copy data activity to extract data from the Azure SQL database and load it into your target destination.
Therefore, the correct answer is A and B.
Question # 6
What are three characteristics of non-relational data?
Each correct answer present a complete solution.
A. Forced schema on data structures
B. Flexible storage of ingested data
C. Entities are self-describing
D. Entities may have different fields
F. Each row has the exact same columns
B – Flexible storage of ingested data,
C – Entities are self-describing, and
D – Entities may have different fields
B. Flexible storage of ingested data: Non-relational databases provide a flexible approach to storing data, allowing for various data types and structures to be ingested.
C. Entities are self-describing: Non-relational databases do not rely on a fixed schema or structure, and the entities within them are self-describing, meaning that the data itself contains information about its organization and relationships.
D. Entities may have different fields: Non-relational databases allow for entities to have different fields, which is different from the rigid structure of a traditional relational database where each row must have the exact same columns.
Question # 7
You need to use JavaScript Object Notation (JSON) files to provision Azure storage.
What should you use?
A. Azure Portal
B. Azure command-line interface (CLI)
C. Azure PowerShell
D. Azure Resource Manager (ARM) templates
All of the above options (A, B, C, and D)
All of them can be used to provision Azure storage using JSON. However, the specific tool to use may depend on factors such as personal preference, familiarity, and the complexity of the JSON template being used.
Question # 8
Which Azure data service should you use?
A. Azure Table
B. Azure Cosmos DB
C. Azure Blob
D. Azure File
B – Azure Cosmos DB
Graph databases are optimized for managing highly interconnected data, such as social networks, recommendation engines, and knowledge graphs. Among the Azure data services, Azure Cosmos DB is the only one that provides a native graph database capability through its Gremlin API. Therefore, B. Azure Cosmos DB is the correct choice for creating a graph database.
Question # 9
Which two Azure data services support Apache Spark clusters?
Each correct answer presents a complete solution.
A. Azure Synapse Analytics
B. Azure Cosmos DB
C. Azure Databricks
D. Azure Data Factory
A – Azure Synapse Analytics, and
C – Azure Databricks
Azure Synapse Analytics is a cloud-based analytics service that provides a unified experience for ingesting, preparing, managing, and serving data for immediate business intelligence and machine learning needs. It includes Apache Spark as part of its big data processing capabilities.
Azure Databricks is an Apache Spark-based analytics platform that provides collaborative workspace for data engineers, data scientists, and machine learning engineers to work together. It includes a managed Spark cluster service that enables you to run Apache Spark-based workloads on demand.
Question # 10
Which type of workload describes this scenario?
A. Online Transaction Processing (OLTP)
B. Batch
C. Rows
D. Streaming
D – Streaming
In the given scenario, the requirement is to gather real-time telemetry data from a mobile application. This is a continuous and real-time workload that involves processing and analyzing large volumes of data that are generated continuously from a data stream. This type of workload is best handled by a streaming service like Azure Stream Analytics, which can process real-time data streams from various sources, including IoT devices, social media, and other applications.
Question # 11
For which reason should you deploy a data warehouse?
A. Record daily sales transactions
B. Perform sales trend analysis
C. Print sales orders
D. Search status of sales orders
B – Perform sales trend analysis
Deploying a data warehouse is ideal for performing data analytics, including tasks such as sales trend analysis. By having a centralized repository for data, a data warehouse can help provide insights and support data-driven decision making. For example, analyzing sales trends can help businesses make informed decisions on product offerings, marketing strategies, and inventory management.
Question # 12
You have an application that runs Windows and requires access to a mapped drive.
Which Azure service should you use?
A. Azure Files
B. Azure Cosmos DB
C. Azure Table Storage
A – Azure Files
Azure Files provides fully managed file shares that can be accessed through the industry standard SMB (Server Message Block) protocol.
In other words, Azure Files is the best option for accessing a mapped drive because it is designed specifically for sharing files across multiple machines and operating systems in the cloud.
Question # 13
Which storage solution supports access control lists (ACLs) at the file and folder level?
A. Azure Files
B. Azure Cosmos DB
C. Azure Table Storage
A – Azure Files
Azure Files provides fully managed file shares that can be accessed through the industry standard SMB (Server Message Block) protocol.
In other words, Azure Files is the best option for accessing a mapped drive because it is designed specifically for sharing files across multiple machines and operating systems in the cloud.
Question # 14
Which statement is an example of Data Manipulation Language (DML)?
A. Revoke
B. Disable
C. Update
C – Update
Update is an example of Data Manipulation Language (DML). DML statements are used to manipulate the data stored in a database, such as inserting, updating, and deleting records.
Data Manipulation Language (DML) is a category of SQL commands used to modify the data in a database. The statement “UPDATE” is an example of a DML command because it modifies the existing data in a table.
