Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ac4s65

A data engineer needs to enforce row-level security on main.

Databricks Databricks-Certified-Data-Engineer-Associate Full Course Access
Databricks Databricks-Certified-Data-Engineer-Associate View All Questions

A data engineer needs to enforce row-level security on main.secure.events(region STRING, event_id STRING). Members of the account group all_regions must see all rows. All other users must see only rows where region = ' EU ' .

Which SQL sequence satisfies the requirement?

A.

CREATE FUNCTION main.secure.region_filter(region STRING)

RETURN IF(is_account_group_member( ' all_regions ' ), true, region = ' EU ' );

ALTER TABLE main.secure.events

SET ROW FILTER main.secure.region_filter ON (region);

B.

CREATE FUNCTION main.secure.region_filter(region STRING)

RETURN IF(is_account_group_member( ' all_regions ' ), true, region = ' EU ' );

ALTER TABLE main.secure.events

ALTER COLUMN region

SET MASK main.secure.region_filter;

C.

CREATE FUNCTION main.secure.region_filter(region STRING)

RETURN IF(is_account_group_member( ' all_regions ' ), true, region = ' EU ' );

ALTER VIEW main.secure.events

SET ROW FILTER main.secure.region_filter ON (region);

D.

CREATE FUNCTION main.secure.region_filter(region STRING)

RETURN IF(is_account_group_member( ' all_regions ' ), true, region = ' EU ' );

ALTER TABLE main.secure.events

SET ROW FILTER main.secure.region_filter USING COLUMNS (region);

Databricks-Certified-Data-Engineer-Associate PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now Databricks-Certified-Data-Engineer-Associate pdf
Get 65% Discount on All Products, Use Coupon: "ac4s65"
Next
A data engineer is building a nightly batch ETL pipeline that processes very large volumes...
A data engineer needs to find all customers who have never placed an order.
Previous