COG-112考古題分享

COG-112 Exam
IBM Cognos 8 BI Author
科目編號：COG-112
科目名稱：IBM Cognos 8 BI Author
題目數量：50
考試時間以分鐘為單位：60
所需的及格分數：74
Passquick考古題價格：$ 102.00 $ 28.50
COG-112 考試是IBM公司的 IBM Cognos 8 BI Author 認證考試官方代號，IBM Cognos 8 BI Author 認證作為全球IT領域專家 IBM 熱門認證之一，是許多大中IT企業選擇人才標準的必備條件。
IBM Cognos 8 Author這個證書說起來也只是Cognos一個入門級的證書而已了，認證主要針對創建報表，表報的filters和prompts，表報Drill-through的設定，bursting，以及Event Studio的使用等等
COG-112考古題：
6. The following report was created in Report Studio using a relational package and shows revenue by sales rep, city,
and country. What will the report show if the author creates a detail filter for Revenue>500,000 and applies the filter
AFTER auto aggregation?
A. Only reps who generated total revenue greater than 500,000.
B. Only cities that generated total revenue greater than 500,000.
C. Only countries that generated total revenue greater than 500,000.
D. Only reps who had individual sales transactions of greater than 500,000.
Answer: A
7. In Report Studio, what is true about a crosstab node?
A. It contains at least one nested crosstab node.
B. It contains at least one crosstab node member.
C. It contains more than one nested crosstab node.
D. It must contain more than one crosstab node member.
Answer: B
8. An author wants to apply formatting to a list report. In Report Studio, the author clicks a column in the list, clicks
Select Ancestor, and then clicks List Columns. In this situation, which of the following is true?
A. Formatting all columns will also format aggregate rows in the list.
B. Formatting all columns overrides formatting for an existing formatted column in the list.
C. Formatting all columns affects all subsequent objects added to the report page.
D. Formatting all columns ensures any new columns added to the list will have the same formatting.
Answer: D
9. An author wants to create a filter on this report to only show Product line totals larger than 1 billion. What
calculation is used to create this filter?
A. Detail filter as: [Total (Revenue)] for [Product line] >1000000000
Application = After auto aggregation
B. Detail filter as: [Total (Revenue)]>1000000000
Scope = Product line
C. Summary filter as: [Total(Revenue)]>1000000000
Scope = Product line
D. Summary filter as: [Total(Revenue)] for [Product line]>1000000000)
Application = After auto aggregation
Answer: C
10. In Report Studio, an author is using a relationally modeled package and wants to filter a report to only include
three specific products. If the author is not sure how to spell the product names, what is the fastest way to add the
product names to the filter expression?
A. Run the report with all product names and copy the product names.
B. Use the Select Multiple Values feature to search for the product names.
C. Add the product names from the Source tab in the Available components pane.
D. Add the product names from the Data Items tab in the Available components pane.
Answer: B
感謝Passquick帶來熱門IBM認證考試資料！