You have a Fabric tenant that contains a lakehouse named Lakehouse1.
You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse.
What should you configure?
You have a Fabric tenant that contains a lakehouse named Lakehouse1.
You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse.
What should you configure?
To prevent new tables added to a lakehouse from being automatically included in the default semantic model, you need to adjust the semantic model settings. This setting dictates whether new tables are automatically incorporated into the semantic model, and modifying this setting allows you to have control over which tables are included, ensuring that new additions are not automatically included without manual intervention.
Read the question carefully: "You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse." The answer is in the article https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models but "Sync the default Power BI semantic model". The correct answer is there A
So, pay attention. The Answer is C "Previously we auto added all tables and views in the Warehouse to the default Power BI semantic model. Based on feedback, we have modified the default behavior to not automatically add tables and views to the default Power BI semantic model. This change will ensure the background sync will not get triggered. This will also disable some actions like "New Measure", "Create Report", "Analyze in Excel". If you want to change this default behavior, you can: Manually enable the Sync the default Power BI semantic model setting for each Warehouse or SQL analytics endpoint in the workspace. This will restart the background sync that will incur some consumption costs."
In your workspace you will have the Warehouse or SQL analytics endpoint and that is where you need to do the setting. So, I will go with A. If you go with C it is like saying you do the setting in that page but when you say A it points out where exactly in the page you need to do that setting.
I've confirmed it on Fabric, and the correct answer is A. To change this setting, you need to open the settings of either the SQL analytics endpoint object of a Lakehouse or the warehouse object of a warehouse.
A small detail: Fabric has since changed this setting, and now it comes off by default. If anything you would need to turn it on, but the place where you do that is still the same.
A - check here: https://learn.microsoft.com/en-us/fabric/data-warehouse/default-power-bi-semantic-model#add-or-remove-objects-to-the-default-power-bi-semantic-model
To prevent new tables added to Lakehouse1 from being automatically added to the default semantic model of the lakehouse, you need to configure the semantic model settings. The semantic model in a Fabric lakehouse represents the logical data model and defines how the data in the lakehouse should be interpreted and used. By default, when new tables are added to the lakehouse, they may be automatically added to the semantic model as well. To prevent this behavior and maintain more control over the contents of the semantic model, you need to adjust the semantic model settings. This allows you to configure the lakehouse to not automatically include new tables in the semantic model, requiring you to manually add them if desired.
I'm not sure, you lock the semantic model but you can create new tables in Lakehouse. With option A you'll lock both
it should be SQL end point setting.
A is correct, there is "Sync the default Power BI semantic model" setting in sql endpoint.
Open the lakehouse in Microsoft Fabric. Navigate to the semantic model section. Open the settings for the default semantic model. Look for an option that controls the automatic inclusion of new tables. This might be labeled as "auto-update" or something similar. Disable or adjust this setting to prevent automatic inclusion
Explanation: In Microsoft Fabric, the default behavior is to include new tables in the semantic model automatically. To control this behavior and ensure that new tables are not added automatically, you need to adjust the settings related to the semantic model.
correct answer is B By default, the semantic model in a lakehouse is set to automatically include new tables, but you can disable this behavior by modifying the semantic model settings. Specifically, you need to navigate to the semantic model settings for the lakehouse and find the option to disable the automatic inclusion of new tables.
Correct answer is C. https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models
B is correct
You should configure B. the semantic model settings to prevent new tables from being automatically added to the default semantic model of Lakehouse1
"Manually enable the Sync the default Power BI semantic model setting for each Warehouse or SQL analytics endpoint in the workspace"
Sync the default Power BI semantic model : toggle on/off Add objects from the warehouse to the default Power BI semantic model. Also, update the model with any new objects added to the warehouse. You can use this model to build reports faster with warehouse data. (in semantic model settings)
I think you do that in the Warehouse setting, there is not a Warehouse option but since a warehouse is created when you create the Lakehouse, it should be option D https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models#sync-the-default-power-bi-semantic-model
I'm going for B it's chat GPT answer LOL Access the Lakehouse Settings: Navigate to the Lakehouse1 in your Fabric tenant. Go to the settings or properties of the Lakehouse1. Locate the Semantic Model Configuration: Find the option related to the semantic model or data modeling settings. Disable Automatic Addition: Look for a setting that mentions the automatic addition of new tables to the semantic model. Disable this setting to prevent new tables from being automatically added.
Tested in Fabric. It's A.