Page: 1
/ 7
Total 107 questions
Which statement is true about adding columns from the source package after modifying a query?
- A. Columns cannot be added from the source package to a report after adding an SQL object.
- B. Columns can be added from the source package to a report after modifying an SQL object.
- C. Columns cannot be added from the source package to a report after deleting an SQL object.
- D. Columns can be added from the source package to a report only before adding an SQL object.
Answer : B
Data Lineage is supported by which of the following?
- A. Reports based on packages.
- B. Only on reports based on Lists.
- C. Reports based on Data modules.
- D. Only data items defined in a Master data glossary.
Answer : A
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_rptstd_view_lineage_info.html
A report author is asked to create a list report and add data by loading it in Cognos Analytics "" Reporting.
Which option can be loaded?
- A. Packages or Data Modules
- B. Packages and Data Models
- C. Query Modules and data Items
- D. Dynamic Query Mode or Compatible Query Mode
Answer : A
Explanation: Add data to a report by loading packages or data modules in IBM Cognos Analytics - Reporting.
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/c_cr_rptstd_intrd_creating_a_report.html
An author wants to include new data in an existing Dashboard.
Which type of Data source can be used?
- A. Pivot tables
- B. Data Modules
- C. Published packages
- D. Framework Manager models
Answer : B
A report author wants to reduce the number of columns in a list by moving the related information into a single column.
What is the first action that needs to be performed?
- A. Insert a block into the column header.
- B. Right click the column header and unlock the cell.
- C. Modify the column header properties and unlock it.
- D. Click on the more button on the Application bar to unlock the report.
Answer : B
A company has upgraded all of the models & packages to use Dynamic Query Mode (DQM). There is a report that must reference query subjects from two different packages.
How can this be accomplished?
- A. The report author cannot create reports against multiple packages.
- B. The report author can add multiple packages as Data sources and write the report appropriately.
- C. The report author must use SQL nodes for all queries that reference the different query subjects and join them appropriately to get the desired results.
- D. The report author must use one SQL node of the queries and the package for the other query and join them appropriately to get the desired results.
Answer : B
A report author wants to create an Active report with a Static Deck/ Each card should show a Chart with differently-filtered data.
What should the Chart for each card be based on?
- A. An item that is a property of the page.
- B. A query item that is a property of the Chart.
- C. A unique query with a filter applied to the query.
- D. Reuse the same query with a filter applied to the query.
Answer : B
A user needs to display information using multiple graphics on a single page that is scrollable.
Which Dashboard template should be used?
- A. Tabbed
- B. Stacked
- C. Infographic
- D. Single page
Answer : C
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_ca_dshb.doc/wa_an_assembling_a_dashboard.html
A report needs to modify the Interactive Behavior within an Active Report.
Which button can be used?
A.
B.
C.
D.
Answer : D
Reference:
[3]
A report author wants to use a calculation which is not a string function to manipulate text.
Which function can be used?
- A. trim()
- B. lower()
- C. extract()
- D. substring()
Answer : B
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug.cogtr.doc/c_textfunctions_tr.html
A report author would like to reuse a logo across all existing reports.
Which object should be used?
- A. Template
- B. Bookmark
- C. Global Class
- D. Layout Component Reference
Answer : D
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/ t_cr_rptstd_frmat_rep_reuse_object.html#cr_rptstd_frmat_rep_reuse_object
A report author is considering which SQL syntax to use for accessing various Data sources.
What is the advantage of using one type of SQL syntax above another?
- A. Cognos SQL can use non-standard SQL.
- B. Cognos SQL works on any supported database.
- C. The performance is optimized across all related query subjects with Pass Through SQL.
- D. With Pass Through SQL and Native SQL, the SQL may not work on a different database.
Answer : C
The sales department has requested a change to a tabular account report and wants to be able to analyze the monthly amount of each Account name by Year.
The report author changed the original report on left to the report on the right.
How was this done?
- A. Select Year column and then use the toolbar button Convert to Crosstab.
- B. Select Year column and then use the toolbar button Pivot List Crosstab.
- C. Select Amount(month) column and then use the toolbar button Convert to Crosstab.
- D. Select Account name column and then use the toolbar button Pivot List To Crosstab.
Answer : A
A customer has a bar chart in a report that displays a steady increase in revenue by product line over time. The requirement is to graphically illustrate this progression in the data series without significantly the report.
How can this be done?
- A. Add a linear trendline to the chart.
- B. Add a polynomial trendline to the chart.
- C. Create and insert graphics to highlight the data points.
- D. Hide data values within the chart and make the bars larger.
Answer : C
A report author renders an Active Report as an TML file on the local computer.
Where are the Charts Created?
- A. All Charts are rendered in the client.
- B. All Charts are rendered on the server.
- C. Non-prompted Charts are rendered in the client.
- D. Only prompted Charts are rendered on the server.
Answer : A