Download Oracle Analytics Ultimate Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which OCI service must be subscribed to before an Oracle Analytics Cloud (OAC) instance can be provisioned? A) Oracle Cloud Infrastructure Compute B) Oracle Cloud Infrastructure Object Storage C) Oracle Cloud Infrastructure Identity and Access Management (IAM) D) Oracle Cloud Infrastructure Virtual Cloud Network (VCN) Answer: A Explanation: OAC runs on OCI Compute instances; a compute subscription is required to host the analytics service. Question 2. In OAC, what is the primary functional difference between the Professional and Enterprise editions? A) Enterprise supports multi‑region deployment, Professional does not. B) Professional includes Data Flow orchestration, Enterprise does not. C) Enterprise provides advanced security (Data Masking, Auditing) and larger storage limits. D) Professional allows unlimited users, Enterprise limits user count. Answer: C Explanation: Enterprise edition adds advanced security, larger storage, and additional performance features not present in Professional. Question 3. When configuring OCI compartments for OAC, which principle should be applied to isolate environments? A) Place all environments in a single compartment for simplicity. B) Use separate compartments for development, test, and production. C) Create a compartment for each individual user. D) Compartments are not used for OAC isolation. Answer: B
Explanation: Separate compartments provide logical isolation and independent access controls for dev, test, and prod. Question 4. Which action allows you to temporarily stop billing for an OAC instance without losing its configuration? A) Delete the instance. B) Pause the instance. C) Scale the instance to a smaller shape. D) Enable Maintenance Mode. Answer: B Explanation: Pausing an OAC instance stops compute charges while preserving all configuration and data. Question 5. In OCI Identity and Access Management (IAM), which role grants a user permission to create and manage OAC data sets? A) OCI Compute Admin B) OAC Service Administrator C) OAC Data Set Creator (BI Content Author) D) OCI Object Storage Reader Answer: C Explanation: The BI Content Author role includes permissions to create, edit, and publish data sets within OAC. Question 6. Which feature of Oracle Identity Cloud Service (IDCS) is used to synchronize on‑premises LDAP groups with OAC? A) Federated SSO B) User Provisioning Connector
A) OCI Load Balancer B) OCI Data Flow C) RDC Agent (Oracle Data Integration Service) D) OCI FastConnect Answer: C Explanation: The RDC Agent runs in the customer VCN and establishes a secure tunnel to the on‑premises database. Question 10. Which SaaS integration option allows OAC to retrieve data from Oracle Fusion Cloud Applications without writing custom code? A) REST Data Service (RDS) B) Fusion Application Data Model (FADM) C) Pre‑built Fusion Data Connector D) OAC Data Flow FTP Pull Answer: C Explanation: The pre‑built Fusion Data Connector provides out‑of‑the‑box connectivity to Fusion Cloud data. Question 11. In OAC Data Flow, which transformation is used to combine rows from two data sets that have the same columns? A) Join B) Union C) Pivot D) Filter Answer: B Explanation: Union appends rows from two compatible data sets, preserving column order.
Question 12. Which Data Flow operation would you use to derive a new column that extracts the month from a date column? A) Filter B) Join C) Derived Column D) Aggregation Answer: C Explanation: The Derived Column transformation lets you create calculated fields, such as extracting month using DATE_TRUNC or EXTRACT functions. Question 13. How can you schedule a Data Flow to run every night at 02:00 AM OCI time? A) Use the “Refresh Now” button and select “Nightly”. B) Create a cron expression in the Data Flow’s Advanced Settings. C) Define a schedule in the Data Flow UI with the desired recurrence. D) Set the Data Flow to “Auto‑Refresh” and specify the interval. Answer: C Explanation: OAC provides a Schedule dialog where you can set recurrence, start time, and time zone. Question 14. Which layer of the RPD (Repository) contains physical schema definitions and connection pools? A) Presentation Layer B) Business Model and Mapping (BMM) Layer C) Physical Layer D) Logical Layer Answer: C
D) Data Store Answer: A Explanation: Subject Areas group logical tables and present them as a logical unit to end users. Question 18. Which schema design minimizes data redundancy by separating dimension tables into multiple related tables? A) Star Schema B) Snowflake Schema C) Fact Constellation Schema D) Flat Table Schema Answer: B Explanation: Snowflake schema normalizes dimension tables into related sub‑tables, reducing redundancy. Question 19. In OAC’s web‑based modeling, what is the effect of marking a hierarchy as “Parent‑Child” instead of “Level‑Based”? A) Parent‑Child hierarchies support unlimited depth and dynamic members. B) Level‑Based hierarchies enable drill‑through to external URLs. C) Parent‑Child hierarchies are only used for time dimensions. D) Level‑Based hierarchies cannot be used in visualizations. Answer: A Explanation: Parent‑Child hierarchies allow recursive relationships and any number of levels, unlike fixed level‑based hierarchies. Question 20. Which OAC feature allows a user to click a chart element and open a related analysis in a new tab? A) Data Action
B) Drill‑Down C) Navigation Link D) Action Link Answer: A Explanation: Data Actions can be configured to launch another analysis or URL based on the selected data point. Question 21. Which visualization type is best suited for displaying hierarchical relationships such as organization structures? A) Treemap B) Sankey Diagram C) Sunburst Chart D) Heatmap Answer: C Explanation: Sunburst charts visualize hierarchical data with concentric rings representing levels. Question 22. In OAC Canvas, what is the purpose of a “Parameter” object? A) To store static text for titles. B) To capture user input that drives filters or calculations at runtime. C) To define the layout grid size. D) To embed external web pages. Answer: B Explanation: Parameters allow end users to provide values that affect visualizations, filters, or calculations dynamically.
Explanation: NLQ interprets user‑typed questions and generates appropriate visualizations without manual report building. Question 26. In classic OBIEE terminology, what is an “Answer”? A) A saved data set. B) A visual representation of a query (analysis). C) A BI Publisher template. D) A security role. Answer: B Explanation: An Answer (or Analysis) is a saved query with visualizations that can be added to a dashboard. Question 27. Which feature allows a dashboard object to change its color based on a threshold value? A) Conditional Formatting B) Data Action C) Parameter Binding D) Layout Template Answer: A Explanation: Conditional Formatting applies style rules (e.g., color) when data meets defined conditions. Question 28. In BI Publisher, which file type is used to define the layout of a report in Microsoft Word? A) .rtf B) .xsl C) .xml
D) .pdf Answer: A Explanation: RTF (Rich Text Format) templates are created in Word and uploaded to BI Publisher for formatting. Question 29. Which BI Publisher feature enables a single report to be delivered to multiple recipients with different data slices? A) Report Bursting B) Data Model Merging C) Prompt Substitution D) Dynamic Layouts Answer: A Explanation: Bursting splits a single report into multiple outputs based on defined criteria and sends each to a distinct recipient. Question 30. What is the main purpose of the OAC Cache Management console? A) To configure user authentication methods. B) To view and purge cached query results to improve performance. C) To schedule Data Flow executions. D) To manage object storage buckets. Answer: B Explanation: Cache Management lets administrators monitor cache usage and clear stale entries, affecting query response times. Question 31. Which OCI service provides a “Usage Tracking” capability for OAC to see who executed which queries? A) OCI Logging
A) Set column data type to “Masked”. B) Apply a Data Enrichment rule with a masking function. C) Use the “Hide Column” property in the Presentation Layer. D) Create a view in the source database that masks the data. Answer: B Explanation: Data Enrichment can apply functions like SHA2 or custom masking to protect sensitive columns at the dataset level. Question 35. Which OAC visualization automatically aggregates data along a flow from source to destination, useful for visualizing cost allocations? A) Sankey Diagram B) Scatter Plot C) Radar Chart D) Bubble Map Answer: A Explanation: Sankey diagrams display weighted flows between nodes, ideal for cost or process flows. Question 36. What is the effect of enabling “Auto‑Refresh” on a dashboard visualization? A) The visualization will reload automatically when the underlying data set changes. B) The dashboard will be exported as a PDF every hour. C) Users will be forced to re‑login after a set interval. D) The visualization’s layout will be recalculated every minute. Answer: A Explanation: Auto‑Refresh polls the data source and updates the visualization when new data is available.
Question 37. Which of the following is NOT a valid OAC data source type? A) Oracle Autonomous Data Warehouse (ADW) B) Google BigQuery C) SAP HANA Cloud D) Oracle Cloud Infrastructure Object Storage (CSV) Answer: B Explanation: As of the current release, OAC does not provide a native connector for Google BigQuery. Question 38. In a Data Flow, which transformation would you use to remove rows where the “Revenue” column is null? A) Join B) Filter C) Aggregation D) Union Answer: B Explanation: The Filter transformation allows row‑level conditions, such as IS NOT NULL. Question 39. Which Oracle Analytics Cloud feature provides “storytelling” capabilities by combining visualizations with narrative text and snapshots? A) Canvas B) Stories C) Data Flow Designer D) Data Modeler Answer: B Explanation: Stories let authors embed visualizations, text, and captured snapshots into a guided narrative.
Explanation: Open URL actions construct a URL with context variables, opening an external site with filtered data. Question 43. Which OAC security model controls access to data at the row level based on user attributes? A) Object‑Level Security B) Role‑Based Access Control (RBAC) C) Data‑Level Security (Data Filters) D) Network Security Groups Answer: C Explanation: Data Filters (row‑level security) restrict visible rows according to user or group attributes. Question 44. Which of the following is a benefit of using “Data Flow Scheduling” over manual refresh? A) Guarantees zero latency queries. B) Allows off‑peak processing to reduce impact on source systems. C) Eliminates the need for data modeling. D) Provides real‑time streaming data. Answer: B Explanation: Scheduling lets you run heavy data loads during low‑usage windows, reducing source system load. Question 45. When configuring an OAC instance for high availability, which OCI feature should be enabled? A. OCI Autonomous Database High‑Performance Tier B. OCI Load Balancer with health checks across OAC nodes C. OCI Object Storage Versioning
D. OCI Block Volume Encryption Answer: B Explanation: A Load Balancer distributes traffic and monitors node health, providing HA for OAC. Question 46. Which OAC component is responsible for translating a logical query into native SQL for the source database? A. Data Flow Engine B. Query Service (QSI) C. Presentation Layer Renderer D. Cache Manager Answer: B Explanation: The Query Service interprets the logical model and generates optimized native SQL. Question 47. Which of the following is NOT a valid method to secure data transmitted between OAC and an on‑premises source? A. Using a Private Access Channel (PAC) B. Enabling TLS on the RDC Agent C. Configuring a VPN between OCI and the data center D. Disabling encryption to improve performance Answer: D Explanation: Disabling encryption reduces security and is not a recommended method. Question 48. In OAC, what does the “Explain” function return when applied to a KPI? A. A list of SQL statements used to compute the KPI. B. A set of visualizations showing outliers, drivers, and segments. C. The execution plan of the underlying query.
B. Scatter Plot C. Pie Chart D. Heatmap Answer: B Explanation: Scatter plots visualize the relationship and correlation between two numeric axes. Question 52. In a Data Flow, what does the “Aggregation” transformation do? A. Joins two data sets. B. Calculates summary values (SUM, AVG, COUNT) based on grouping columns. C. Filters rows based on a condition. D. Changes the data type of a column. Answer: B Explanation: Aggregation groups rows and computes aggregate metrics. Question 53. Which OAC feature can automatically suggest the most appropriate chart type based on data characteristics? A. Auto‑Chart Recommendation Engine B. Visual Analyzer C. Explain Function D. Data Action Wizard Answer: A Explanation: The Auto‑Chart Recommendation Engine proposes chart types that best represent the selected data. Question 54. What is the purpose of a “Prompt” in a classic OBIEE analysis? A. To hide the analysis from unauthorized users.
B. To request input values from the end‑user at runtime. C. To schedule the analysis for later execution. D. To convert the analysis into a PDF. Answer: B Explanation: Prompts collect user‑provided values that filter the analysis when it runs. Question 55. Which OAC option enables you to create a “snapshot” of the entire analytics environment for backup or migration? A. Export BAR file B. Take a System Snapshot (OCI Backup) C. Create a Data Flow checkpoint D. Publish a Content Pack Answer: B Explanation: System Snapshots capture the full OAC configuration, data sets, and content for backup or migration. Question 56. In OAC, which type of cache stores the results of a query to speed up subsequent identical requests? A. Result Cache B. Metadata Cache C. Object Cache D. Session Cache Answer: A Explanation: Result Cache holds query results, allowing faster retrieval for identical queries.
