Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-1041

Free Oracle 1Z0-1041 Exam Braindumps (page: 2)

Page 2 of 19
PDF with 72 Questions

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?

  1. Permissions
  2. Row Level Data
  3. Table filter
  4. Data Filters

Answer(s): D

Explanation:

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.


Reference:

https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/securing-access-data.html



Oracle Analytics Cloud offers several visualization options for presenting query results. How do you explicitly invoke "best visualization" in Oracle Analytics Cloud?

  1. Select the desired data elements from the Data Elements pane and drag them onto the Best Visualization zone in the Explore pane.
  2. Drag an entire Data Set from the Data Elements pane onto the Data Visualization canvas and let the tool determine the best visualization.
  3. Select the "Best Visualization" option from the project's Canvas Settings drop-down menu.
  4. Select the desired data elements from the Data Elements pane, right-click and select "Create Best Visualization" from the drop-down menu.

Answer(s): B


Reference:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/visualizing-data-and-building-reportsoracle-analytics-cloud.pdf (39)



Which two statements are true regarding configuring filters to control visual content?

  1. Expression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data Visualization data flows.
  2. Variables may be employed in all Data Visualization filter types (that is, Range, List, Date, Expression).
  3. Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler.
  4. When the Oracle Business Intelligence Enterprise Edition repository is used as a data source, filters defined in the initialization blocks with the client administration tool are automatically inherited in Data Visualization.

Answer(s): C,D



Which two statements are true regarding the source of Oracle BI Enterprise Edition Analyses?

  1. Analyses can be created from multiple subject areas as long as at least one metric Is Included from each, and the Dimensionality Flag is enabled.
  2. Analyses can be created from multiple business models as long as they contain common, conformed dimensions.
  3. Analyses cannot be created from multiple subject areas even though they contain common, conformed dimensions.
  4. Analyses can be created with measures from multiple physical tables defined as sources in a single logical fact table.

Answer(s): C,D






Post your Comments and Discuss Oracle 1Z0-1041 exam prep with other Community members:

1Z0-1041 Exam Discussions & Posts