SOL-C01 · Question #230
SOL-C01 Question #230: Real Exam Question with Answer & Explanation
The correct answer is C: Create a secure view 'SECURE SALES DATA_EAST filtered for 'East' region. create a share for. Using a secure view is the most efficient and secure approach. Secure views ensure that the filtering logic is encapsulated and not exposed to the consumer, and consumers can't circumvent the filtering. Materialized views require storage and maintenance, making it less efficient.
Question
You are a data provider and want to share a table 'SALES DATA with two different consumer accounts, and 'ACCOUNT B' , using direct shares. However, you want to provide a filtered view of the data to (only sales from region 'East') and the full table to 'ACCOUNT Which of the following approaches is the MOST efficient and secure way to accomplish this?
Options
- ACreate a share for containing the 'SALES_DATX table and then create another share for
- BCreate a view 'SALES DATA EAST filtered for 'East' region. Create a share for 'ACCOUNT_X
- CCreate a secure view 'SECURE SALES DATA_EAST filtered for 'East' region. create a share for
- DCreate a materialized view `MAT SALES DATA_EAST filtered for 'East' region. create a share for
- EShare the entire table with both accounts and implement row-level security policies on the table,
Explanation
Using a secure view is the most efficient and secure approach. Secure views ensure that the filtering logic is encapsulated and not exposed to the consumer, and consumers can't circumvent the filtering. Materialized views require storage and maintenance, making it less efficient. Sharing the entire table with row-level security is valid, but more complex to manage for just this scenario. Sharing the base table directly to Account A is wrong since you only want to share east region sales and should not create extra shares
Topics
Community Discussion
No community discussion yet for this question.