[2022] DP-900 Exam Dumps, Test Engine Practice Test Questions
Pass DP-900 exam [Mar 01, 2022] Updated 169 Questions
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.
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 |
NEW QUESTION 12
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:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing
NEW QUESTION 13
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 14
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:
NEW QUESTION 15
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:
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboardshttps://powerbi.microsoft.com/en-us/excel-and-power-bi/
NEW QUESTION 16
Match the types of workloads the appropriate scenario.
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:
NEW QUESTION 17
What should you use to build a Microsoft Power BI paginated report?
- A. Charticulator
- B. Power BI Desktop
- C. Power BI report Builder
- D. the Power BI service
Answer: C
Explanation:
Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-quickstart-aw
NEW QUESTION 18
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?
- A. Create a user-defined restore point.
- B. Delete the pool
- C. Pause the pool.
- D. Scale down the data warehouse units (DWUs).
Answer: C
NEW QUESTION 19
Your company is designing a data store that will contain student data. The data has the following format.
Which type of data store should you use?
- A. key/value
- B. graph
- C. object
- D. columnar
Answer: D
NEW QUESTION 20
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
- A. the strong consistency level
- B. Availability Zones
- C. automatic failover
- D. multi-master replication
Answer: B
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation:
With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a given region to provide high availability and resiliency to zonal failures.
Note: Azure Cosmos DB provides high availability in two primary ways. First, Azure Cosmos DB replicates data across regions configured within a Cosmos account. Second, Azure Cosmos DB maintains 4 replicas of data within a region.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability
NEW QUESTION 21
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://teachcomputerscience.com/relational-databases/
NEW QUESTION 22
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:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/
NEW QUESTION 23
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.
Answer:
Explanation:
NEW QUESTION 24
Which Azure Data Factory component provides the compute environment for activities?
- A. a pipeline
- B. an integration runtime
- C. a control flow
- D. a linked service
Answer: D
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/v1/data-factory-compute-linked-services
NEW QUESTION 25
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?
- A. Azure SQL Database
- B. Azure Synapse Analytics
- C. Azure Cosmos DB
- D. Azure HDInsight
Answer: A
Explanation:
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
NEW QUESTION 26
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. access to the latest features
- B. in-database machine learning services
- C. complete control over backup and restore processes
- D. reduced administrative effort for managing the server infrastructure
Answer: A,D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation:
A: Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
D: SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview
NEW QUESTION 27
You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?
- A. Online Analytical Processing (OLAP)
- B. stream processing
- C. batch processing
- D. Online Transaction Processing (OLTP)
Answer: D
Explanation:
Section: Describe how to work with relational data on Azure
Explanation:
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.
Reference:
https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/
NEW QUESTION 28
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown for the fourth quarter?
- A. descriptive
- B. diagnostic
- C. predictive
- D. prescription
Answer: D
NEW QUESTION 29
You need to recommend a data store service that meets the following requirements:
Native SQL API access
Configurable indexes
What should you recommend?
- A. Azure Table storage
- B. Azure Cosmos DB
- C. Azure Blob storage
- D. Azure Files
Answer: B
NEW QUESTION 30
Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share
NEW QUESTION 31
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
NEW QUESTION 32
......
Microsoft DP-900 Real 2022 Braindumps Mock Exam Dumps: https://www.passsureexam.com/DP-900-pass4sure-exam-dumps.html
Microsoft DP-900 Actual Questions and 100% Cover Real Exam Questions: https://drive.google.com/open?id=1jRwvQkDMrTzwwhWQPN91axIbYVuevmGb