- (Topic 2)
You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale-out for a semantic model. What should you do first?

1. A. At the semantic model level, set Large dataset storage format to Off.
2. B. At the tenant level, set Create and use Metrics to Enabled.
3. C. At the semantic model level, set Large dataset storage format to On.
4. D. At the tenant level, set Data Activator to Enabled.

Correct Answer: C
To enable scale-out for a semantic model, you should first set Large dataset storage format to On (C) at the semantic model level. This configuration is necessary to handle larger datasets effectively in a scaled-out environment. References = Guidance on configuring large dataset storage formats for scale-out is available in the Power BI documentation.

- (Topic 2)
You have source data in a folder on a local computer.
You need to create a solution that will use Fabric to populate a data store. The solution must meet the following requirements:
• Support the use of dataflows to load and append data to the data store.
• Ensure that Delta tables are V-Order optimized and compacted automatically. Which type of data store should you use?

1. A. a lakehouse
2. B. an Azure SQL database
3. C. a warehouse
4. D. a KQL database

Correct Answer: A
A lakehouse (A) is the type of data store you should use. It supports dataflows to load and append data and ensures that Delta tables are Z-Order optimized and compacted automatically. References = The capabilities of a lakehouse and its support for Delta tables are described in the lakehouse and Delta table documentation.

- (Topic 2)
You have a Fabric tenant that contains a workspace named Workspace^ Workspacel 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? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

1. A. From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on- premises datasets to Enabled
2. B. From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled
3. C. From the Tenant settings, select Users can edit data models in the Power Bl service.
4. D. From the Capacity settings, set XMLA Endpoint to Read Write
5. E. From the Tenant settings, set Users can create Fabric items to Enabled
6. F. From the Tenant settings, enable Publish to Web

Correct Answer: ACD
For users to create and publish custom Direct Lake semantic models using external tools, following the principle of least privilege, the actions to be included are
enabling XMLA Endpoints (A), editing data models in Power BI service (C), and setting XMLA Endpoint to Read-Write in the capacity settings (D). References = More information can be found in the Admin portal of the Power BI service documentation, detailing tenant and capacity settings.

- (Topic 2)
You have a Fabric tenant that contains a new semantic model in OneLake. You use a Fabric notebook to read the data into a Spark DataFrame.
You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.
Solution: You use the following PySpark expression: df.explain()
Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: B
The df.explain() method does not meet the goal of evaluating data to calculate statistical functions. It is used to display the physical plan that Spark will execute. References = The correct usage of the explain() function can be found in the PySpark documentation.

- (Topic 2)
You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains an unpartitioned table named Table1.
You plan to copy data to Table1 and partition the table based on a date column in the source data.
You create a Copy activity to copy the data to Table1.
You need to specify the partition column in the Destination settings of the Copy activity. What should you do first?

1. A. From the Destination tab, set Mode to Append.
2. B. From the Destination tab, select the partition column,
3. C. From the Source tab, select Enable partition discovery
4. D. From the Destination tab, set Mode to Overwrite.

Correct Answer: B
Before specifying the partition column in the Destination settings of the Copy activity, you should set Mode to Append (A). This will allow the Copy activity to add data to the table while taking the partition column into account. References = The configuration options for Copy activities and partitioning in Azure Data Factory, which are applicable to Fabric dataflows, are outlined in the official Azure Data Factory documentation.