Governed Analytics Professional with Oracle Analytics Cloud (1Z0-1177-26) - Practice Exam 1

1. A business owner requests daily exception notifications while retaining an interactive dashboard for investigation. Which design is appropriate?
2. A calculated column is correct per product but its displayed grand total seems wrong. What should the author examine before changing source data?
3. A chart on one dashboard page should navigate to a target page for the selected customer. What should the designer configure?
4. A Classic analysis needs a table for detail and a chart for trends from the same criteria. What should the author do?
5. A critical report is emailed successfully but contains data inappropriate for some recipients. What should be reviewed first?
6. A dashboard includes a text prompt whose value is used in a query expression. Which two controls are important? Select TWO.
7. A dashboard must apply the same fiscal-period choice to analyses on several pages. What should the designer consider?
8. A dashboard must remain readable when exported for a monthly meeting. What is the best preparation?
9. A dashboard page has summary and operational sections, but the operational section should appear only when a condition is satisfied. Which feature fits?
10. A dashboard performs poorly because it runs many expensive analyses on initial load. Which design change is most defensible?
11. A dashboard prompt writes a presentation variable used in an expression. What should the author test?
12. A dashboard shows a stale-looking result. Which sequence best diagnoses the issue?
13. A department needs to view approved dashboards but must not edit them. What permission approach is most suitable?
14. A development catalog folder will be promoted to production. Which approach minimizes unexpected breakage?
15. A manager needs the ten products with the highest aggregated revenue. Which approach best expresses this requirement?
16. A model joins two dimensions directly even though they should relate through a fact. Users get unexpected combinations and totals. What should be reviewed?
17. A model should apply a user's region entitlement at query time. Which building blocks are relevant? Select TWO.
18. A new analytics user can sign in but cannot create analyses. What should the administrator examine?
19. A new semantic model revision changes a column used by hundreds of saved analyses. What is the safest release approach?
20. A production analysis is stored in an author's personal folder and disappears for colleagues. What is the appropriate correction?
21. A prompt displays cities that are invalid for the selected country. Which design most directly improves this interaction?
22. A regional manager may open the Sales dashboard but should see only her region. Which controls address these separate requirements?
23. A report author needs details hidden until a user chooses an action from a summarized result. Which capability is appropriate?
24. A report needs Revenue divided by Units after the two measures have been aggregated. Which validation is most important?
25. A restricted measure is hidden in a dashboard view but remains accessible through other analyses. What is the correct response?
26. A security tester wants to confirm that regional row restrictions work. Which test is strongest?
27. A sensitive report is cached or scheduled. What principle should its security review preserve?
28. A shared dashboard references an analysis that the viewer cannot open. What should the administrator inspect?
29. A team needs reusable references to an approved analysis without maintaining many independent copies. What should it consider?
30. A team wants exception cells to stand out when margin falls below five percent without removing other rows. What should it configure?
31. A time dimension supports Year, Quarter, Month, and Day. Which model feature enables governed drill navigation through these levels?
32. A user changes prompt values but a fixed analysis filter still overrides the desired selection. What should the author review?
33. An administrator is reviewing an agent that runs under a specific identity. Why does that identity matter?
34. An agent must deliver a report only when overdue balances exceed a threshold. What should the author configure?
35. An agent's scheduled delivery is no longer required after a project ends. What should the owner do?
36. An analyst adds a revenue threshold to a row-level attribute filter and gets a different result from filtering aggregated revenue. What explains the difference?
37. An analyst must return only orders placed in the current fiscal year. Which Classic analysis component primarily restricts the rows requested?
38. An analyst sees confidential source column names in a subject area. The business wants friendly names without renaming database columns. Which layer primarily supplies these names?
39. An analyst wants an analysis to accept a dashboard's Region prompt. What should be checked in the analysis?
40. An analytics administrator wants fewer individually maintained grants. Which approach supports maintainable access control?
41. An author adds a dashboard filter for Department and calls it row-level security. Why is this insufficient?
42. An employee changes departments but retains old report access. What should administrators review?
43. An inventory balance is additive across warehouses but should not be summed across days. What must the modeler account for?
44. An order fact has many lines per order, and a customer dimension has one row per customer. Revenue doubles after introducing another detail table. What should the modeler investigate first?
45. Executives want a saved link that restores a particular dashboard state. What should be validated when providing such a link?
46. Finance users need one approved definition of Net Revenue across Classic analyses. Where should the team centralize this reusable business definition?
47. Sales targets are monthly by region while actual sales are daily by store. Which design best supports trustworthy comparisons?
48. Two departments need different subject-area names for the same governed sales facts. How can a modeler expose tailored views without maintaining duplicate databases?
49. Users must find approved financial reports among many drafts. What governance practice helps most?
50. Users need to drill from region totals to country detail along a governed hierarchy. What should the analysis use?

Comments — 0