Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?
A. Fact-based
B. Time-based
C. Mixed
D. Complex
Answer: C
Q2. An integrated BI tools business case can be built around which three options?
A. Scalability
B. Fault tolerance
C. Cost Savings
D. Development efficiency
Answer: ACD
Q3. One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.
A. Multiple SQL queries are performed
B. Two SQL queries are performed to get data from both tables
C. A single SQL query is performed to get data from both tables
D. No SQL queries are performed against the source tables
Answer: C
Q4. Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?
A. Navteq
B. TeleAtlas
C. Google
D. ESRI
Answer: C
Q5. Derived metrics are_____.
A. Derived from other logical columns
B. Derived from other physical columns
C. Used to apply pre-aggregation calculations to measures
D. Used to rename measures to user-friendly names
Answer: A
Q6. Which of the following native features of Essbase are not supported in OBIEE 11g?
A. Member Alias
B. Alternate Hierarchies
C. Dynamic Time Series
D. Parent/Child-based Hierarchies
Answer: C
Q7. Which three options apply to FMW Application Roles?
A. Provide an indirection between LDAP groups and BI roles
B. Can be exported / moved between FMW11g environments
C. Are created and managed by using the WLS Admin Console and FMW Control
D. Can be created by using BI Administrator Client and "pushed" to WLS Admin Console
E. Secures RPD permissions but NOT Web Catalog (webcat) permissions
Answer: ACE
Q8. When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?
A. The analyst mustfirstwrite DML (Data Manipulation Language) scriptstocreate the aggregate table.
B. TheAggregate Persistence Wizard enables youto automate the creation of physical aggregate tables and theircorresponding objects in the repository.
C. Job Managercanbe used to run the Aggregate Persistence script.
D. TheExtractionTransformation and Loading process creates the aggregate tables.
Answer: BC
Q9. When designing a Star Schema, which option does not apply?
A. The facts are quantifiable.
B. The fact has several foreign keys that are primary keys in the dimensional table
C. Fact table is joined to the related dimensional tables.
D. Dimensional tables are normalized.
E. Dimensional tables have one attribute primary key as Product_ID for products.
Answer: D
Q10. An organization has its employees' names in an Employees table, and information about their jobs in a Jobs table.
However, an organization's employees can have multiple jobs, and the same job can be performed by multiple employees. This situation would result in a many to-many relationship between the Employees and Jobs tables. How can the many to-many relationship issue be resolved?
A. By modeling the many to many relationshipin the business model
B. By creating a bridge table that represents one employee doing one job, with several rows for an employee who has several jobs
C. By creating the many to many join in the physical model
D. By creating alogical table source (LTS) thatjoins the Employees and Jobs tables
Answer: B
Q11. When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly?
A. The lowest level of aggregation
B. The highest level of aggregation
C. Multiple levels of aggregation
D. Independently from aggregation level
Answer: B
Q12. Which of the following characteristics pertain to a "ragged" hierarchy?
A. It can only be stored in an XML structure.
B. A branch of the hierarchy may have a different number of levels than other branches.
C. All values can have a maximum of six levels.
D. It creates multiple levels of hierarchy in the databasetable.
Answer: B
Q13. The three metadata layers are an important concept of the BI Server. Which statement is incorrect?
A. The physical layer defines the objects and relationships that the OracleBIServer needs to writenative queries against each physical data source.
B. Separating the logical of the application from the physical model provides the ability to federate multiple physical sources to the same logical object.
C. The model and mapping layer define the business or logical model of the data. This layer determines the analytic behavior seen by users.
D. Thepresentation layer defines the relationship thatis needed to create the DML.
Answer: D
Q14. Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
A. OLAP cubes eliminate the need for a large number of aggregate tables.
B. OLAP cubes are stored outside of the database in highly optimized file structures.
C. OLAP cubes can be easily transported from database to database.
D. OLAP cubes can be queried by using SQL.
Answer: D
Q15. If a customer is planning on building a data warehouse, how would you describe data warehousing to the customer?
A. The data in the data warehouse describes events and statuses of business processes, products and services, goals and organizational units, and generally mirrors every aspect of the structure and behavior of the organization.
B. Data warehouses can only be based on multidimensional data modeling.
C. Application based data warehouses can be bought off the shelf and used without any tweaking.
D. Data warehouse projects are usually implemented within two weeks.
Answer: A
Q16. Point-and-click generation of case statement logic can be accessed via which option?
A. Column Formula-> Bins tab
B. Compound Layout
C. Column Properties -> Conditional Format tab
D. Advanced Tab
E. Subject Area metrics
Answer: A
Q17. Identify the correct mode to use when opening the web catalog while performing security settings modifications and migrations.
A. Online
B. Offline
C. Managed
D. UnManaged
Answer: A
Q18. The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?
A. Start and Stop BI Services
B. Build Aggregate Queries
C. Create SummaryTables
D. Manage user logins
Answer: A