Exam Code: C2090-635 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM Cognos 10 BI OLAP Developer
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-635 Exam.
2021 May C2090-635 Study Guide Questions:
Q21. To add dimensional data to an existing model, how can metadata be leveraged from other published OLAP packages?
A. Insert an OLAP package in the data source list.
B. Import a PowerCube as a data source.
C. Add dimensions from an OLAP package in the dimension map.
D. Add a data source query using a Cognos 10 OLAP report.
Answer: C
Q22. What can a developer set up to analyze actual, planned, and forecasted budget information that do not rollup into a single root category?
A. Scenario dimension
B. Calculated category
C. Special category
D. Exception dimension
Answer: A
Q23. A dimension organizes all the regions by Country and City. Disregarding the hierarchical organization, how can the five best performing regions be grouped?
A. Create a scenario dimension.
B. Add an alternate drill-down path.
C. Add a special category.
D. Create a subdimension.
Answer: C
Replace C2090-635 exam question:
Q24. To control access to content for users that have similar responsibilities and privileges,where should security be applied?
A. Data source
B. Role
C. User
D. Namespace
Answer: B
Q25. Where should fact queries against OLAP sources come from?
A. A flat file
B. An .iqd file
C. A Cognos 10 report
D. A Cognos 10 package
Answer: A
Q26. Which of the following will help improve processing time when Transformer queries the data?
A. Use normalized structural data sources.
B. Separate structural and transactional information in multiple data sources.
C. Combine structural and transactional information into one data source.
D. Define dimensions within a transactional data source with unique values.
Answer: B
Exact C2090-635 rapidshare:
Q27. What objects can be created within the Cognos Namespace?
A. Roles and users
B. Groups and roles
C. Groups and users
D. Members
Answer: B
Q28. For performance reasons, what is the best parent-child ratio for categories in each level?
A. 1:10 or less
B. 1:11 or more
C. 5:1 or less
D. 10:1 or more
Answer: A
Q29. What does the developer specify when creating a test build that uses a subset of the source data?
A. The number of categories.
B. The dimensions to include in the cube.
C. The number of records.
D. The measures to include in the cube.
Answer: C
Q30. What can be created to provide new insight into the data if Margin Ranges are defined as Low, Medium, and High, based on a calculated column using the revenue and cost columns?
A. Scenario dimension
B. Exception dimension
C. Special category
D. Calculated category
Answer: B