AB-100: Agentic AI Business Solutions Architect › Practice Assessment for Exam AB-100: Agentic AI Business Solutions Architect › Question #26632
Multiple Choice Moderate

Q

A company combines Microsoft Dataverse data with SAP data in a single Microsoft Power BI dataset. The dataset must enforce per-user data access and be reusable by other AI solutions.

Users are added frequently, and the solution must avoid creating new row-level security (RLS) roles for each user.

You need to recommend an approach that meets the requirements.

What should you recommend?

ID: #26632 Practice Assessment for Exam AB-100: Agentic AI Business Solutions Architect 3 views
Question Info
#26632Q ID
ModerateDifficulty
Practice Assessment for Exam AB-100: Agentic AI Business Solutions ArchitectTopic
Start Quiz on This Topic
 Your Answer

Select All That Apply

Tick every correct option, then press Check Answer.

  • A Apply RLS rules only on fact tables. ✔ ✖
  • B Create a separate dataset for each business unit. ✔ ✖
  • C Create multiple static RLS roles and use the USERNAME() function in role filters. ✔ ✖
  • D Create a small number of RLS roles by using dynamic rules and the USERPRINCIPALNAME() function in role filters. ✔ ✖
Correct Answer

Explanation

Objective:

1.1 Analyze requirements for AI-powered business solutions

What This Item Tests:

Organize business solution data to be available for other AI systems

Additional Reading:

Apply good modeling practices

Power Platform concepts

How Dynamics 365 and Power Platform support your data estate

Rationale:

Dynamic RLS that uses USERPRINCIPALNAME() allows per-user access to be enforced through data-driven rules, which scales as users are added without requiring new roles. Static roles increase administrative overhead, filtering only fact tables does not address user-specific access control, and creating separate datasets reduces reuse and complicates governance for downstream AI solutions.

 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

A company has two production agents: One is built in Microsoft Copilot Studio, and the other is built in Microsoft Foundry. Both agents send telemetry to the same Azure Monitor Application Insights resource. U... A company has a multi-agent solution built in Microsoft Foundry. The solution grounds responses in internal HR documents and uses agent tools to call internal and external systems. Security testing shows that ... A company uses an agent built in Microsoft Foundry that retrieves internal content and invokes tools to perform actions. Security testing shows that prompt injection attacks can trigger unauthorized tool calls... A company has a Microsoft Copilot Studio agent grounded in a Microsoft SharePoint Online knowledge source. After adding new knowledge documents and updating the agent instructions, responses to the same user q... A company has a customer service agent built in Microsoft Foundry that calls an Azure OpenAI model and a knowledge API. Telemetry and online evaluation scores are sent to Azure Monitor Application Insights. Us... A company has a Microsoft Copilot Studio agent that performs browser-based automation against a legacy web app by using the Computer Use tool. When multiple users trigger the automation simultaneously, some ru... A company uses Microsoft Dynamics 365 Sales with a custom model-driven app that sellers use instead of the standard Sales Hub app. The sellers cannot open the Copilot immersive experience from the custom app n... A company uses Microsoft Dynamics 365 Supply Chain Management with customizations developed in Microsoft Visual Studio and stored in Azure Repos. Deployable packages are published to the Lifecycle Services (LCS... A company uses a Microsoft Copilot Studio agent across multiple Dynamics 365 apps to generate natural language responses. The agent supports English and Spanish and relies on Dynamics 365 data and business logi... A company has a Microsoft Copilot Studio agent that uses an AI approval stage to approve or reject employee expense reimbursement requests. Identical requests sometimes produce different decisions, and the log...