ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to Exam

Exam DP-700 topic 1 question 14 discussion

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

You have a Fabric workspace that contains a Real-Time Intelligence solution and an eventhouse.
Users report that from OneLake file explorer, they cannot see the data from the eventhouse.
You enable OneLake availability for the eventhouse.
What will be copied to OneLake?

  • A. only data added to new databases that are added to the eventhouse
  • B. only the existing data in the eventhouse
  • C. no data
  • D. both new data and existing data in the eventhouse
  • E. only new data added to the eventhouse
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by Tuki93 at Dec. 8, 2024, 4:19 p.m.

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
Submit Cancel
Tuki93
Highly Voted 5 months, 1 week ago
Selected Answer: E
- Existing tables aren't affected. New tables are made available in OneLake. https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-house-onelake-availability#how-it-works
upvoted 15 times
toniteo
2 months, 3 weeks ago
agreed with answer E after reading and evaluating the article carefully.
upvoted 1 times
...
...
IshtarSQL
Highly Voted 5 months, 1 week ago
Selected Answer: E
When you enable OneLake availability for an eventhouse in Microsoft Fabric, only new data ingested into the eventhouse will be synced and made available in OneLake.
upvoted 7 times
...
AnetaK
Most Recent 2 weeks, 4 days ago
Selected Answer: D
This is what chatbot said: "When you enable OneLake availability for the eventhouse, option D is correct: both new data and existing data in the eventhouse will be copied to OneLake. This ensures that users can access all the data from the eventhouse through OneLake file explorer."
upvoted 1 times
...
zxc01
1 month, 2 weeks ago
Selected Answer: E
We can enable it on both database and table levels. I think Microsoft just want to ask for default settings with them. on database level, default option is "Apply to existing tables" which will map all tables to Onelake but don't include any old data. same issue when we try it on table level though UI.
upvoted 1 times
...
CMDev
1 month, 3 weeks ago
Selected Answer: D
The correct answer is: D. both new data and existing data in the eventhouse When you enable OneLake availability for an eventhouse, you have the option to apply this setting to existing tables by selecting the "Apply to existing tables" option. This means that both new data and existing data will be available in OneLake. As stated in the article: "When turning on the feature, you can also choose to apply this option to existing tables by selecting the Apply to existing tables option, to include historic backfill." This explains why both new and existing data will be copied to OneLake. Check this link: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-house-onelake-availability#how-it-works
upvoted 4 times
CMDev
1 month, 3 weeks ago
When you enable OneLake availability for an eventhouse, you have the option to apply this setting to existing tables, which includes the data already present in those tables. This means that both new data (data added after enabling OneLake availability) and existing data (data that was already in the eventhouse at the time of enabling OneLake availability) will be available in OneLake. As the article states: "When turning on the feature, you can also choose to apply this option to existing tables by selecting the Apply to existing tables option, to include historic backfill." This indicates that enabling OneLake availability can include the historical data, meaning the existing data, in addition to any new data added afterwards.
upvoted 1 times
...
...
Kiket2ride
1 month, 3 weeks ago
Selected Answer: D
I think it used to be that only new data was available but documentation now says otherwise: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-house-onelake-availability#how-it-works When you turn availability back on, all data is made available in OneLake, including historic backfill. I vote for D then
upvoted 4 times
...
DarkDerf
2 months, 2 weeks ago
Selected Answer: E
If we strictly follow the documentation's explanation that only new tables are made available in OneLake, then your choice E. only new data added to the eventhouse is the most precise answer. ✅ Final Answer: E. only new data added to the eventhouse
upvoted 2 times
...
DarkDerf
2 months, 4 weeks ago
Selected Answer: D
The correct answer is: D. both new data and existing data in the eventhouse Explanation: When you enable OneLake availability for an eventhouse in Microsoft Fabric, all existing data within the eventhouse, along with any new data added afterward, is copied to OneLake. This ensures that users can access both past and future data through OneLake file explorer. This means that enabling OneLake availability makes the entire dataset in the eventhouse visible in OneLake, not just new data moving forward.
upvoted 2 times
...
henryphchan
2 months, 4 weeks ago
Selected Answer: E
Only new data will be loaded to OneLake
upvoted 3 times
...
Anushareddysri
3 months ago
Selected Answer: D
As per the Microsoft document you can enable onelake along with an option of existing tables as well. Here is the reference document. https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-house-onelake-availability
upvoted 2 times
henryphchan
2 months, 4 weeks ago
It applies to existing tables but not exist data, so I vote for E
upvoted 1 times
...
...
h2o_molecule
3 months, 1 week ago
Selected Answer: D
You can turn on OneLake availability at the database or table level. When enabled at the database level, all new tables and their data are made available in OneLake. When turning on the feature, you can also choose to apply this option to existing tables by selecting the Apply to existing tables option.
upvoted 3 times
...
e0f0ce6
3 months, 1 week ago
Selected Answer: E
I think E is correct: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-house-onelake-availability
upvoted 2 times
...
QAZdbarhate12345678
5 months ago
Selected Answer: D
The correct answer is: D. both new data and existing data in the eventhouse When you enable OneLake availability for the eventhouse, both the existing data and any new data added to the eventhouse will be copied to OneLake. This allows users to access the eventhouse data from OneLake file explorer.
upvoted 5 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago