2021 DP-900 Dumps PDF - DP-900 Real Exam Questions Answers
Valid DP-900 Test Answers & Microsoft DP-900 Exam PDF
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 |
| Identify basic management tasks for non-relational data | - describe provisioning and deployment of non-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, encryption) - identify basic connectivity issues (e.g., accessing from on-premises, access with Azure VNets, access from Internet, authentication, firewalls) - identify management tools for non-relational data |
Describe an analytics workload on Azure (25-30%) | |
| Describe analytics workloads | - describe transactional workloads - describe the difference between a transactional and an analytics workload - describe the difference between batch and real time - describe data warehousing workloads - determine when a data warehouse solution is needed |
| Describe the components of a modern data warehouse | - describe Azure data services for modern data warehousing such as Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight - describe modern data warehousing architecture and workload |
| Describe data ingestion and processing on Azure | - describe common practices for data loading - describe the components of Azure Data Factory (e.g., pipeline, activities, etc.) - describe data processing options (e.g., Azure HDInsight, Azure Databricks, Azure Synapse Analytics, Azure Data Factory) |
| Describe data visualization in Microsoft Power BI | - describe the role of paginated reporting - describe the role of interactive reports - describe the role of dashboards - describe the workflow in Power BI |
NEW QUESTION 52
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.
Answer:
Explanation:
NEW QUESTION 53
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 Transaction Processing (OLTP)
- C. Online Analytical Processing (OLAP)
- D. batch processing
Answer: C
NEW QUESTION 54
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. Microsoft Power Apps
- B. a dataflow
- C. a dashboard
- D. a report
Answer: A
NEW QUESTION 55
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 56
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 57
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 58
You have an inventory management database that contains the following table.
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
- A. UPDATE
- B. INSERT
- C. CREATE
- D. MERGE
Answer: A
NEW QUESTION 59
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 60
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
Compute is separate from storage, which enables you to scale compute independently of the data in your system.
Box 2: Yes
You can use the Azure portal to pause and resume the dedicated SQL pool compute resources.
Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be charged compute during that hour.
Box 3: No
Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2 TBs.
NEW QUESTION 61
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation:
https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/
NEW QUESTION 62
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.) NOTE: Each correct selection is worth one point.
- A. Azure Time Series Insights
- B. Azure Log Analytics
- C. Azure HDInsight
- D. Azure Databricks
Answer: C,D
Explanation:
Section: Describe an analytics workload on Azure
Explanation/Reference:
https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/
NEW QUESTION 63
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 64
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 65
Match the security components to the appropriate scenarios.
To answer, drag the appropriate component from the column on the left to its scenario 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://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure
NEW QUESTION 66
Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?
- A. columnar
- B. key/value
- C. graph
- D. document
Answer: B
NEW QUESTION 67
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 68
......
DP-900 Exam Dumps - PDF Questions and Testing Engine: https://www.topexamcollection.com/DP-900-vce-collection.html
Realistic DP-900 Exam Dumps with Accurate & Updated Questions: https://drive.google.com/open?id=1Q3ic9eMJp0dvlk3iEccm-tOCn-UHst4h
