IBM Cognos Analytics Analyst Professional (C1000-191) Certification Sample Questions

Cognos Analytics Analyst Professional Dumps, C1000-191 Dumps, C1000-191 PDF, Cognos Analytics Analyst Professional VCE, IBM C1000-191 VCE, IBM Cognos Analytics Analyst Professional PDF The purpose of this Sample Question Set is to provide you with information about the IBM Cognos Analytics v12 Analyst - Professional exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the C1000-191 certification test. To get familiar with real exam environment, we suggest you try our Sample IBM Cognos Analytics Analyst Professional Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual IBM Certified Cognos Analytics v12 Analyst - Professional certification exam.

These sample questions are simple and basic questions that represent likeness to the real IBM C1000-191 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium IBM Cognos Analytics Analyst Professional Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.

IBM C1000-191 Sample Questions:

01. Each month the finance team emails an analyst a CSV of budget figures that exists nowhere in the warehouse or in any package. The analyst must show budget against actuals on a dashboard and expects a new file every month.

Which source type should the analyst use for the budget figures?

a) A data set created from the sales package and refreshed monthly by schedule

b) A relative time calendar on a date column in a data module

c) An uploaded file, replaced monthly with the new CSV

d) A data server connection configured to read the finance team's mailbox

02. On an OLAP package, a crosstab's row edge must show only the five products with the highest revenue, ordered from highest to lowest.

Which expression builds that edge?

a) filter(children([All Products]), [Revenue] > 5000000)

b) topCount(children([All Products]), 5, [Revenue])

c) rank([Revenue] for [Product])

d) head(children([All Products]), 5)

03. Authoring a crosstab on an OLAP package, an author drags the Region level of the Geography hierarchy onto the row edge, and later drags the single member Europe from the same hierarchy onto another crosstab's row edge.

What does each drag produce?

a) Neither can be dragged onto an edge; only measures are allowed there

b) The level produces a single summary row; the member produces its children on separate rows

c) The level produces one row per member of that level; the member produces one row for Europe

d) Both produce one row per region, because a member always expands to its whole level

04. Two reports on the same query both show a Customers column for each region. One shows far higher numbers than the other, though both use the same filters and the same date range.

What is the most likely cause?

a) One report applies its detail filter after auto aggregation

b) One report runs against a data set that is stale and the other against the live module

c) One report has Auto Group and Summarize turned off and repeats each region's rows several times

d) One report summarizes Customer with Count, counting every order row, while the other uses Count distinct

05. A scheduled report is emailed to the members of a sales team whose membership changes often. The author does not want to edit the schedule each time someone joins or leaves.

Which two configurations achieve that?

(Choose two.)

a) Save the output to the content store and rely on members to check it

b) Address the schedule's email delivery to a distribution list that the team maintains

c) Type each member's email address into the schedule's recipient field

d) Burst the report using a recipients data item that returns the current team members' email addresses from the data

06. In a crosstab on an OLAP source with a Time hierarchy of Year, Quarter and Month, a column must show year-to-date revenue for whichever month is on the row, accumulating from the first month of that month's year.

Which dimensional expression returns that value?

a) aggregate(currentMeasure within set periodsToDate([Year], currentMember([Time])))

b) running-total([Revenue] for [Year])

c) aggregate(currentMeasure within set parallelPeriod([Year], 1, currentMember([Time])))

d) total(currentMeasure within set [Month])

07. On a dashboard built on a Sales data module, a manager asks the Assistant to show product returns by month. The Assistant replies that it finds nothing matching returns. The Returns table exists, but in a separate Warranty data module that has not been added to the dashboard.

What should the analyst do?

a) Create a data set from the Sales module so the Assistant reads materialized data

b) Rephrase the question as show warranty by month so the Assistant matches the module name

c) Add the Warranty data module as a source of the dashboard so the Assistant can search its tables and columns

d) Turn on relationship detection in the Sales module so it discovers the Returns table

08. In a data module, an Orders table is related to a Calendar table on Date. After the relationship is added, a dashboard's total revenue is exactly three times the known figure. The Calendar table holds three rows for each date, one each for the calendar, fiscal and ISO week definitions.

Which two statements are correct about the cause and the remedy?

(Choose two.)

a) Each order row matches three Calendar rows, so its revenue is counted three times

b) Restrict the Calendar side to one row per date, for example by filtering to a single calendar type, before relating it to Orders

c) Change the relationship to an outer join so unmatched calendar rows are ignored

d) Set the Revenue column's aggregation to Average so the tripling cancels out across the three calendar rows

09. Query1 lists the customers who attended the spring product launch and Query2 lists the customers who placed an order in the following quarter. Both return the same Customer number and Customer name columns. Marketing wants only the customers who appear in both lists.

Which set operation produces that result?

a) An intersect of Query1 and Query2

b) A union of Query1 and Query2

c) An except of Query1 and Query2

d) A join of Query1 to Query2 with an outer join on both sides

10. Forty managers consume the same weekly report, and each wants it delivered at a time and in a format of their own choosing, without the author maintaining forty schedules.

Which distribution option fits?

a) Bursting on Manager with the output emailed to each

b) One schedule that saves the output to the content store for managers to open when they wish

c) Forty report views, each with a schedule saved by the author

d) Each manager subscribes to the report, choosing their own delivery time and format

Answers:

Question: 01 Answer: c	Question: 02 Answer: b	Question: 03 Answer: c	Question: 04 Answer: d	Question: 05 Answer: b, d
Question: 06 Answer: a	Question: 07 Answer: c	Question: 08 Answer: a, b	Question: 09 Answer: a	Question: 10 Answer: d

Note: For any error in IBM Certified Cognos Analytics v12 Analyst - Professional (C1000-191) certification exam sample questions, please update us by writing an email on feedback@edusum.com.