Oracle 1Z0-1177-26 Certification Sample Questions and Answers
The Oracle Governed Analytics Professional with Analytics Cloud (1Z0-1177-26) Sample Question Set is designed to help you prepare for the Governed Analytics Certified Professional with Oracle Analytics Cloud certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-1177-26 Certification Practice Exam.
This Governed Analytics Professional with Oracle Analytics Cloud certification sample practice test and sample question set are designed for evaluation purposes only. If you want to test your Oracle 1Z0-1177-26 knowledge to identify your areas of improvement and get familiar with the actual exam format, we suggest you prepare with the Premium Governed Analytics Certified Professional with Oracle Analytics Cloud Certification Practice Exam. Our team of Oracle Cloud Infrastructure experts has designed Questions-Answers for this premium practice exam by collecting inputs from recently certified candidates. Our premium Oracle 1Z0-1177-26 certification practice exam will boost your confidence as well as your actual Oracle Governed Analytics Professional with Analytics Cloud exam result.
Oracle 1Z0-1177-26 Sample Questions:
01. One report's layout text, such as column headings and titles, must appear in French for users whose report locale is French. The report sits in a folder with many other reports whose French template translations were finished last quarter and must not change. The team does not want to maintain a second copy of the layout.
What should the developer do?
a) Generate an XLIFF file from the layout template, translate it and upload it for French
b) Export the catalog translation file for the report's folder and translate every entry in it
c) Copy the report into a French folder, and retype the layout headings in French
d) Add a data set to the data model that returns French labels for each heading
02. An analysis filter uses a session variable that is initialized at sign-in to the user's default currency. A dashboard prompt must let a user override that value for the queries on the page only, without changing the session value used elsewhere.
How should the prompt be configured?
a) Change the initialization block so it reads the currency again on each query
b) Set a presentation variable that has the same name as the session variable
c) Set a request variable that has the same name as the session variable
d) Replace the session variable with a static repository variable for currency
03. The same saved Region dashboard prompt appears on all four pages of a dashboard. When a user picks a region on one page and then opens another page, the analyses there must already use that region, without the user choosing it again.
How should the prompt be configured?
a) Set the prompt's scope to Dashboard, and keep it on all four pages
b) Keep the scope at Page and give each page's copy the same default
c) Add is-prompted Region filters only to the first page's analyses
d) Save the region selection as a customization of the first page
04. Dashboard users want to switch the same results between a bar graph and a table without leaving the page. Only one of the two should be visible at a time.
What should the content author add to the analysis?
a) A compound layout that holds the graph view and the table view
b) A view selector that lists the graph view and the table view
c) A master-detail link from the graph to the table
d) Two dashboard pages, with the graph on one and the table on the other
05. After the nightly data load, some dashboards keep showing the previous day's figures until mid-morning, although the database already holds the new data.
What should the administrator change?
a) Rebuild the dashboards to reference the new load tables
b) Raise the maximum number of rows the cache can store
c) Enable usage tracking so the stale queries are logged
d) Purge the query cache as a final step, after the nightly load finishes
06. Finance needs report output as a native Excel workbook in which Excel formulas calculate the totals and the data is split across worksheets, one per business unit.
Which layout type should the developer create?
a) A Layout Editor layout run as Excel output
b) An Excel template
c) A classic analysis exported to Excel
d) An RTF template run as Excel output
07. A SQL data set must return only the rows for the salesperson who runs the report. The table stores each row's owner login in SALES_REP_LOGIN. Users must not be able to see other salespeople's rows by changing a prompt.
Which WHERE clause meets this requirement?
a) WHERE sales_rep_login = :P_USER, with P_USER a text parameter
b) WHERE sales_rep_login = USER, using the database function
c) No WHERE clause, with a layout filter hiding other salespeople's rows
d) WHERE sales_rep_login = :xdo_user_name
08. Report users need a cross-tab in a Publisher layout: Region down the side, Quarter across the top, Revenue in the cells, and totals for each row and column.
What should the developer insert?
a) A data table with Region, Quarter and Revenue columns plus a grand total row at the end
b) A chart with Quarter on the category axis, Region as series and Revenue as the values
c) A pivot table with Region on rows, Quarter on columns and Revenue as the measure
d) A repeating section on Quarter, each holding a data table of Region and Revenue
09. Each customer must receive only their own invoice PDF, by email, at the address stored in the customer data. The invoice data is grouped by CUSTOMER_ID.
How should the bursting definition be set up?
a) Split and deliver by CUSTOMER_ID, returning each email address from the bursting query
b) Split by CUSTOMER_ID, and list every customer's email address as a recipient on the schedule
c) Deliver by CUSTOMER_ID, and create a separate schedule job for each customer's parameter value
d) Split by EMAIL_ADDRESS, and send the complete output to a single distribution list address
10. Before a Publisher report runs, users must pick a department from a drop-down list of valid departments, and the data set must then return only rows for the chosen department.
What should the data model author create?
a) A text parameter referenced as a bind variable in the data set, defaulting to one department
b) A list of values referenced directly in the data set's WHERE clause, without any parameter
c) A menu parameter fed by a list of values, referenced as a bind variable in the data set
d) An event trigger that runs before the data set is queried and asks the user for a department
Answers:
|
Question: 01 Answer: a |
Question: 02 Answer: c |
Question: 03 Answer: a |
Question: 04 Answer: b |
Question: 05 Answer: d |
|
Question: 06 Answer: b |
Question: 07 Answer: d |
Question: 08 Answer: c |
Question: 09 Answer: a |
Question: 10 Answer: c |
- Oracle Cloud Infrastructure |
- 1Z0-1177-26 |
- Oracle 1Z0-1177-26 Questions and Answers |
- 1Z0-1177-26 Practice Test |
- 1Z0-1177-26 Sample Questions |
- 1Z0-1177-26 Simulator |
- Oracle Governed Analytics Professional with Analytics Cloud Online Exam |
- Governed Analytics Professional with Oracle Analytics Cloud |
- Governed Analytics Professional with Analytics Cloud Exam Questions |
- Governed Analytics Professional with Analytics Cloud |
- 1Z0-1177-26 Study Guide PDF |
- 1Z0-1177-26 Online Practice Test |
- Oracle Analytics Cloud Mock Test |
- 1Z0-1177-26 Test Questions |
- 1Z0-1177-26 Exam Guide |
- 1Z0-1177-26 Study Material |
- Oracle Governed Analytics Professional with Analytics Cloud Prep Guide
