👉Get Full PDF
| Question.1 You have a Fabric tenant. You plan to create a Fabric notebook that will use Spark DataFrames to generate Microsoft Power BI visuals. You run the following code.  For each of the following statements, select Yes if the statement is true. Otherwise, select No.  |
1. Click here to View Answer
Answer is No-Yes-Yes
| Question.2 You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of least privilege. Which three actions in the Fabric Admin portal should you include in the recommendation?From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel (A) (A) with on-premises datasets to Enabled. (B) From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled. (C) From the Tenant settings, select Users can edit data model in the Power BI service. (D) From the Capacity settings, set XMLA Endpoint to Read Write. (E) From the Tenant settings, set Users can create Fabric items to Enabled. (F) From the Tenant settings, enable Publish to Web. |
2. Click here to View Answer
Answers are;
A. From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises datasets to Enabled.
D. From the Capacity settings, set XMLA Endpoint to Read Write.
E. From the Tenant settings, set Users can create Fabric items to Enabled.
D – The XMLA endpoint needs to be enabled from the capacity settings as it is crucial for allowing external tools to only read, but also, publish and manage custom Direct Lake semantic models.
A – Again from Tenant settings, we need to enable XMLA endpoints ; This is to ensure that external tools interact with the data models as and when necessary within the tenant’s workspace ; The analyze in excel is just complimentary to this setting in Fabric and is irrelevant
E – Sets appropriate permissions to users by allowing them to edit models and publish them as when required abiding by the principle of least privilege.
Reference:
https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#security
| Question.3 You plan to deploy Microsoft Power BI items by using Fabric deployment pipelines. You have a deployment pipeline that contains three stages named Development, Test, and Production. A workspace is assigned to each stage. You need to provide Power BI developers with access to the pipeline. The solution must meet the following requirements: – Ensure that the developers can deploy items to the workspaces for Development and Test. – Prevent the developers from deploying items to the workspace for Production. – Follow the principle of least privilege. Which three levels of access should you assign to the developers? (A) Build permission to the production semantic models (B) Admin access to the deployment pipeline (C) Viewer access to the Development and Test workspaces (D) Viewer access to the Production workspace (E) Contributor access to the Development and Test workspaces (F) Contributor access to the Production workspace |
3. Click here to View Answer
Answers are;
B. Admin access to the deployment pipeline D. Viewer access to the Production workspace E. Contributor access to the Development and Test workspaces
If you have contributer access to the workspace, then you don’t need to assign an additional viewer access (C) to the developers.
B – Admin access is provided to the developers for the developers to manage the deployent process across the various stages (in this case Dev and Test). This is a basic necessary.
D – To restrict the access on the Production workspace, provide an overriding Viewer access which lets the developers only view the Production environment and not make any changes.
E – This is to provide the developers with the permissions to develop, edit and update the Dev and Test pipelines.
| Question.4 You have a Fabric tenant that contains a warehouse. The warehouse uses row-level security (RLS). You create a Direct Lake semantic model that uses the Delta tables and RLS of the warehouse. When users interact with a report built from the model, which mode will be used by the DAX queries? (A) DirectQuery (B) Dual (C) Direct Lake (D) Import |
4. Click here to View Answer
Answer is (A) DirectQuery
Row-level security only applies to queries on a Warehouse or SQL analytics endpoint in Fabric. Power BI queries on a warehouse in Direct Lake mode will fall back to Direct Query mode to abide by row-level security.
Reference:
https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security
| Question.5 You have a Fabric tenant that contains a semantic model. The model uses Direct Lake mode. You suspect that some DAX queries load unnecessary columns into memory. You need to identify the frequently used columns that are loaded into memory. What are two ways to achieve the goal? (A) Use the Analyze in Excel feature. (B) Use the Vertipaq Analyzer tool. (C) Query the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic management view (DMV). (D) Query the DISCOVER_MEMORYGRANT dynamic management view (DMV). |
5. Click here to View Answer
Answers are;
B. Use the Vertipaq Analyzer tool.
C. Query the $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS dynamic management view (DMV).
A. “Use the Analyze in Excel feature.” It’s more about data exploration and visualization.
D. “D. Query the DISCOVER_MEMORYGRANT dynamic management view (DMV).” Provides information about memory grants for queries