You want to create a filter that restricts access to the Fact table so that Revenue Is only visible to users assigned to a particular role. In which tab should you set this up?

The correct answer is D. Data Filters. Explanation/Reference: You can define data filters for fact tables, dimension tables, and columns that provide row-level security for data model objects. For example, you can create a filter that restricts access to the Products table so that only certain brands are visible to…

Data Modeling

Question

Options

APermissions
BRow Level Data
CTable filter
DData Filters

How the community answered

(24 responses)

A
4% (1)
B
4% (1)
C
13% (3)
D
79% (19)

Explanation

Explanation/Reference: You can define data filters for fact tables, dimension tables, and columns that provide row-level security for data model objects. For example, you can create a filter that restricts access to the Products table so that only certain brands are visible to users assigned to a particular role. https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/securing-access-data.html

Topics

#data filters#row-level security#fact table access#role-based access

Community Discussion

No community discussion yet for this question.

Full 1Z0-1041-20 Practice