nerdexam
Microsoft

DP-500 · Question #127

You need to optimize the workflow for the creation of reports and the adjustment of tables by the enterprise analytics team. What should you do?

The correct answer is B. Create a linked service in workspace1. To optimize the workflow for report creation and table adjustments for an enterprise analytics team, a linked service should be created in the relevant workspace to provide a standardized, secure, and manageable connection to data sources.

Implement and manage a data analytics environment

Question

You need to optimize the workflow for the creation of reports and the adjustment of tables by the enterprise analytics team. What should you do?

Options

  • AAdd a tenant-level storage connection to Power BI.
  • BCreate a linked service in workspace1.
  • CCreate an integration runtime in workspace1.
  • DFrom the Tenant setting, enable Use global search for Power BI.

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    77% (17)
  • C
    14% (3)
  • D
    5% (1)

Why each option

To optimize the workflow for report creation and table adjustments for an enterprise analytics team, a linked service should be created in the relevant workspace to provide a standardized, secure, and manageable connection to data sources.

AAdd a tenant-level storage connection to Power BI.

Adding a tenant-level storage connection is not a standard Power BI feature and does not directly optimize the workflow for report creation or table adjustments for an analytics team.

BCreate a linked service in workspace1.Correct

Creating a linked service in a workspace, especially within an Azure Synapse Analytics or Azure Data Factory context, allows for defining connection information to external data sources. This centralizes the connection details, making it easier for an enterprise analytics team to access and manage data consistently for report creation and table adjustments without reconfiguring connections for each dataset or report.

CCreate an integration runtime in workspace1.

An integration runtime is used for data integration tasks, often for moving or transforming data, and while it's part of data pipelines, creating one directly in 'workspace1' doesn't optimize the report creation and table adjustment workflow itself.

DFrom the Tenant setting, enable Use global search for Power BI.

Enabling global search for Power BI improves content discoverability but does not optimize the workflow for report creation or table adjustments by streamlining data access or model development.

Concept tested: Centralizing data source connections for analytics teams

Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/data-integration/linked-services

Topics

#Linked Service#Azure Synapse Analytics#Data Integration#Workflow Optimization

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice