Weekend Sale - Special 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 75onlydt

1z0-1177-26 Questions and Answers

Question # 6

Which type of report is an example of the bursting feature in Pixel-Perfect Reporting?

A.

Customized regional marketing reports

B.

Bar codes

C.

Interactive data exploration

D.

Ad hoc reporting

E.

Government PDF forms

Full Access
Question # 7

A report developer wants to create a formatted report without writing RTF templates or custom code. Which Oracle Analytics Publisher component should be used?

A.

Layout Editor

B.

SQL Worksheet

C.

Catalog Manager

D.

Data Gateway

Full Access
Question # 8

During production validation, users report that migrated dashboards open successfully but some analyses display "Subject Area not found." What should the administrator verify first?

A.

Browser compatibility settings

B.

The migrated semantic model and subject area mappings exist and are correctly deployed.

C.

Email delivery configuration

D.

Runtime Configuration settings

Full Access
Question # 9

An organization wants a dashboard page that displays executive KPIs, detailed trend charts, and supporting tables together in a single layout. Which dashboard capability should be used?

A.

Compound Layout

B.

Guided Navigation

C.

Briefing Book

D.

Action Link

Full Access
Question # 10

A BI Publisher developer needs to create a reusable report template that contains corporate branding, reusable formatting, and standard legal disclaimers for multiple reports. What is the recommended approach?

A.

Duplicate the formatting in every RTF template.

B.

Build separate layouts for every report.

C.

Create a subtemplate and reference it from report templates.

D.

Embed branding directly in each SQL data model.

Full Access
Question # 11

A company wants regional managers to access only their own dashboard while using a common dashboard design. Which Oracle Analytics feature provides the most maintainable solution?

A.

Duplicate the dashboard for every region.

B.

Create separate subject areas for each manager.

C.

Export dashboards as PDF files.

D.

Use dashboard prompts together with appropriate security filtering.

Full Access
Question # 12

A team exported a catalog translation file, translated the strings, and now needs Oracle Analytics Publisher to display the translated catalog strings to users. Which two actions are required?

A.

Change the source-language attribute to the target language before upload

B.

Import the translated XLIFF file for the same Catalog folder from which it was exported

C.

Have users select the target language as their UI Language in preferences

D.

Upload the translated file to Template Manager as a localized RTF template

E.

Regenerate the report layout in Template Builder before importing the catalog file

F.

Restart the BI Presentation Server

Full Access
Question # 13

A report author needs a layout component that provides multidimensional data in tabular form. The component must support multiple measures and dimensions at all levels. Which layout component should the author insert?

A.

Text Item

B.

Layout Grid

C.

Gauge

D.

Pivot Table

E.

List

Full Access
Question # 14

Which Oracle Analytics Cloud capability best differentiates governed analytics from purely self-service analytics?

A.

Every user maintains independent business definitions.

B.

Users can only analyze spreadsheet data.

C.

All reports must be created by administrators.

D.

Shared metadata and centrally managed business definitions improve consistency.

Full Access
Question # 15

A company wants Oracle Analytics Publisher reports to be available directly within Oracle Analytics Cloud dashboards. Which capability enables this integration?

A.

Export reports as Excel files

B.

Copy report output into dashboards manually

C.

Publish reports through FTP

D.

Integrate Publisher catalog content with Oracle Analytics Cloud

Full Access
Question # 16

A development team has completed new dashboards and BI Publisher reports. Before deploying them to production, they need a repeatable migration process that preserves dependencies and configuration. Which approach is recommended?

A.

Export and import content using BAR files.

B.

Copy catalog folders manually.

C.

Recreate all dashboards directly in production.

D.

Export only report layouts as PDF files.

Full Access
Question # 17

A dashboard should display an inventory analysis only when the logged-in user belongs to the Warehouse Manager role. Which feature should be implemented?

A.

Dashboard Prompt

B.

KPI Watchlist

C.

Analysis Filter

D.

Guided Navigation

Full Access
Question # 18

A reporting analyst creates a dashboard that includes multiple analyses sharing the same filter criteria. Users complain that updating each analysis separately is difficult. Which design approach improves maintainability?

A.

Use a shared Dashboard Prompt with Presentation Variables.

B.

Create independent prompts for every analysis.

C.

Replace filters with conditional formatting.

D.

Export each analysis as a separate report.

Full Access
Question # 19

A multinational organization wants reports to automatically display translated labels based on each user's selected language. Which Oracle Analytics Publisher feature supports this requirement?

A.

Report Bursting

B.

Repository Variables

C.

Dashboard Prompts

D.

XLIFF translation files

Full Access
Question # 20

Which two statements describe form fields in Template Builder?

A.

Form fields can reference data fields from the report definition

B.

Form fields can embed instructions that control how data fields are laid out in a table

C.

Form fields replace the need for XML sample data in offline mode

D.

Form fields are used only for native Microsoft Word charts

E.

Form fields are available only in Excel templates

F.

Form fields cannot contain BI Publisher commands

Full Access
Question # 21

Which Oracle Analytics Cloud feature allows analysts to drill from a summary chart into detailed transactional information while preserving the current analytical context?

A.

Repository Variables

B.

Action Links

C.

Runtime Configuration

D.

Report Bursting

Full Access
Question # 22

Which Oracle Analytics Publisher configuration controls default processing options such as temporary file handling, font settings, and report output behavior?

A.

Runtime Configuration

B.

Subject Area

C.

Presentation Variable

D.

Selection Step

Full Access
Question # 23

An author wants to combine results from two subject areas in an analysis and asks whether the Analysis Editor can create joins between subject areas. Which approach should the author use?

A.

Stack query results with set operators, and handle joins in the semantic model

B.

Build the subject-area relationship by selecting the second query

C.

Create join logic with set operators inside the Analysis Editor

D.

Add extra result columns after viewing the combined query output

E.

Use dashboard prompts to join subject areas

Full Access
Question # 24

An analyst wants to highlight sales values above target in green and values below target in red without changing the underlying data. Which feature should be used?

A.

Conditional Formatting

B.

Repository Variable

C.

Selection Step

D.

Subject Area Filter

Full Access
Question # 25

A report should exclude products with zero sales before any ranking or sorting occurs. Which Oracle Analytics feature should be used?

A.

Dashboard Prompt

B.

Selection Step

C.

Conditional Formatting

D.

Narrative View

Full Access
Question # 26

You have been tasked with building an analysis that requires data from two subject areas. How do you accomplish this?

A.

Create an analysis and add a second (related) subject area

B.

Modify a subject area to include all the columns required

C.

Create two separate analyses and use the UNION feature

D.

Create two separate analyses and use the MERGE feature

E.

Build a dashboard prompt to combine the subject areas

Full Access
Question # 27

You are configuring two report parameters. The second parameter must refresh its available values based on the value selected in the first parameter. Which two selections support this cascading parameter behavior?

A.

Select Refresh other parameters on change

B.

Set the parameter type to Date

C.

Use Fixed Data as the parameter type

D.

Select Multiple Selection as the LOV type for the dependent parameter

E.

Set Parameter Type to Menu

F.

Disable parameter validation

Full Access
Question # 28

A multinational organization must generate reports in English, French, and Japanese using a single report definition. Which Oracle Analytics Publisher capability should be used?

A.

Translation Manager with XLIFF localization files

B.

Separate reports for every language

C.

Multiple JDBC data sources

D.

Dashboard prompts for language selection only

Full Access
Question # 29

An administrator wants only HR managers to run payroll reports while preventing all other authenticated users from accessing them. Which security mechanism should be implemented?

A.

Enable query caching

B.

Use Dashboard Prompts

C.

Assign catalog permissions based on application roles

D.

Create separate report layouts

Full Access
Question # 30

A report is scheduled to burst thousands of personalized PDFs by email every night. Some recipients are not receiving reports because their email addresses are missing in the bursting query results. What is the most likely cause?

A.

The report layout is missing a chart.

B.

The bursting control query does not return valid delivery information for those recipients.

C.

Dashboard prompts are not configured.

D.

Query caching is disabled.

Full Access