DP-900 Dumps PDF New [2021] Ultimate Study Guide
DP-900 Exam Dumps PDF Updated Dump from PassCollection Guaranteed Success
What Are the Exam Topics?
Core data concepts
This topic majorly addresses the following skills:
- Various data workloads – this involves an overview of the features of relational data as well as the description, similarities and differences between streaming data and batch data as well as.
- Main concepts of data analytics – data visualization, business intelligence (BI), analytics techniques (diagnostic, predictive, descriptive, cognitive, prescriptive) and basic chart types such as pie charts and bar charts are the main concepts addressed in this category. Also, data processing techniques are covered along with ETL processing.
NEW QUESTION 81
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.
Answer:
Explanation:
Explanation
Box 1: Tree map
Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles.
Box 2: Key influencer
A key influencer chart displays the major contributors to a selected result or value.
Box 3: Scatter
Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which order, etc.
NEW QUESTION 82
You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?
- A. Azure Functions
- B. PolyBase
- C. Azure Data Factory
- D. Microsoft SQL Server Integration Services (SSIS)
Answer: B
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html
NEW QUESTION 83
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
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
You can use Azure Data Studio to connect to an Azure SQL Database server. You'll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.
Box 2: No
SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks.
Instead use Azure Data Studio to create SQL notebook.
Box 3: Yes
You can use the Azure Data Studio to restore databases.
NEW QUESTION 84
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. Each location may be used 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.
Answer:
Explanation:
Explanation
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: An in-memory data integration tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.
NEW QUESTION 85
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 86
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:
Section: Describe an analytics workload on Azure
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 87
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
- A. supports partitioning
- B. supports a multi-master model
- C. provides a higher storage capacity
- D. provides resiliency if an Azure region fails
Answer: B
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation:
Multi-master support for Azure Cosmos DB is now available in all public regions.
Azure CosmosDB table API is a key-value storage hosted in the cloud. It's a part of Azure Cosmos DB, that is Microsoft's multi-model database.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/table-support
NEW QUESTION 88
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Explanation
Box 1: Batch
The batch processing model requires a set of data that is collected over time while the stream processing model requires data to be fed into an analytics tool, often in micro-batches, and in real-time.
The batch Processing model handles a large batch of data while the Stream processing model handles individual records or micro-batches of few records.
In Batch Processing, it processes over all or most of the data but in Stream Processing, it processes over data on a rolling window or most recent record.
Box 2: Batch
Box 3: Streaming
NEW QUESTION 89
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 90
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 91
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 92
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://www.w3schools.com/js/js_json_arrays.asp
https://www.w3schools.com/js/js_json_objects.asp
NEW QUESTION 93
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.
Select and Place:
Answer:
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities#data-transformation- activities
NEW QUESTION 94
Which statement is an example of Data Manipulation Language (DML).
- A. ALTER
- B. DROP
- C. INSERT
- D. DISABLE
Answer: C
Explanation:
Explanation
Data Manipulation Language (DML) statements:
* DELETE
* INSERT
* UPDATE
NEW QUESTION 95
Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.
Which type of processing does the reporting solution use?
- A. stream processing
- B. Online Analytical Processing (OLAP)
- C. batch processing
- D. Online Transaction Processing (OLTP)
Answer: B
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://datawarehouseinfo.com/how-does-oltp-differ-from-olap-database/
NEW QUESTION 96
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. blob
- C. file
- D. table
Answer: B
NEW QUESTION 97
You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?
- A. You need to improve the recovery point objective (RPO).
- B. You need to audit the transactional application.
- C. You need to generate reports without affecting the transactional workload.
- D. You need to implement high availability in the event of a regional outage.
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries- readable-secondary-replicas-always-on-availability-groups?view=sql-server-ver15
NEW QUESTION 98
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 99
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
Box 1: simple lookups
A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
NEW QUESTION 100
......
Pass Your Microsoft Exam with DP-900 Exam Dumps: https://www.passcollection.com/DP-900_real-exams.html
DP-900 Exam Dumps - Microsoft Practice Test Questions: https://drive.google.com/open?id=1INck9UgEf5HKouwzDqaXcOoTqSyJI7qA
