COG-112 exam at certinside

To best prepare you for your COG-112 certification exam, we now offer you the ultimate all in one COG-112 certification course packages that will cover all the COG-112 certification testing objectives for all COG-112 certification exams and levels.
1. 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
2. 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] >1000000000Application = After auto aggregation B. Detail filter as: [Total (Revenue)]>1000000000Scope = Product lineC. Summary filter as: [Total(Revenue)]>1000000000Scope = Product lineD. Summary filter as: [Total(Revenue)] for [Product line]>1000000000)Application = After auto aggregationAnswer: C
3. 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
4. In Report Studio, what is a baseline?A. A value in a list report that other values are compared against.B. A border in a crosstab that separates measures from aggregate totals.C. A constant value drawn on a chart to indicate major divisions in the data.D. A break point that keeps part of a report stationary while the user scrolls.Answer: C
5. 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: B6. The sales department requires a report that numerically compares the gross profit generated for all product lines in each territory. In Report Studio, which is the most appropriate report type?A. ListB. Chart C. CrosstabD. RepeaterAnswer: C
related exam:
cog-400