IBM Cognos 8 Analytic Applications Developer
Q&A V3.20
The IBM Cognos 8 Analytic Applications Developer exam certifies that the successful candidate has the knowledge and skills necessary to create, configure, maintain, and extend IBM Cognos Analytic Applications using the IBM Cognos Adaptive Application Framework (AAF).
IBM Cognos 8 (6%)
Demonstrate basic knowledge of IBM Cognos 8 administration
Adaptive Application Framework Overview (8%)
Demonstrate knowledge of software architecture
Demonstrate knowledge of generic warehouse solution architecture
Demonstrate basic knowledge of how AAF stores data
Adaptive Warehouse (70%)
Demonstrate knowledge of Source modeling
Demonstrate knowledge of Warehouse modeling
Demonstrate knowledge of special Warehouse Objects and items
Demonstrate knowledge of Data Flow modeling
Demonstrate knowledge of AW Target FM Modeling
Describe Load Management concepts
Demonstrate knowledge of working with application content
Demonstrate knowledge of dimension History concepts
Adaptive Analytics (16%)
Describe how to create analytic reports
Demonstrate knowledge of Operational reports
Demonstrate knowledge of project administration
(C) Copyright 2006-2011 CertBible Tech LTD,All Rights Reserved.
Important Note
Please Read Carefully
Study Tips
This product will provide you questions and answers carefully compiled and written by our experts. Try to understand the concepts behind the questions instead of cramming the questions.
Go through the entire document at least twice so that you make sure that you are not missing anything.
Latest Version
We are constantly reviewing our products. New material is added and old material is revised. Free updates are available for 120 days after the purchase. You should check your member zone at PassGuide an update 3-4 days before the scheduled exam date.
Feedback
If you spot a possible improvement then please let us know. We always interested in improving product quality.
Feedback should be send to feedback@passguide.com. You should include the following:
Exam number, version, page number, question number, and your login ID.
Our experts will answer your mail promptly.
Be Prepared. Be Confident. Get Certified.
————————————————————————————————————————-
Sales and Support Manager
Sales Team: sales@passguide.com Support Team: support@passguide.com
———————————————————————————————————————
Copyright
Each pdf file contains a unique serial number associated with your particular name and contact information for security purposes. So if we find out that a particular pdf file is being distributed by you, CertBible reserves the right to take legal action against you according to the International Copyright Laws.
Question: 1
What do you call a single dimension that supports distinct logical uses in a warehouse model?
A. an outrigger dimension
B. a role-playing dimension
C. a self-join dimension
D. a bridge dimension
Answer: B
Question: 2
In which situation would you use a factless fact?
A. When numeric measurement values are not always available from the source system.
B. When the target warehouse is fully refreshed on a regular basis with numeric measurement values.
C. When business process events have no natural numeric measurement values.
D. When multi-grain measurement values will be stored on the fact table.
Answer: C
Question: 3
Which three connectivity types are required by Adaptive Warehouse to operate properly? (Choose three.)
A. a native (RDBMS) connection to the IBM Cognos 8 Content Store
B. a connection to your source data
C. a gateway URI connection to the IBM Cognos BI Server
D. a gateway URI connection to LDAP security services
E. a native (RDBMS) connection to your target warehouse database
Answer: B, C, E
Question: 4
What is a purpose of the Adaptive Application Framework (AAF) Runtime version?
A. to execute Adaptive Analytics Reports
B. to execute the Adaptive Warehouse User Interface (UI)
C. to deploy Adaptive Warehouse generated Framework Manager models
D. to execute Adaptive Warehouse (AW) load management scripts
Answer: D
Question: 5
A warehouse fact object called “CERTIFY” is populated. Which database object would contain the SID column references to the related dimensions?
A. CERTIFY_FX
B. CERTIFY
C. CERTIFY_DX
D. CERTIFY_MEASURES
Answer: D
Question: 6
Which two statements are correct about Row to Column Pivot Transformations? (Choose two.)
A. Row to Column Pivots convert multiple source row data into multiple columns.
B. Row to Column Pivots reduce the number of source rows processed into the target tables after the merge step.
C. Row to Column Pivots require the possible values for the pivot by item to be entered in the transformation object.
D. Row to Column Pivots can take a source table that links to itself to define the node-to-parent node relationship and populate each of the different levels.
Answer: A, C
Question: 7
Which three actions can reduce the time taken to load data into the warehouse? (Choose three.)
A. Select bulk load.
B. Apply a load partition.
C. Truncate work tables.
D. Reduce the commit interval.
E. Apply a change data capture (CDC) filter.
Answer: A, B, E
Question: 8
What can help to prevent unmatched member records from being created when loading data into the warehouse?
A. Create a custom hierarchy.
B. Include dependents in the load.
C. Load facts and then load dimensions.
D. Publish the target model.
Answer: B
Question: 9
The measure GL Balance Amount is stored on the fact table as a cumulative total of activity on an account. The business requirement is to add together GL Balances over different accounts and different responsibility centers, but it would be incorrect to add together GL Balances over different time periods. Which approach should be used in the FM target model to model the GL Balance Amount?
A. a model using the Time-state Rollup property on the Calendar
B. a model using an Allocation Rule on the measure
C. a model using a prompt macro on Time Period on the fact
D. a model using aggregate rules on the measure
Answer: D
Question: 10
A customer asks you how to handle a retail 4-4-5 calendar to report sales by sales period rather than by month. What should you tell the customer?
A. Create a custom Dimension object using your calendar data as a source.
B. Customize your calendar using the lunar calendar option and specifying 4-4-5 as the week pattern.
C. Update the calendar relationship to your sales fact to use a weekly grain; you can then add period grouping manually in the target model.
D. Create a new Custom Calendar object using a spreadsheet file with the 4-4-5 period definitions as a data source.
Answer: D
Question: 11
What are two situations where an External Procedure call can be applied and when can it be called in Adaptive Warehouse (AW)? (Choose two.)
A. on a dataflow, after data extraction but before data load
B. on an input source, before data extraction
C. on an input source, after data extraction
D. on a dataflow, after data load is complete
Answer: A, D
Question: 12
A change defined in the warehouse interface of Adaptive Warehouse needs to be reflected in the target model. Which two statements are correct? (Choose two.)
A. The target model will be synchronized to reflect the warehouse definitions during load management when publishing a package.
B. The target model is synchronized when switching from the warehouse target fields.
C. The target model is synchronized when the project is saved.
D. The target model can be synchronized manually using the “synchronize” action.
Answer: A, D
Question: 13
Users have entered some backdated dimension values in the source system and need the current information to be updated to reflect the changes. The attributes in the dimension are set to type History with an Effective Date field. How will Adaptive Warehouse handle updating the records already present in the warehouse?
A. AW will delete and reinsert the history records starting from the Effective Date to current.
B. AW will update the history records starting on the Effective date until it reaches a Carried-Forward flag = N.
C. AW will create a filter in the History Query Subject in the Database Layer to filter the old records.
D. AW will update the history records starting on the Effective Date by setting their Modified Flag to Y.
Answer: B
Question: 14
A customer requires a new fact called Project Commitments. The fact contains amounts of contracts and purchases made on a project. These amounts can be in many currencies since goods are often sourced from overseas. The customer also reports mostly in US dollars but also in Canadian dollars. The application already has a currency object defined. How should you use the currency object to convert commitments into US and Canadian dollars?
A. Check the existing currency object to make sure Canadian dollars is one of the reporting currencies. Ensure that the Commitment Amount measure column is designated as a Monetary Amount and the Currency Code item in the Commitment fact as a Currency Code in the Multicurrency Type property.
B. Check the existing currency object to make sure Canadian dollars is one of the reporting currencies. Add a multiplier to use the correct rate type — month end rate or average rate. Create a calculated measure for Commitments (Canadian dollars) and Commitments (US dollars currency).
C. Add a new currency object for Canadian dollar reporting. Define relationships between the currency code in the currency object and the currency code in the Commitment fact and create a calculated measure for Commitments (Canadian dollars).
D. Create a relationship between the Commitment fact and the existing currency object based on currency code and effective date. Synchronize the target model to generate new measures for base (US dollars) and alternate reporting currency (Canadian dollars).
Answer: A
Question: 15
Security requirements dictate that members of the “general” group have access to historical Sales Order fact data, but are not allowed to view Sales Order data for the current month. Other groups have access to all Sales Order fact data including the current period. You are required to create a single “Sales” FM package, Adaptive Analytics “Sales” Information Pack and set of reports. The single package, information pack and reports are to be used by multiple groups of users. All groups have access to the package using Report Studio.Which method of securing the sales data will ensure that only members of the “admin group” can see the Sales Order data for the current month?
A. Create two different measure dimensions in the warehouse — “Sales” and “Sales excluding current month”. Hide the “Sales” measure dimension for members of the “general” group.
B. Include a time filter as a security filter on the “Sales Order_” query subject in the Adaptive Warehouse target model.
C. Include a time filter as an Assignment Filter in Adaptive Analytics on the “Sales” Information Pack.
D. Do not allow members of the “general” group access to the “Sales” package. Create another package for the “general” group with a filter that excludes sales for the current month.
Answer: B
Question: 16
Which two statements are true about the data source merge? (Choose two.)
A. If the input source does not provide a mapping for a particular column, it will be set to 0 for numeric data types and a dash (-) for character data types.
B. Data will be read from the work table, ordered by the business key and the change date.
C. The load process will merge all rows sharing a common key value.
D. In the Combine step of the load, data from all multiple data sources will be written to a common work table that has all columns defined.
Answer: C, D
Question: 17
You have a business requirement to incorporate a new item in the warehouse. The new item represents comments captured against sales order line items. The new comments item is a large text field that is optionally captured at the time of order by the customer. The comments will be included in a report that shows all line item details for a prompted Sales Order Number. It will not be used in any other reports. The warehouse already contains a Sales Order fact that is defined at the line item level. How should the new comments item be incorporated into the warehouse?
A. Create a new dimension for Sales Order comments with business key Sales Order Number and Sales Order Line Item. Include the comment as an item in the new dimension.
B. Create a new fact warehouse object for Sales Order comments with business key Sales Order Number and Sales Line Item. Include the comment as an item in the new fact.
C. Add a Comment item to the Sales Order fact. Set the Is Degenerative Dimension property to “Yes”
D. Include the Comment item on the Customer dimension. Set the Dimension History Type to “History”.
Answer: C
Question: 18
The history dimension Job is used as both a dimension and a fact. A report is created that combines measures from Job Measures and the Job Action fact. The report shows [Job Measures].[Active Job Count] and [Job Action].[Hire Count] by month. There is an error in the report. The Active Job Count is incorrect. Instead of showing the count of all active jobs in each month, the report is showing the count of active jobs that were involved in a Job Action in each month.What caused this error?
A. The measure expression for Active Job Count is incorrectly defined as [Job History].[Active Job Count]. It should be multiplied by [Job History Measures].[Fact Multiplier].
B. There is a missing relationship between [Job] and [Job Action].
C. The regular aggregate property for Active Job Count is incorrectly defined. It should be set to “Calculated”.
D. The usage property of Active Job Count is incorrect. It should be “unknown”.
Answer: A
Question: 19
Where do you define a Change Data Capture Filter?
A. Warehouse Object
B. Input Source
C. Load Management
D. Lookup
Answer: B
Question: 20
Click the Exhibit button.The exhibit represents the full set of data in an unbalanced Department Tree rollup table from the source system. The “Child Department” column represents the department code while the “Parent Department” column is the department to which the child department reports.What is the minimum number of levels that need to be defined in a Parent-Child Hierarchy transformation object to allow users to see the complete hierarchy?
A. 2
B. 3
C. 4
D. 5
Answer: C
Question: 21
Which statement is correct about Business Keys?
A. Business Keys are optional for fact warehouse objects.
B. Business Keys are optional for dimension warehouse objects.
C. Business Keys are optional for dimension warehouse objects that are not involved in any references.
D. Business Keys are mandatory for fact and dimension warehouse objects.
Answer: D
Question: 22
A warehouse provides reporting on Sales Amounts tracked by Month, Product, Rep, and Customer; and Demand Forecasts tracked by Month and Product. There is a need to produce a report that shows Sales Amount and Demand Forecast by Product and Month.Which warehouse design meets these requirements with minimal redundant data storage?
A. separate facts (Sales and Demand Forecast) with conformed Time and Product Dimensions.
B. a single fact at the grain of Sales with Demand Forecasts stored in the same fact, stored against a default Rep and Customer
C. a single fact at the grain of Sales with Demand Forecasts stored in the same fact allocated between Reps and Customers
D. separate facts (Sales and Demand Forecast) with a reference between the two facts
Answer: A
Question: 23
You have been asked to include a new calculation in the warehouse. The calculation is the ratio of Sales to Marketing Spend. Sales spend and Marketing spend are two different measures in two separate facts. When querying data to compute the ratio, the ratio must be computed after Sales spend and Marketing spend have been aggregated.Where in the Adaptive Application Framework should the calculated ratio be defined?
A. Define the ratio in the source Framework Manager model in Adaptive Warehouse.
B. Define the ratio as a Persisted Expression as part of a dataflow in Adaptive Warehouse.
C. Define the ratio in the target Framework Manager model as a stand-alone calculation in Adaptive Warehouse.
D. Define the ratio in Adaptive Analytics.
Answer: C
Question: 24
You are loading an order activity fact table with one data flow (Order Activity Data Flow), one input source (Order Activity Input Source) and two lookups (Customer Discount Lookup and Item Price Lookup). You need to implement daily incremental load. You have decided to use the change data capture (CDC) feature.Which statement correctly identifies the number and type of CDC filters that you will create to incrementally load the order activity fact table?
A. One CDC filter; create a CDC filter for the Order Activity Input Source based on the Order Change Date.
B. One CDC filter; create a CDC filter for the Order Activity Data Flow based on the Order Change Date.
C. Three CDC filters; create a CDC filter for the Order Activity Data Flow based on the Order Change Date and create a CDC filter for each Lookup.
D. Three CDC filters; create a CDC filter for the Order Activity Input Source based on the Order Change Date and create a CDC filter for each Lookup.
Answer: A
Question: 25
You are modeling a snowflaked Employee dimension. Employees are related to locations. Each Employee has a work location and a home location. Both of these locations are relevant for reporting purposes.How do you model this in Adaptive Warehouse (AW)?
A. Create a single AW reference between Employee and Location based on the employee’s Work Location. Modify the generated Framework Manager relationship to include a prompt which allows selection of Work or Home location at runtime.
B. Create a single AW reference between Employee and Location based on the employee’s Work Location. Modify the generated Framework Manager model to include an additional copy of the Location dimension. This copy represents Home Location. Manually create a relationship between the Home Location and Employee.
C. Create two Location dimensions in AW — one for work location and another for home location. Create a separate relationship from the Employee dimension to each of the two Location Dimensions.
D. Create two AW references between Employee and Location — one based on the employee’s Work location and the other based on Home location.
Answer: D
Question: 26
Click the Exhibit button.In Adaptive Warehouse, a user uses the “Import from Content Library” to import content into a newly created project. Upon selecting the Finish button, they are presented with the Data Source Mapping window. Referring to the exhibit, what is the purpose of this screen?
A. to map the Cognos Data Sources to the source and target native database names
B. to provide AW with the names of the Cognos Data Sources for all the required target databases
C. to map the Cognos Data Sources to the ERP’s source system only
D. to provide AW with the names of the Cognos Data Sources that will be used to read from an ERP source and other sources
Answer: D
Question: 27
You are creating an extract for a fact table and have decided that you should use two input sources to populate the table. When multiple input sources are used, the data is merged for all input sources on the defined business key. Which statement is true about the business key merging process used by the input sources?
A. Data values are not affected by the order of the records being processed.
B. Business key merges use the last non-NULL value in the merged record set.
C. Merge operations do not involve sorting data.
D. Each input source is not required to be mapped to the defined business key.
Answer: B
Question: 28
When the same filters need to be applied in different reports or queries, it is advantageous to define them in the target model to make them available on demand. Where can these filters be defined?
A. in the Adaptive Warehouse (AW) data warehouse interface, using an Output Filter transformation
B. in the Database Layer of the target model
C. in the business layer of the target model
D. in the target model package definition
Answer: C
Question: 29
You and another developer are working on separate warehouse objects which you plan on eventually bringing together into a master project. At one point during the implementation, your team member helps you by creating a new dataflow for the Customer dimension. You want to merge your Customer dimension and your team member’s Customer dimension object into a single master Customer dimension inside your Master project.Which two solutions describe the steps that should be performed to ensure that you preserve the data flows from both Customer dimension objects? (Choose two.)
A. Import the first Customer dimension and rename the dataflow to a unique name and save the project. Then import the second Customer dimension from a different content library and use the Full Upgrade Conflict Resolution option.
B. Import the first Customer dimension and rename the dataflow to a unique name and save the project. Then import the second Customer dimension from a different content library and use the Partial Upgrade Conflict Resolution option.
C. Import the first Customer dimension and save the project. Then import the second Customer dimension from a different content library and use the Full Upgrade Conflict Resolution option.
D. Import the first Customer dimension and save the project. Then import the second Customer dimension from a different content library and use the Partial Upgrade Conflict Resolution option.
Answer: A, B
PassGuide-IT Certication Dumps
- Free passguide 000-203 test exam
- Free passguide hp0-d07
- Free passguide lx0-101 pdf
- Free passguide 642-832
- Free passguide hp2-e27
- Free Symantec ASC-066
- Free passguide new exams 201004
- Free passguide new exams 200912
- Free passguide 642-813
- Free passguide hp0-j34
- Free passguide newyear 2010 new exams
- Free passguide new it exams 201002
- Free passguide 642-902
- Free passguide new exams 2010
- Free dmdi201
Comments are closed