Answer-first summary for fast verification
Answer: Create a VIEW from the original table
Creating a view from the original table allows banks to query the latest conversion rates without direct access to the original table. This method is efficient as it eliminates the need for manual data distribution and ensures that banks always have access to the most current rates. Views in Databricks provide a dynamic way to share data without duplicating it, making them an ideal solution for this scenario.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A delta table named currency_conversion is updated daily at midnight by the central banking system. This table includes conversion rates for all currencies in the banking system. Banks need to access the most recent conversion rates whenever users perform transactions. What is the most efficient way for the central banking system to share these rates with all banks without granting direct access to the original table?
A
Manually send the data to all the banks at midnight
B
Create a SHALLOW CLONE of the original table
C
Create a VIEW from the original table
D
Create a DEEP CLONE of the original table
E
Create a new table using the CTAS command
No comments yet.