Download PrepIQ TESOPT100ICS1002 AS TESOPT100ICS1002 ES TECH P100 ESOR ORA OBIEE Ultimate Exam and more Exams Technology in PDF only on Docsity!
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Question 1. Which component of the RPD is responsible for defining connection pools and DSNs? A) Physical Layer B) Business Model and Mapping Layer C) Presentation Layer D) Session Variable Layer Answer: A Explanation: The Physical Layer contains data source definitions, including DSNs and connection pools. Question 2. When importing metadata from a relational database, which option should be selected to automatically detect primary keys? A) Use Existing Keys Only B) Discover Primary Keys C) Create Synthetic Keys D) Ignore Primary Keys Answer: B Explanation: “Discover Primary Keys” directs the import wizard to scan the source tables for primary key constraints. Question 3. In the Physical Layer, a physical join that links two tables on non-indexed columns is likely to cause what performance issue? A) Faster query execution B) Increased cache usage C) Full table scans on the database D) Automatic aggregation Answer: C Explanation: Joining on non-indexed columns forces the database to perform full scans, degrading performance. Question 4. Which of the following statements about logical tables in the BMM layer is true? A) They store physical data rows.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
B) They can contain columns from multiple physical tables. C) They are visible only to the BI Server, not to end users. D) They must have the same name as the physical table. Answer: B Explanation: Logical tables are abstractions that can combine columns from several physical tables using logical joins. Question 5. A Parent-Child hierarchy is best used for which type of data? A) Calendar dates B) Product categories with fixed depth C) Organizational structures with variable depth D) Geographic regions with two levels only Answer: C Explanation: Parent-Child hierarchies support an indefinite number of levels, ideal for org charts. Question 6. Which time-series function returns the value of a measure for the same period in the previous year? A) TODATE() B) AGO() C) PERIODROLLING() D) YEAROVERYEAR() Answer: B Explanation: AGO('Year', 1) shifts the time frame back one year, yielding the prior-year value. Question 7. When should a calculated measure be defined as a Physical calculation rather than a Logical one? A) When it uses only BI Server functions. B) When it requires database-specific SQL for performance. C) When it references session variables. D) When it is used only in dashboards.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Question 11. Which conditional formatting option would you use to highlight rows where Sales > $1,000,000? A) Font Color = Red B) Background Color = Yellow when expression evaluates to TRUE C) Bold Text when expression is FALSE D) Hide Row when expression is TRUE Answer: B Explanation: Conditional formatting can set a background color based on a Boolean expression like “Sales > 1000000”. Question 12. To create a multi-page dashboard, which feature must be added to the dashboard layout? A) Page Tabs B) Prompt Controls C) Action Links D) Variable Filters Answer: A Explanation: Page Tabs allow navigation between separate pages within a single dashboard. Question 13. Which type of prompt allows the user to select an image that will act as a navigation button? A) Column Prompt B) Image Prompt C) Variable Prompt D) Date Prompt Answer: B Explanation: Image Prompts display selectable images that can trigger actions. Question 14. In the Action Framework, “Navigate to BI Content” differs from “Navigate to Web Page” in that it:
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
A) Opens a new browser window. B) Passes session variables to the target content. C) Requires a URL. D) Can only be used for external sites. Answer: B Explanation: “Navigate to BI Content” can pass filters and variables to another OBIEE object. Question 15. Which WebLogic Console task is required to give a user read-only access to a specific catalog folder? A) Create a new group and assign the folder permission. B) Edit the user’s repository variables. C) Modify the user’s session timeout. D) Enable the user’s audit logging. Answer: A Explanation: Permissions are granted through groups; assigning the folder’s read-only role to a group gives its members that access. Question 16. Row-level security in the RPD is implemented by: A) Setting object-level permissions in the Catalog. B) Adding a filter on the logical table in the BMM layer. C) Defining a static repository variable. D) Configuring a cache purge schedule. Answer: B Explanation: Row-level security is achieved by applying a logical filter (often referencing a session variable) to a logical table. Question 17. Which type of repository variable is evaluated once per user session and can be changed by the user? A) Static Repository Variable B) Dynamic Repository Variable C) Session Variable
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Explanation: The Refresh Interval defines the lifespan of cached query results. Question 21. The “Push-down” of functions to the database improves performance because: A) The BI Server can execute them faster than the database. B) It reduces network traffic by sending fewer rows. C) It forces the database to use its own caching mechanism. D) It disables row-level security. Answer: B Explanation: Pushing calculations to the database lets the DB filter and aggregate data before sending results, decreasing data transfer. Question 22. Which log file is most useful for diagnosing slow SQL generated by an analysis? A) nqsrv.log B) NQQuery.log C) analytics.log D) webcat.log Answer: B Explanation: NQQuery.log records the SQL statements sent to the database and their execution times. Question 23. An aggregate table in OBIEE is best described as: A) A physical table that stores pre-aggregated data for faster query response. B) A logical view that calculates aggregates on the fly. C) A temporary table created during analysis execution. D) A metadata object that defines hierarchies. Answer: A Explanation: Aggregate tables are physical tables that contain pre-summarized data to speed up queries.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Question 24. Which of the following is a valid use case for a Horizontal Aggregate? A) Summing sales across all product lines for each month. B) Calculating the average profit per region. C) Adding a total column that shows the sum across selected columns in a row. D) Rolling up sales from child to parent hierarchy levels. Answer: C Explanation: Horizontal aggregates compute a value across columns within a single row. Question 25. A Vertical Aggregate is typically used to: A) Create a total row that aggregates values across rows. B) Generate a drill-down hierarchy. C) Apply row-level security. D) Cache query results. Answer: A Explanation: Vertical aggregates add a total row summarizing column values across multiple rows. Question 26. When modeling a fiscal calendar that starts in April, which function helps align time-series calculations? A) CALENDAR('Fiscal', 'April') B) TIMEPERIOD('Fiscal', 'StartMonth', 'April') C) PERIODSHIFT('Fiscal', 0) D) NONE; you must create a custom dimension. Answer: B Explanation: The TIMEPERIOD function can define a fiscal calendar with a specified start month. Question 27. Which option best describes the “Level-Based” hierarchy? A) It uses a parent-child relationship stored in a single column. B) It defines fixed levels such as Country → State → City.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Explanation: Dashboard Prompts with shared scope propagate the selected value to all dashboard components. Question 31. Which action type can be used to send the results of an analysis to a PDF file via email? A) Navigate to Web Page B) Execute Agent C) Navigate to BI Content D) Refresh Cache Answer: B Explanation: Agents can be scheduled to run an analysis and deliver the output as PDF via email. Question 32. In OBIEE, what is the purpose of a “Variable Prompt”? A) To filter data at the database level. B) To capture user input that can be used in repository variables. C) To create a static list of values. D) To define a new subject area. Answer: B Explanation: Variable Prompts collect user input and assign it to session variables for use throughout the session. Question 33. Which of the following best describes a “Trellis View”? A) A single table with conditional formatting. B) Multiple charts displayed in a grid based on a dimension. C) A hierarchical drill-down chart. D) A gauge with multiple pointers. Answer: B Explanation: Trellis Views create a matrix of identical charts, each filtered by a distinct dimension value.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Question 34. When configuring an Agent, which option determines the recipients of the alert? A) Delivery Method B) Schedule C) Condition D) To: field in the Agent definition. Answer: D Explanation: The “To:” field lists the users or groups that receive the Agent’s output. Question 35. Which of the following is true about “Dynamic Repository Variables”? A) Their values are set at login and never change. B) They can be populated by a SQL query each time they are referenced. C) They are defined only in the Presentation Layer. D) They cannot be used in filters. Answer: B Explanation: Dynamic variables execute a query each time they are accessed, allowing up-to-date values. Question 36. What does the “Cache Manager” tool allow you to do? A) Edit repository variables. B) Purge or seed the BI Server cache. C) Create new subject areas. D) Manage user passwords. Answer: B Explanation: Cache Manager provides functions to clear (purge) or pre-populate (seed) the cache. Question 37. In the context of OBIEE, what is an “Event Polling Table” (EPT) used for? A) Storing user session data.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
D) Disable the aggregate persistence feature. Answer: B Explanation: Aggregates should be created at the grain required by the most common queries to avoid unnecessary storage. Question 41. To allow a user to see only sales data for their own region, which security technique is applied? A) Object-level security on the Sales subject area. B) Row-level filter using a session variable that contains the user’s region. C) Hiding the Region column in the presentation layer. D) Encrypting the Sales fact table. Answer: B Explanation: Row-level security filters rows based on a session variable that matches the user’s region. Question 42. Which function would you use to calculate Year-to-Date (YTD) sales? A) AGO('Year',1) B) TODATE('Year') C) PERIODROLLING('Year',12) D) YEAROVERYEAR('Sales') Answer: B Explanation: TODATE('Year') returns the cumulative value from the start of the year to the current period. Question 43. In the Presentation Layer, what is a “Display Folder”? A) A physical directory on the server. B) A grouping mechanism for columns that appears in the end-user UI. C) A security container for subject areas. D) A storage location for aggregate tables. Answer: B
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Explanation: Display folders organize columns in the UI, making them easier to find. Question 44. Which of the following actions can be triggered by a “Selection Step” in an analysis? A) Refreshing the BI Server cache. B) Launching a URL with parameters. C) Changing the database connection pool. D) Modifying the RPD file. Answer: B Explanation: Selection Steps can be configured to execute actions such as navigating to a URL. Question 45. When defining a logical join that uses a calculated expression on one side, you must create the join in which layer? A) Physical Layer B) Business Model and Mapping Layer C) Presentation Layer D) Session Variable Layer Answer: B Explanation: Logical joins, especially those with expressions, are defined in the BMM layer. Question 46. Which of the following is a benefit of using “Fragmentation” in aggregate persistence? A) It forces all aggregates to be rebuilt daily. B) It allows aggregates to be stored in multiple tables based on partition keys. C) It disables the use of cache. D) It aggregates data across unrelated dimensions. Answer: B Explanation: Fragmentation splits aggregate data into separate tables (or partitions) for better manageability and performance.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
B) Dashboard State Saving. C) Variable Prompt “Default to Last Value”. D) Session Variable “Persist”. Answer: B Explanation: Dashboard State Saving preserves filter and prompt selections across sessions. Question 51. Which log entry would indicate that a query was served from the cache? A) “Cache Miss – Query executed”. B) “Cache Hit – Result returned”. C) “SQL generated: SELECT …”. D) “Cache Purge initiated”. Answer: B Explanation: “Cache Hit” denotes that the result was retrieved from the cache. Question 52. In OBIEE, the “Push-Down” of a filter means: A. The filter is applied after data retrieval. B. The filter is translated into SQL and executed by the database. C. The filter is stored in the cache. D. The filter is ignored for aggregate tables. Answer: B Explanation: Push-down translates the filter into a WHERE clause, letting the database perform the restriction. Question 53. Which of the following is a valid use of the “AGO” function? A) AGO('Month', 0) – returns the current month. B) AGO('Quarter', -1) – returns the next quarter. C) AGO('Year', 2) – returns two years ahead. D) AGO('Day', 5) – returns five days ago. Answer: D
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Explanation: AGO shifts the time period backward; AGO('Day',5) returns the value five days prior. Question 54. Which of the following best describes an “Object-Level Security” permission? A) Controls which rows a user can see. B) Determines whether a user can edit a subject area. C) Filters data based on a session variable. D) Sets the cache expiration time for a query. Answer: B Explanation: Object-level security defines read/write permissions on catalog objects such as reports or dashboards. Question 55. When creating a logical column that references a physical column with a different data type, you must: A) Change the data type in the Physical Layer. B) Use a CAST expression in the logical column definition. C) Enable “Data Type Conversion” in the server settings. D) Create a new aggregate table. Answer: B Explanation: CAST allows conversion of data types at the logical layer without altering the physical source. Question 56. Which of the following actions can be added to a dashboard component using the Action Framework? A) Refresh the entire dashboard. B) Execute an Agent. C) Open a new browser tab with a custom URL. D) Modify the repository variables. Answer: C Explanation: The Action Framework can be configured to navigate to an external URL in a new tab.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
B) A table that stores both detailed and aggregated rows. C) An aggregate that is generated on-the-fly. D) A table that contains duplicate rows for redundancy. Answer: A Explanation: Fragmentation partitions an aggregate table by a dimension, improving manageability and query performance. Question 61. Which WebLogic component is primarily responsible for managing OBIEE user authentication? A) Presentation Services B) Oracle BI Server C) Identity Assertion Provider D) Catalog Manager Answer: C Explanation: The Identity Assertion Provider handles authentication and passes the user identity to OBIEE. Question 62. In the Presentation Layer, a “Subject Area” is: A) A physical database schema. B) A collection of logical tables exposed to end users. C) A security group. D) A cache configuration. Answer: B Explanation: Subject Areas are logical containers that expose logical tables and columns to analysts. Question 63. Which of the following is a recommended method to reduce the size of the BI Server cache? A) Increase the cache expiration time. B) Decrease the cache size limit. C) Disable cache for all queries. D) Enable “Cache Purge on Login”.
TESOPT100ICS1002 ES TECH P
ESOR ORA OBIEE Ultimate Exam
Answer: B Explanation: Reducing the cache size limit forces older entries to be evicted, controlling memory usage. Question 64. When using the “TODATE” function with a “Quarter” argument, the result includes: A) Only the current quarter’s data. B) All data from the start of the fiscal year to the current quarter. C) Data from the start of the current quarter to the present day. D) Data from the previous quarter. Answer: C Explanation: TODATE('Quarter') aggregates from the beginning of the current quarter up to the current period. Question 65. Which of the following actions will automatically refresh the cache for a specific subject area? A) Running a “Refresh Cache” command in the Catalog Manager. B) Editing the RPD file. C) Changing a repository variable. D) Restarting the WebLogic server. Answer: A Explanation: The Catalog Manager provides a “Refresh Cache” option for selected objects. Question 66. A “Dynamic Repository Variable” can be used in a filter expression because: A) Its value is static for the entire session. B) It resolves to a list of values at runtime. C) It is stored in the database as a column. D) It is only available to administrators. Answer: B Explanation: Dynamic variables execute a SQL query each time, providing a runtime list for filters.
