Following are the sample questions from our entire C2090-621 IBM Cognos Analytics Author V11 Dump. The main dump contains 100 plus questions with explanations. You can try the samples if you like them; you can buy the entire course by visiting the following link.

Question 1: A report author creates the following filter in a report: [Region] in (‘Americas’,’Asia Pacific’) Which type of filter was created?

  1. Parameterized
  2. Custom based on data item
  3. Combined
  4. Advanced

Let’s find the correct answer for the above question. To find out the correct answer, we will first remove the incorrect options. 

Parameterized: The first option is the parametrized filter needs a parameter in the expression. Instead of a parameter, we have hardcoded values in the expression. We can safely ignore this option.

Custom based on data item: When we are using combined based on data item, we use a front end user interface to create a new filter. In such a case, the front end dialog creates a condition using the “INCLUDE” operator. But in the expression, it is an “IN” operator. Based on this, it is not the correct option.

Combined: Combined filter is used to combine one or more checks using the “AND” or “OR” operator. The given filter is simple with a single check using the “IN” operators, so we can also ignore this option. 

Advanced: We already removed all the incorrect options. So yes, “Advanced” is the correct answer for this question.

Correct Answer: Advanced

Question 2: What can be done when using a SQL Object when not using a Stored Procedure.

  1. Update a database.
  2. Insert rows into database.
  3. Delete rows in a database.
  4. Select rows from a database.

Usually, a reporting tool is only for display information, not for performing a database operation. Let’s try to find the correct option. As we mentioned in the first line, a reporting tool is used to display information, so “Select rows from a database” is possible. For the rest of the options, we are performing data modification. As per the question, we don’t need to use the Stored Procedure in the SQL object. When we are using SQL Object without “Pass-Through,” we cannot use any data modification query. But with small tweaks and tricks, it is possible to perform all the mentioned actions. We are not here to discuss any tweaks and tricks, so “Select rows from a database” is the correct option.

Correct Answer: Select rows from a database

Question 3: A report author has to create a Crosstab report with Region, and Product data in the rows of the crosstab can be created in two different ways, as shown below.

Which Crosstab/Crosstabs is/are discontinuous Crosstab/Corsstabs?