Microsoft DP900 Exam Dumps|QAs Page -7

Last updated on October 16th, 2024 at 03:51 pm

Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.

Microsoft DP900 Exam Dumps – QAs 151-175

Q151. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer

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-dashboards
https://powerbi.microsoft.com/en-us/excel-and-power-bi/

Q152. DRAG DROP –
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.
Select and Place:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/machine-learning/how-to-data-ingest-adf
https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/sqldw-walkthrough

Q153. Which scenario is an example of a streaming workload?

1. sending transactions that are older than a month to an archive
2. sending transactions daily from point of sale (POS) devices
3. sending telemetry data from edge devices
4. sending cloud infrastructure metadata every 30 minutes

Q154. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer

Reference:
https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/

Q155. Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

1. a report page
2. a Microsoft PowerPoint slide
3. a visualization from a report
4. a dataflow
5. a text box

Q156. DRAG DROP –
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.
Select and Place:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse

Q157. DRAG DROP –
Match the Azure services to the appropriate requirements.
To answer, drag the appropriate service 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.
Select and Place:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs

Q158. What are two uses of data visualization? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

1. Represent trends and patterns over time
2. Implement machine learning to predict future values
3. Communicate the significance of data
4. Enforce business logic across reports

Q159. Which Azure Data Factory component provides the compute environment for activities?

1. SSIS packages
2. an integration runtime
3. a control flow
4. a pipeline

Q160. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer

Q161. What should you use to build a Microsoft Power BI paginated report?

1. Charticulator
2. Power BI Desktop
3. the Power BI service
4. Power BI Report Builder

Q162. DRAG DROP –
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.
Select and Place:

Correct Answer

Q163. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management

Q164. What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

1. denormalized data
2. heavy writes and moderate reads
3. light writes and heavy reads
4. schema defined in a database
5. schema defined when reading unstructured data from a database
6. normalized data

Q165. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer

Q166. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct Answer

Q167. What is the primary purpose of a data warehouse?

1. to provide answers to complex queries that rely on data from multiple source
2. to provide transformation services between source and target data stores
3. to provide read-only storage of relational and non-relational historical data
4. to provide storage for transactional line-of-business (LOB) applications

Q168. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer

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-dashboards
https://powerbi.microsoft.com/en-us/excel-and-power-bi/

Q169. HOTSPOT –
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

Correct Answer

Reference:
https://powerbi.microsoft.com/en-us/blog/announcing-paginated-reports-in-power-bi-general-availability/

Q170. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview
https://docs.microsoft.com/en-us/azure/data-factory/introduction

Q171. You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
-> Minimize maintenance effort.
-> Support the Database Mail and Service Broker features.
What should you include in the solution?

1. Azure SQL Database single database
2. an Azure SQL Database elastic pool
3. Azure SQL Managed instance
4. SQL Server on Azure virtual machines

Q172. You have an Azure subscription.
You need to implement approval-based, time-bound role activation.
What should you use?

1. access reviews in Azure AD
2. Azure AD Privileged Identity Management (PIM)
3. Azure AD Identity Protection
4. Conditional access in Azure AD

Q173. DRAG DROP –
A company is creating a canvas app to manage weekly status reports from users about projects.
Status reports must be created weekly. Users can enter project tasks with descriptions. Users can also add escalation requests for tasks that are late or at risk.
When a status report is submitted with an escalation request, the app must automatically send a text message to the submitter’s manager. A reminder must be sent at 8 PM on Sunday to everyone who has not yet submitted a status report for the previous week.
You need to identify the appropriate components to use in the solution.
What should you use? To answer, drag the appropriate implementation mechanisms to the correct requirements. Each implementation mechanism 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.
Select and Place:

Correct Answer

Reference:
https://docs.microsoft.com/en-us/power-apps/mobile/power-apps-mobile-notification
https://docs.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-business-rule

Q174. You have the following two tables of customer data.

Which type of data do the tables contain?

1. structured
2. non-relational
3. semi-structured
4. unstructured

Q175. What is a function of a modern data warehouse?

1. supports batch processing only
2. supports real-time and batch processing
3. provides built-in or native online analytical processing
4. stores raw data only