[Oct-2021] Verified Microsoft Exam Dumps with DP-900 Exam Study Guide
Best Quality Microsoft DP-900 Exam Questions DumpsActual Realistic Practice Exams [2021]
NEW QUESTION 37
Match the Azure Cosmos DB APIs to the appropriate data structures.
To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 38
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 39
Which Azure Data Factory component provides the compute environment for activities?
- A. a control flow
- B. an integration runtime
- C. a linked service
- D. a pipeline
Answer: B
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 40
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 41
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 42
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
- A. automatic failover
- B. Availability Zones
- C. the strong consistency level
- D. multi-master replication
Answer: B
Explanation:
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.
NEW QUESTION 43
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
NEW QUESTION 44
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?
- A. columnar
- B. graph
- C. time series
- D. document
Answer: D
NEW QUESTION 45
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Answer:
Explanation:
NEW QUESTION 46
What should you use to build a Microsoft Power BI paginated report?
- A. the Power BI service
- B. Power BI Desktop
- C. Power BI report Builder
- D. Charticulator
Answer: B
NEW QUESTION 47
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
- A. support for encryption at rest
- B. built-in high availability
- C. native support for cross-database queries and transactions
- D. system-initiated automatic backups
Answer: C
Explanation:
Section: Describe how to work with relational data on Azure
Explanation/Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison
NEW QUESTION 48
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 49
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: No
Microsoft handles all patching and updating of the SQL and operating system code. You don't have to manage the underlying infrastructure.
Box 2: Yes
SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations.
Box 3: No
NEW QUESTION 50
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 51
What are two uses of data visualization? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.
- A. Consistently implement business logic across reports
- B. implement machine learning to predict future values.
- C. Communicate the significance of data.
- D. Represent trends and patterns over time.
Answer: C,D
Explanation:
Data visualization is a key component in being able to gain insight into your data. It helps make big and small data easier for humans to understand. It also makes it easier to detect patterns, trends, and outliers in groups of data.
Data visualization brings data to help you find key business insights quickly and effectively.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-data-visualization
NEW QUESTION 52
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Explanation
Disadvantages of non-relational databases include: Data Consistency - non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability.
Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
NEW QUESTION 53
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. key/value
- B. columnar
- C. graph
- D. document
Answer: A
NEW QUESTION 54
......
Authentic Best resources for DP-900: https://www.dumpsactual.com/DP-900-actualtests-dumps.html
DP-900 Test Engine Practice Exam: https://drive.google.com/open?id=1xRJpa1VXWw9Aneg76dCwIP-3C0g9RauB
