Latest Microsoft DP-900 PDF and Dumps (2022) Free Exam Questions Answers
Pass Your Microsoft Certified: Azure Data Fundamentals DP-900 Exam on Jan 28, 2022 with 169 Questions
Explain Analytics Workloads on Azure: 25-30%
- Explain Analytics Workloads: The applicants should be able to explain transactional workloads, data warehousing workloads, and when data warehouse solutions are needed. This subtopic also covers their skills and knowledge associated with the differences between analytics and a transactional workload as well as the differences between real-time and batch.
- Explain Data Visualization within Microsoft Power BI: You need to have competence in explaining the function of dashboards, interactive reports, and paginated reporting, as well as the workflow within Power BI.
- Explain Data Processing & Ingestion on Azure: The learners should be able to explain the fundamental practices for data loading, Azure Data Factory components, and data processing options.
- Explain Modern Data Warehouse Components: The test takers should understand Azure data services for the latest data warehousing, including Azure Synapse Analytics, Azure HDInsight, Azure Data Lake, and Azure Databricks, as well as explainin the workload and architecture for modern data warehousing.
NEW QUESTION 59
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. file
- B. queue
- C. table
- D. blob
Answer: D
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-files
NEW QUESTION 60
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution. (Choose three.) NOTE: Each correct selection is worth one point.
- A. a dataflow
- B. a Microsoft PowerPoint slide
- C. a visualization from a report
- D. a report page
- E. a text box
Answer: C,D,E
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-dashboards
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget
NEW QUESTION 61
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 62
What should you use to build a Microsoft Power BI paginated report?
- A. Charticulator
- B. Power BI Desktop
- C. the Power BI service
- D. Power BI report Builder
Answer: B
NEW QUESTION 63
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?
- A. key/value
- B. graph
- C. document
- D. columnar
Answer: D
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation/Reference:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores
NEW QUESTION 64
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 65
You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount day. The output must produce the following results.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than 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:
NEW QUESTION 66
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 67
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 68
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 69
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://azure.microsoft.com/en-us/pricing/details/synapse-analytics/
NEW QUESTION 70
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
NEW QUESTION 71
What are two characteristics of real-time data processing? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.
- A. Data is processed as it is created.
- B. Data is processed periodically
- C. High latency acceptable
- D. Low latency is expected
Answer: A,D
Explanation:
Explanation
Real time processing deals with streams of data that are captured in real-time and processed with minimal latency to generate real-time (or near-real-time) reports or automated responses.
NEW QUESTION 72
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
The API determines the type of account to create. Azure Cosmos DB provides five APIs: Core (SQL) and MongoDB for document data, Gremlin for graph data, Azure Table, and Cassandra. Currently, you must create a separate account for each API.
Box 2: Yes
Azure Cosmos DB uses partitioning to scale individual containers in a database to meet the performance needs of your application. In partitioning, the items in a container are divided into distinct subsets called logical partitions. Logical partitions are formed based on the value of a partition key that is associated with each item in a container.
Box 3: No
Logical partitions are formed based on the value of a partition key that is associated with each item in a container.
NEW QUESTION 73
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. file
- B. queue
- C. table
- D. blob
Answer: A
Explanation:
Section: Describe how to work with non-relational data on Azure
Explanation:
Azure file shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. Azure file shares can also be cached on Windows Servers with Azure File Sync for fast access near where the data is being used.
Reference:
https://azure.microsoft.com/en-us/services/storage/files/
NEW QUESTION 74
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 D3
- D. Azure HCMmtghi
Answer: A
Explanation:
Azure SQL Database is relational database and a managed service.
Reference:
https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment
NEW QUESTION 75
To complete the sentence, select the appropriate option in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel-processing-mpp-architecture
NEW QUESTION 76
For each of the following statements, select yes if he statement is true, Otherwise select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 77
......
DP-900 Dumps for Microsoft Certified: Azure Data Fundamentals Certified Exam Questions and Answer: https://www.prep4away.com/Microsoft-certification/braindumps.DP-900.ete.file.html
DP-900 Free Exam Study Guide! (Updated 169 Questions): https://drive.google.com/open?id=1rthJOCzFt4_SPioSC9rue1ulPyScJYXc