Online Access Free 1z0-1177-26 Exam Questions

A finance report must display a summary chart, a pivot table, and detailed transactional data within the same formatted report. Which Oracle Analytics Publisher capability supports this requirement?

• A.Dashboard Prompt
• B.Repository Variables
• C.Multiple layout components within a single report
• D.Data Gateway

Which two statements are true about the Presentation Catalog?

• A.You can share items in My Folders with other users
• B.You must store different object types in separate folders to prevent catalog corruption
• C.Catalog items cannot be copied between folders
• D.You can assign ownership of items you create to other users
• E.You can set catalog items to Read-Only
• F.Catalog objects cannot be archived

A database developer has created the PL/SQL function for a VPD policy and needs to complete the database- side security setup. Which two actions should be performed?

• A.Turn off proxy authentication on the Publisher data source
• B.Apply the VPD policy to the target table
• C.Assign a role to a catalog folder as the row-level security policy
• D.Restart the database after creating the policy
• E.Verify that the policy works in the database by using a SQL tool such as Oracle SQL Developer
• F.Create separate report definitions for SMITH and CLARK

A report designer needs to create interactive prompts in an Oracle Analytics Publisher (OAP) report to allow users to filter by sales region and a specific date. Which two parameter types would be most suitable?

• A.Date
• B.List of Values (LOV)
• C.XML
• D.Boolean
• E.Expression

A scheduled report job uses a schedule trigger. The SQL query in the trigger returns no data when the job is scheduled to run. What is the result?

• A.The job is skipped
• B.The job switches to a bursting job
• C.The job runs only after the next recurring schedule
• D.The job runs and produces output with warnings
• E.The job is deleted from the Manage Report Jobs page