exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 81 discussion

Actual exam question from Microsoft's DP-600
Question #: 81
Topic #: 1
[All DP-600 Questions]

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?

  • A. the SQL analytics endpoint settings
  • B. the semantic model settings
  • C. the workspace settings
  • D. the Lakehouse1 settings
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
gfors
Highly Voted 11 months, 1 week ago
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
upvoted 25 times
ManuelG00
9 months ago
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."
upvoted 4 times
4f3a33d
4 months, 2 weeks ago
Just curious, where you can do this in the workspace settings, I cannot find it here, but I can find it under the SQL endpoint.
upvoted 1 times
...
Priyanka007
8 months, 3 weeks ago
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.
upvoted 3 times
...
...
...
2fe10ed
Highly Voted 10 months, 1 week ago
Selected Answer: A
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.
upvoted 13 times
2fe10ed
10 months, 1 week ago
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.
upvoted 4 times
...
...
Jane5
Most Recent 3 days, 16 hours ago
Selected Answer: A
i have checked on Fabric
upvoted 1 times
...
aks2304
1 week ago
Selected Answer: B
The correct answer is: B. the semantic model settings Explanation: To prevent new tables added to a lakehouse (e.g., Lakehouse1) from being automatically included in the default semantic model, you need to configure the semantic model settings. The semantic model is responsible for defining how data is exposed for reporting and analytics. By adjusting these settings, you can control whether new tables are automatically added to the model or require manual inclusion.
upvoted 1 times
...
goldy29
1 month, 1 week ago
Selected Answer: B
you need to modify the semantic model settings for the lake house. This allows you to control whether new tables are automatically included in the model.
upvoted 1 times
...
MultiCloudIronMan
3 months, 1 week ago
Selected Answer: A
Based on the information from the Microsoft Fabric documentation, it appears that configuring the SQL analytics endpoint settings is indeed the correct approach to prevent new tables added to Lakehouse1 from being automatically included in the default semantic model
upvoted 2 times
...
4f3a33d
4 months, 3 weeks ago
Selected Answer: A
Tested in Fabric; go to > SQL Endpoint > ... > Settings > Default Power BI semantic model > Sync the default Power BI semantic model > On | Off Add objects from the lakehouse to the default Power BI semantic model. Also, update the model with any new objects added to the lakehouse. You can use this model to build reports faster with lakehouse data.
upvoted 5 times
...
Ahmadpbi
7 months, 3 weeks ago
A is correct .. SQL analytics endpoint settings.. I checked this option in a workspace I have. It seems off by default. It shows like below: Sync the default Power BI semantic model Off Add objects from the lakehouse to the default Power BI semantic model. Also, update the model with any new objects added to the lakehouse. You can use this model to build reports faster with lakehouse data.
upvoted 1 times
...
Pegooli
7 months, 4 weeks ago
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.
upvoted 2 times
...
6d1de25
8 months ago
Selected Answer: B
B is correct
upvoted 3 times
...
b6daab0
8 months, 4 weeks ago
Tested in Fabric. It's A.
upvoted 1 times
...
Evincible
9 months, 1 week ago
Selected Answer: B
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.
upvoted 7 times
DarioReymago
9 months ago
I'm not sure, you lock the semantic model but you can create new tables in Lakehouse. With option A you'll lock both
upvoted 1 times
...
...
[Removed]
9 months, 2 weeks ago
You should configure B. the semantic model settings to prevent new tables from being automatically added to the default semantic model of Lakehouse1
upvoted 3 times
...
PiyushT
9 months, 2 weeks ago
Selected Answer: B
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
upvoted 3 times
...
282b85d
9 months, 2 weeks ago
Selected Answer: B
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.
upvoted 3 times
...
00e2928
10 months, 1 week ago
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.
upvoted 3 times
...
dp600
10 months, 2 weeks ago
Selected Answer: A
"Manually enable the Sync the default Power BI semantic model setting for each Warehouse or SQL analytics endpoint in the workspace"
upvoted 3 times
282b85d
9 months ago
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)
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago