DP-900 exam questions for practice in 2022 Updated 169 Questions
Updated Feb-2022 Premium DP-900 Exam Engine pdf - Download Free Updated 169 Questions
Microsoft DP-900 Exam Syllabus Topics:
| Topic | Details |
|---|---|
Describe core data concepts (15-20%) | |
| Describe types of core data workloads | - describe batch data - describe streaming data - describe the difference between batch and streaming data - describe the characteristics of relational data |
| Describe data analytics core concepts | - describe data visualization (e.g., visualization, reporting, business intelligence (BI)) - describe basic chart types such as bar charts and pie charts - describe analytics techniques (e.g., descriptive, diagnostic, predictive, prescriptive, cognitive) - describe ELT and ETL processing - describe the concepts of data processing |
Describe how to work with relational data on Azure (25-30%) | |
| Describe relational data workloads | - identify the right data offering for a relational workload - describe relational data structures (e.g., tables, index, views) |
| Describe relational Azure data services | - describe and compare PaaS, IaaS, and SaaS solutions - describe Azure SQL family of products including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines - describe Azure Synapse Analytics - describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure Database for MySQL |
| Identify basic management tasks for relational data | - describe provisioning and deployment of relational data services - describe method for deployment including the Azure portal, Azure Resource Manager templates, Azure PowerShell, and the Azure command-line interface (CLI) - identify data security components (e.g., firewall, authentication) - identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls) - identify query tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd utility, etc.) |
| Describe query techniques for data using SQL language | - compare Data Definition Language (DDL) versus Data Manipulation Language (DML) - query relational data in Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL |
Describe how to work with non-relational data on Azure (25-30%) | |
| Describe non-relational data workloads | - describe the characteristics of non-relational data - describe the types of non-relational and NoSQL data - recommend the correct data store - determine when to use non-relational data |
| Describe non-relational data offerings on Azure | - identify Azure data services for non-relational workloads - describe Azure Cosmos DB APIs - describe Azure Table storage - describe Azure Blob storage - describe Azure File storage |
NEW QUESTION 51
Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Azure Log Analytics
- B. Azure Time Series Insights
- C. Azure Databricks
- D. Azure HDinsight
Answer: A,D
NEW QUESTION 52
Match the types of analytics that can be used to answer the business questions.
To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference:
https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/
NEW QUESTION 53
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 54
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 55
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 56
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question: What's happening?
Diagnostic, to answer the question: Why's happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
NEW QUESTION 57
match the Azure data factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description 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://k21academy.com/microsoft-azure/dp-100/datastores-and-datasets-in-azure/
https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services
https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities
NEW QUESTION 58
A team of developers has computers Thai run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense.
What should the developers use ?
- A. Azure Data Studio
- B. sq1cmd
- C. Azure Data Explorer
- D. Microsoft SQL Server Management Studio (SSMS)
Answer: A
Explanation:
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.
Reference:
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio
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:
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 60
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 61
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal
NEW QUESTION 62
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
NEW QUESTION 63
You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI?
- A. a report
- B. Microsoft Power Apps
- C. a dashboard
- D. a dataflow
Answer: A
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
NEW QUESTION 64
Which statement is an example of Data Manipulation Language (DML)?
- A. DISABLE
- B. CREATE
- C. REVOKE
- D. UPDATE
Answer: D
Explanation:
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
BULK INSERT
DELETE
INSERT
SELECT
UPDATE
MERGE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
NEW QUESTION 65
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 66
To complement the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 67
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 68
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77
NEW QUESTION 69
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 70
What is the primary purpose of a data warehouse?
- A. to provide transformation services between source and target data stores
- B. to provide storage for transactional line-of-business (LOB) applications
- C. to provide answers to complex queries that rely on data from multiple sources
- D. to provide read-only storage of relational and non-relational historical data
Answer: D
Explanation:
Consider using a data warehouse when you need to keep historical data separate from the source transaction systems for performance reasons. Data warehouses make it easy to access historical data from multiple locations, by providing a centralized location using common formats, keys, and data models.
Query both relational and nonrelational data.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing
NEW QUESTION 71
To complete the sentence select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 72
Which command-line tool can you use to query Azure SQL databases?
sqlcmd
- A.
- B. azdata
- C. bcp
- D. Azure CLI
Answer: C
Explanation:
Section: Describe how to work with relational data on Azure
Explanation:
The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.
Incorrect Answers:
B: The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format.
D: The Azure CLI is the defacto tool for cross-platform and command-line tools for building and managing Azure resources.
Reference:
https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15
NEW QUESTION 73
......
What is the duration, language, and format of Microsoft DP-900: Microsoft Azure Data Fundamentals Exam
- Length of Examination: 50 mins
- Type of Questions: This test format is multiple choice.
- This is the beta exam, would be available on or around March 31, 2020.
Authentic DP-900 Dumps With 100% Passing Rate Practice Tests Dumps: https://www.actualtests4sure.com/DP-900-test-questions.html
Microsoft DP-900 Real Exam Questions Guaranteed Updated Dump from Actualtests4sure : https://drive.google.com/open?id=1_8kEg5r6mWLaUm8-jKEI8OZ_Ax-EeZvp
