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 6 months, 4 weeks 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 17 times
Sr18
1 month, 1 week ago
As per documentation, now you have option to select historical backfill. So I think question's verbiage is incomplete now. Answer D : Seems more right answer now, because you have this option and may be it was selected while making the One Lake Availability.
upvoted 3 times
exnaniantwort
3 weeks, 3 days ago
It is still E. 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, to include historic backfill>>>. Turning on at the table level makes only that table and its data available in OneLake Only if the question mentions explicitly together the "Apply to existing tables option", otherwise, only "enable OneLake availability" does not do the backfill.
upvoted 1 times
...
...
toniteo
4 months, 1 week ago
agreed with answer E after reading and evaluating the article carefully.
upvoted 1 times
...
...
IshtarSQL
Highly Voted 6 months, 3 weeks 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 8 times
...
Thanos29
Most Recent 1 week, 1 day ago
Selected Answer: E
E is Correct. Question says : User cannot see the data from the eventhouse. If OneLake Availablilty is enavled, only New Tables are made available. Also no mention of whether the option : Apply to exisiting Table is checked, and also Users cannot see data, meaning Users cannot see Old data, as only new Tables appear https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-house-onelake-availability#how-it-works
upvoted 1 times
...
VenkataPhaniPavanKumar
1 week, 5 days ago
Selected Answer: D
Best thing to check the answers is to use Microsoft Copilot Copilot says When you enable OneLake availability for an eventhouse in Microsoft Fabric, the platform copies both existing and newly ingested data into the OneLake-backed file storage. This ensures that users can access all relevant telemetry data—past and present—through tools like the OneLake file explorer or other storage-compatible interfaces. This is particularly helpful when enabling lake-centric analytics or blending real-time and historical data into broader lakehouse or warehouse solutions.
upvoted 1 times
...
mvg100
3 weeks ago
Selected Answer: D
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 Also chatbot says: When you enable OneLake availability for an eventhouse in Microsoft Fabric: Existing data in the eventhouse becomes immediately available in OneLake. New data added to the eventhouse is also automatically streamed and accessible via OneLake moving forward. This allows users to access both historical and real-time streaming data through OneLake interfaces, including the OneLake file explorer.
upvoted 1 times
...
Jay63002
3 weeks, 2 days 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, to include historic backfill. Turning on at the table level makes only that table and its data available in OneLake. The Data retention policy of your KQL database is also applied to the data in OneLake. Data removed from your KQL database at the end of the retention period is also removed from OneLake. If you turn off OneLake availability, data is soft deleted from OneLake.
upvoted 1 times
...
AnetaK
2 months, 1 week 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
3 months, 1 week 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
3 months, 1 week 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 5 times
CMDev
3 months, 1 week 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
3 months, 1 week 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
4 months, 1 week 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
4 months, 2 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
4 months, 2 weeks ago
Selected Answer: E
Only new data will be loaded to OneLake
upvoted 3 times
...
Anushareddysri
4 months, 2 weeks 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
4 months, 2 weeks ago
It applies to existing tables but not exist data, so I vote for E
upvoted 1 times
Sr18
1 month, 1 week ago
Historial Backfill means data + tables : Read properly "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, to include historic backfill. Turning on at the table level makes only that table and its data available in OneLake."
upvoted 1 times
...
...
...
h2o_molecule
4 months, 4 weeks 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
5 months 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
6 months, 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 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