QUESTION

Prévia do material em texto

QUESTION: 1
Which of the following can result in poor report performance?
A. reports with filters
B. models with outer joins and cross joins
C. queries with database only processing
D. an optimized metadata model
Answer(s): B
Hide Solution Next Question
QUESTION: 2
A Conditional format may be set on a List object in a report, generated and processed but is hidden from view?
A. Show/Hide Variable
B. Hidden Variable
C. Render Variable
D. Style Variable
Answer(s): C
Hide Solution Next Question
QUESTION: 3
In which two ways can a specific visualization in a dashboard be filtered?
A. A developer can only keep or exclude data points within an axis.
B. A developer can create a Calculation within the dashboard that will filter a specific visualization.
C. A developer can also add a local filter to filter a column or to define a filter condition.
D. A developer can build an embedded filter in a data module.
E. A developer can keep or exclude a few data points in the visualization.
Answer(s): A,B
Hide Solution Next Question
QUESTION: 4
A developer can make a Cognos PowerCube available to end users by creating a package and publishing it. From which three components is this possible?
A. Administration console
B. PowerPlay Client
C. PowerPlay Studio
D. Framework Manager
E. Transformer
F. Microsoft Studio
Answer(s): A,D,E
Reference:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.do c/c_powercubes_ds.html
QUESTION: 5
Where does a developer change which package is marked as the default package in a report?
A. on the package properties
B. on the query properties
C. on the context menu for a package
D. on the report properties
Answer(s): D
Hide Solution Next Question
QUESTION: 6
A Framework Manager model may be designed to incorporate Dimensionally Modeled Relational (DMR) objects, designed to offer the end user OLAP behavior when navigating dat
A. Which of the following statements is valid when designing DMR structures in Framework Manager?
B. Measures and Dimensions can reside in the same query subject.
C. The DMR structures need to resemble the objects in the star schema.
D. The order of the Determinants drives the hierarchy levels.
E. Each level in a hierarchy must reference a text-based attribute for its caption.
Answer(s): A
Hide Solution Next Question
QUESTION: 7
After upgrading from Cognos version 10 what needs to be selected in order to create a data module on a data server?
A. Select "Allow web-based modeling" in Cognos Configuration when starting the server
B. Select "Allow web-based modeling" in the Cognos installer when upgrading the server components.
C. Under the Data Server Connection in the Administration Console configuration select "Allow Framework Manager".
D. Under the Data Source Connection in the Administration Console configuration select "Allow web- based modeling".
Answer(s): B
Hide Solution Next Question
QUESTION: 8
Which of the following is true about integration with collaboration platforms?
A. Integration with any collaboration platform can be used with report objects but not dashboard objects.
B. Integration with IBM Connections is si
C. A link to a report in "my content" can be shared to a team Slack channel if the integration is enabled.
D. Integration with Slack is supported.
Answer(s): D
Hide Solution Next Question
QUESTION: 9
In an Exploration 'Data relationships' view, what does the thickness of the lines between data items represent?
A. the statistical strength of the relationship between the data items
B. the flow of information between categories, ie. money transfers between countries
C. the cardinality of one data item when grouped by another, ie. thicker signifies more unique values
D. the weighted average of each measure value compared with other measures
Answer(s): A
Reference:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_explor ations.doc/ca_explore_relationship_diagram.html
Hide Solution Next Question
QUESTION: 10
Which two of the following statements are true when creating a Drill-through for a visualization in a dashboard?
A. A developer can create Drill-throughs to a specific story that is created.
B. A developer can create a Drill-through to a Webpage.
C. One can pass selected data points to the target Drill-through as long as its data source uses the same values.
D. A developer can create Drill-throughs to other dashboards and reports.
E. Each visualization can only have a single Drill-through.
Answer(s): C,D
Hide Solution Next Question
QUESTION: 11
When a developer needs to share dashboard content with another application, the Share option provides which benefit?
A. the ability to export the dashboard to Excel
B. the ability to generate the HTML to create an iFrame and reference the dashboard
C. the ability to export the dashboard directly to SharePoint.
D. the ability to send a notification to a phone
Answer(s): D
QUESTION: 12
When Insights are turned on what are all of the generated outcomes, depending on the visualization selected ?
A. Average, Predictive Strength, Fit Line, Meaningful Difference and most frequent values
B. Average, Standard Deviation, Best Fit values
C. Average, Max and Min values
D. Top five and Bottom Five values
Answer(s): B
QUESTION: 13
To change the text item in a list column title or the data in the column body of a list object in a report, what first needs to happen?
A. Select the cell and change the data format.
B. Click on the Lock Page Objects icon to unlock the report.
C. Select one of the cells and from the menu click Select Columns Style or Select Columns body style.
D. Select the cell and change the Box Type to None.
Answer(s): C
Hide Solution Next Question
QUESTION: 14
The default output Format for a report may be set on which of the following two items?
A. Query
B. Visualization
C. Report
D. Report Folder
E. Report View
Answer(s): A
Hide Solution Next Question
QUESTION: 15
To display HTML report output directly in the body of an emailed report, which of the following is required in the delivery options pane?
A. Select "Attach the report" and leave the email body blank.
B. Select "Save report".
C. In the email body, choose "Display a report" and follow the dialog box instructions
D. Select "Include a link to the report''
Answer(s): C
QUESTION: 16
To create a Layout Component Reference in a report, which object property needs to be provided?
A. Conditional Reference
B. Label
C. Name
D. Render Variable
Answer(s): C
QUESTION: 17
Which is true about creating a context filter for a crosstab report using a dimensional data source?
A. it changes the measure values and the items in the rows and columns
B. it is applied after aggregation and changes the rows and columns
C. it changes the measure values and suppresses zeros
D. it filters only the measure values, not the items in the rows and columns
Answer(s): C
Hide Solution Next Question
QUESTION: 18
What advantage does multidimensional report writing have on query maintenance for complex queries?
A. There is no need to use calculations as the data source contains all the required data items.
B. Fewer queries are required and the need for unions of queries is reduced due to the flexibility of MDX.
C. Unions and Joins are always required for queries making it easier for a developer to understand the query intent.
D. There is no advantage and multidimensional query constructs should be avoided.
Answer(s): B
Hide Solution Next Question
QUESTION: 19
In a Data Module a developer creates a joined view from two tables (a and b) and then joins this to another table (c). What would be the execution logic in the database?
A. All queries are collapsed and a standard join across all three tables (a, b, c) is performed.
B. The columns used in table (c) are are joined on the key to table (b) first and then the results are post-joined to table (a).
C. It makes no difference to the execution as a joined view is only used to group data itemsin a logical manner to help the business user find their data.
D. The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).
Answer(s): D
Hide Solution Next Question
QUESTION: 20
What is the significance of 'Clothes' in the following filter expression of a report query? [Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#
A. 'Clothes' is the default text to include in the generated query at runtime.
B. The string 'Clothes' will precede the text of the prompt value selected at runtime.
C. The string 'Clothes' will be appended to the end of the text of the prompt value selected at runtime.
D. 'Clothes' is a required value to include in the generated query at runtime.
Answer(s): C
QUESTION: 21
What benefit does the Cognos Analytics integration with Jupyter Notebooks provide a developer?
A. Weather data can be used from the Jupyter service to enrich information and help identify trends Example: Ice cream sales on sunny days.
B. A Developer can augment Cognos Analytics with Python and data science libraries as well as embed output in a dashboard to provide the end user with greater insight.
C. A Developer can add notes to content to better describe to an end user what data is available and how calculations work.
D. Cognos Analytics does not integrate with Jupyter Notebooks.
Answer(s): D
Hide Solution Next Question
QUESTION: 22
What is the effect of changing the Default measure property of a Crosstab in a report if a measure is already set by one of the existing edges?
A. the Crosstab values remain the same and the Crosstab comer displays the Default measure's name
B. the Default measure replaces the existing measure in the Crosstab edges
C. the Default measure is displayed in the Crosstab intersections
D. an error is produced
Answer(s): A
Hide Solution Next Question
QUESTION: 23
A developer is given the task of creating an information panel to be displayed in the foyer of the office. Which Cognos Analytics capability gives the best impact with minimal work?
A. Story played in Kiosk mode with a loop
B. Bespoke report using JavaScript
C. Cognos Viewer Report
D. Dashboard based on Exploration content
Answer(s): C
Hide Solution Next Question
QUESTION: 24
A dashboard developer notices that Age is available in the sourced data module. A request has been made to 'bucket' those age values into 5 groups, Ages 0-6, 7-12, 13-21, 22-55, and 55 and over. How would one define this logic in the source data module?
A. set range values in the data module
B. use the Create new table feature
C. select the Age column, and select Create data group
D. define a Case..When calculated attribute in the dashboard
Answer(s): A
QUESTION: 25
After adding a prompt to a relational sourced report it is decided that the consumers require multi- select functionality instead of a single-select. What two modifications must be made to the report?
A. Change the Filter property Multi-select to Yes
B. Change the Cascade source property of the Prompt to represent more than one value.
C. Change the Prompt property Usage to Select-many.
D. Change the Filter expression of the Query from "=" to use "in".
E. Change the Prompt property Multi-select to Yes.
Answer(s): C,D
Hide Solution Next Question
QUESTION: 26
Which dashboard formatting option would be used to take several images and text objects and combine them into one object to enable ease of movement and/or alignment?
A. Group objects
B. Layer objects
C. Combine objects
D. Pack objects
Answer(s): A
Hide Solution Next Question
QUESTION: 27
How might a report output type of PDF be secured?
A. by setting a password in the schedule PDF options
B. by giving the PDF a name that starts with "confidential'
C. by selecting the "Secure this Report" option in the report properties
D. by specifying a PDF encryption code in the schedule settings
Answer(s): C
Hide Solution Next Question
QUESTION: 28
How does Dynamic Query Analyzer assist in troubleshooting?
A. troubleshooting Data Modules
B. analyzing Dynamic Reports
C. analyzing packages that have Dynamic Queries
D. providing graphical representations for the query logs produced by DQM queries
Answer(s): A
Question: 1
Which of the following can result in poor report performance?
A. reports with filters
B. models with outer joins and cross joins
C. queries with database only processing
D. an optimized metadata model
Answer: B
Question: 2
A Conditional format may be set on a List object in a report, generated and processed but is hidden
from view?
A. Show/Hide Variable
B. Hidden Variable
C. Render Variable
D. Style Variable
Answer: C
Question: 3
In which two ways can a specific visualization in a dashboard be filtered?
A. A developer can only keep or exclude data points within an axis.
B. A developer can create a Calculation within the dashboard that will filter a specific visualization.
C. A developer can also add a local filter to filter a column or to define a filter condition.
D. A developer can build an embedded filter in a data module.
E. A developer can keep or exclude a few data points in the visualization.
Answer: AB
Question: 4
A developer can make a Cognos PowerCube available to end users by creating a package and
publishing it. From which three components is this possible?
A. Administration console
B. PowerPlay Client
C. PowerPlay Studio
D. Framework Manager
E. Transformer
F. Microsoft Studio
Answer: ADE
Question: 5
Where does a developer change which package is marked as the default package in a report?
A. on the package properties
B. on the query properties
C. on the context menu for a package
D. on the report properties
Answer: D
Question: 6
A Framework Manager model may be designed to incorporate Dimensionally Modeled Relational
(DMR) objects, designed to offer the end user OLAP behavior when navigating dat
a. Which of the following statements is valid when designing DMR structures in Framework
Manager?
A. Measures and Dimensions can reside in the same query subject.
B. The DMR structures need to resemble the objects in the star schema.
C. The order of the Determinants drives the hierarchy levels.
D. Each level in a hierarchy must reference a text-based attribute for its caption.
Answer: A
Question: 7
After upgrading from Cognos version 10 what needs to be selected in order to create a data module
on a data server?
A. Select "Allow web-based modeling" in Cognos Configuration when starting the serverhttps
B. Select "Allow web-based modeling" in the Cognos installer when upgrading the server
components.
C. Under the Data Server Connection in the Administration Console configuration select "Allow
Framework Manager".
D. Under the Data Source Connection in the Administration Console configuration select "Allow webbased
modeling".
Answer: B
Question: 8
Which of the following is true about integration with collaboration platforms?
A. Integration with any collaboration platform can be used with report objects but not dashboard
objects.
B. Integration with IBM Connections is si
C. A link to a report in "my content" can be shared to a team Slack channel if the integration is
enabled.
D. Integration with Slack is supported.
Answer: D
Question: 9
In an Exploration 'Data relationships' view, what does the thickness of the lines between data items
represent?
A. the statistical strength of the relationship between the data items
B. the flow of information between categories, ie. money transfers between countries
C. the cardinality of one data item when grouped by another, ie. thicker signifies more unique values
D. the weighted average of each measure value compared with other measures
Answer: A
Question: 10
Which two of the following statements are true when creating a Drill-through for a visualization in a
dashboard?
A. A developer can create Drill-throughs to a specific story that is created.
B. A developer can create a Drill-through to a Webpage.
C. One can pass selected data points to the target Drill-through as long as its data sourceuses the
same values.
Questions and Answers PDF 4/19
https://www.validexamdumps.com/C1000-065.html
D. A developer can create Drill-throughs to other dashboards and reports.
E. Each visualization can only have a single Drill-through.
Answer: CD
Question: 11
When a developer needs to share dashboard content with another application, the Share option
provides which benefit?
A. the ability to export the dashboard to Excel
B. the ability to generate the HTML to create an iFrame and reference the dashboard
C. the ability to export the dashboard directly to SharePoint.
D. the ability to send a notification to a phone
Answer: D
Question: 12
When Insights are turned on what are all of the generated outcomes, depending on the visualization
selected ?
A. Average, Predictive Strength, Fit Line, Meaningful Difference and most frequent values
B. Average, Standard Deviation, Best Fit values
C. Average, Max and Min values
D. Top five and Bottom Five values
Answer: B
Question: 13
To change the text item in a list column title or the data in the column body of a list object in a report,
what first needs to happen?
A. Select the cell and change the data format.
B. Click on the Lock Page Objects icon to unlock the report.
C. Select one of the cells and from the menu click Select Columns Style or Select Columns body style.
D. Select the cell and change the Box Type to None.
Answer: C
Question: 14
The default output Format for a report may be set on which of the following two items?
A. Query
B. Visualization
C. Report
D. Report Folder
E. Report View
Answer: A
Question: 15
To display HTML report output directly in the body of an emailed report, which of the following is
required in the delivery options pane?
A. Select "Attach the report" and leave the email body blank.
B. Select "Save report".
C. In the email body, choose "Display a report" and follow the dialog box instructions
D. Select "Include a link to the report’’
Answer: C
Question: 16
To create a Layout Component Reference in a report, which object property needs to be provided?
A. Conditional Reference
B. Label
C. Name
D. Render Variable
Answer: C
Question: 17
Which is true about creating a context filter for a crosstab report using a dimensional data source?
A. it changes the measure values and the items in the rows and columns
B. it is applied after aggregation and changes the rows and columns
C. it changes the measure values and suppresses zeros
D. it filters only the measure values, not the items in the rows and columns
Answer: C
Question: 18
What advantage does multidimensional report writing have on query maintenance for complex
queries?
 A. There is no need to use calculations as the data source contains all the required data items.
B. Fewer queries are required and the need for unions of queries is reduced due to the flexibility of
MDX.
C. Unions and Joins are always required for queries making it easier for a developer to understand
the query intent.
D. There is no advantage and multidimensional query constructs should be avoided.
Answer: B
Question: 19
In a Data Module a developer creates a joined view from two tables (a and b) and then joins this to
another table (c). What would be the execution logic in the database?
A. All queries are collapsed and a standard join across all three tables (a, b, c) is performed.
B. The columns used in table (c) are are joined on the key to table (b) first and then the results are
post-joined to table (a).
C. It makes no difference to the execution as a joined view is only used to group data items in a
logical manner to help the business user find their data.
D. The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).
Answer: D
Question: 20
What is the significance of 'Clothes' in the following filter expression of a report query?
[Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#
A. 'Clothes' is the default text to include in the generated query at runtime.
B. The string 'Clothes' will precede the text of the prompt value selected at runtime.
C. The string 'Clothes' will be appended to the end of the text of the prompt value selected at
runtime.
D. 'Clothes' is a required value to include in the generated query at runtime.
Answer: C
Question: 21
What benefit does the Cognos Analytics integration with Jupyter Notebooks provide a developer?
A. Weather data can be used from the Jupyter service to enrich information and help identify trends
Example: Ice cream sales on sunny days.
B. A Developer can augment Cognos Analytics with Python and data science libraries as well as
embed output in a dashboard to provide the end user with greater insight.
C. A Developer can add notes to content to better describe to an end user what data is available and how calculations work.
D. Cognos Analytics does not integrate with Jupyter Notebooks.
A. Answer: D
Question: 22
What is the effect of changing the Default measure property of a Crosstab in a report if a measure is
already set by one of the existing edges?
A. the Crosstab values remain the same and the Crosstab comer displays the Default measure's name
B. the Default measure replaces the existing measure in the Crosstab edges
C. the Default measure is displayed in the Crosstab intersections
D. an error is produced
Answer: A
Question: 23
A developer is given the task of creating an information panel to be displayed in the foyer of the
office. Which Cognos Analytics capability gives the best impact with minimal work?
A. Story played in Kiosk mode with a loop
B. Bespoke report using JavaScript
C. Cognos Viewer Report
D. Dashboard based on Exploration content
Answer: C
Question: 24
A dashboard developer notices that Age is available in the sourced data module. A request has been
made to 'bucket' those age values into 5 groups, Ages 0-6, 7-12, 13-21, 22-55, and 55 and over. How
would one define this logic in the source data module?
A. set range values in the data module
B. use the Create new table feature
C. select the Age column, and select Create data group
D. define a Case..When calculated attribute in the dashboard
Answer: A
Question: 25
After adding a prompt to a relational sourced report it is decided that the consumers require multiselect
functionality instead of a single-select. What two modifications must be made to the report?
A. Change the Filter property Multi-select to Yes
B. Change the Cascade source property of the Prompt to represent more than one value.
C. Change the Prompt property Usage to Select-many.
D. Change the Filter expression of the Query from "=" to use "in".
E. Change the Prompt property Multi-select to Yes.
Answer: CD
Question: 26
Which dashboard formatting option would be used to take several images and text objects and
combine them into one object to enable ease of movement and/or alignment?
A. Group objects
B. Layer objects
C. Combine objects
D. Pack objects
Answer: A
Question: 27
How might a report output type of PDF be secured?
A. by setting a password in the schedule PDF options
B. by giving the PDF a name that starts with "confidential'
C. by selecting the "Secure this Report" option in the report properties
D. by specifying a PDF encryption code in the schedule settings
Answer: C
Question: 28
How does Dynamic Query Analyzer assist in troubleshooting?
A. troubleshooting Data Modules
B. analyzing Dynamic Reports
C. analyzing packages that have Dynamic Queries
D. providing graphical representations for the query logs produced by DQM queries
Answer: A
Question: 29
Which of the following is an example of when the query cache would avoid roundtrips to the
database?
A. repetitive master-detail requests
B. drill through reports
C. reports with multiple queries
D. drill down reports
Answer: A
Question: 30
What is a Compare card in a Cognos Analytics Exploration?
A. A static view/card used to compare and view data across visualizations with different filters.
B. A view/card that uses a specialized algorithm (XGCompare) to analyse data and generatea driver
C. A view/card used to allow the interactive comparison of data across two visualizations with
different filters.
D. A view/card used to compare data from one database with a different set of data from another
database.
Answer: B
Question: 31
What property needs to be set to ensure that any JavaScript and Prompt APIs are executed when a
report is run as HTML?
A. Ensure Enable bidirectional support is checked
B. Run with full interactivity is set to No
C. Enable drill up and drill down in the report output
D. Guided report layout is checked
Answer: D
Question: 32
What is the difference between a Cognos Analytics Story and Dashboard?
A. Stories use report objects to present information in an exported format whilst a dashboard is
interactive.
B. A dashboard is a Cognos Analytics story.
C. Dashboards are live and interactive whereas a Story is the notes attached to the dashboard that
help explain the content of a widget.
D. A story adds to a dashboard's capability by augmenting it with animation and scene changes.
Answer: A
Question: 33
In which two places is Al used in a dashboard line chart visualization?
A. The legend
B. Forecast
C. Data point shape
D. Axis tick marks
E. Meaningful differences
Answer: DE
Question: 34
When should a dimensional function be used in a report's Query calculation?
A. when the data source is a dimensional or dimensionally-modeled data source
B. to allow relative date functions to be performed against a non-dimensional data source
C. to convert a non-dimensional data source into a dimensionally-modeled data source
D. to allow drill up and down on a non-dimensional data source
Answer: B
Question: 35
What technique could be used to investigate report performance?
A. Increase the size limit for the user session.
B. Review the system metrics.
C. Enable the interactive performance assistant
D. Enable legacy user interface.
Answer: C
Question: 36
How can a data module developer ensure that when a user drags an attribute onto a dashboard that
the Map visualization is the default?
A. Change the Represents property for the attribute to Geographic location.
B. Set the visualization property to Map.
C. Use the create map wizard.
D. Select an empty Map visualization then drag this onto the data.
Answer: A
Question: 37
Which of the following is a reason to use a Conditional block on a report?
A. to allow users to select values that will filter the report for certain data types
B. to allow a report to run during certain blocks of time based on conditions set by the user
C. to show or hide report objects based on prompt selections a user made at run time
D. to block defined groups of users from accessing a folder of reports based on a condition
Answer: D
Question: 38
Which statement is true when adding a data source in a dashboard?
A. Framework Manager Packages, Data Modules and Data sets are the only three types of data
sources that can be used when creating a dashboard.
B. Only data sources that have been added to a Data Module can be used as a data source.
C. Framework Manager Packages, OLAP Packages, Data Modules, Data sets and CSV files can all be
used when creating a dashboard.
D. Once a data source has been added it can only be removed by deleting all data sources within the
dashboard.
Answer: B
Question: 39
Which two statements are true when creating navigation paths?
A. A data module can have multiple navigation paths.
B. A modeler must delete the navigation path and re-create it to change the path.
C. Columns from different tables cannot be added to a navigation path.
D. A navigation path is a collection of Group Data columns.
E. A navigation path is a collection of non-measure columns.
Answer: BE
Question: 40
A user complains that the table they're using within a data module has too much historical data in it.
The user would like to keep the old data available, but when using the table for any new reports
would like to see only newer entries based on an 'Order Date' column. What does the developer
need to do to accomplish this?
A. Create a navigation path for the newer entries.
B. Apply a filter to the "Order Date' attribute.
C. Create a calculated 'Order Date'.
D. Create a copy of the table, and apply a filter to the 'Order Date' attribute.
Answer: A
Question: 41
When using an OLAP data source, summaries that use 'For' clauses give incorrect results. Which best
describes the reason for this?
A. Time state rollups against OLAP data sources are not supported
B. OLAP data sources do not have detail rows
C. The 'For' clause does not generate incorrect summaries.
D. Incorporating context filters using MDX functions is not supported.
Answer: C
Question: 42
Which statement is true regarding Custom Sorts in dashboards?
A. A user can create a custom sort on any type of data.
B. Custom sorts cannot be created on measures.
C. Custom sorts may only be created in a Data Module.
D. Custom sorts may be created by selecting a field in the source pane and going to properties.
Answer: B
Question: 43
What is a Layout component reference intended to do in a report?
A. Allow pinned objects to be displayed in a report.
B. Allow reuse of Active Report components with other Active Reports.
C. Allow consumers to use report objects in Dashboards and Explorations.
D. Allow for the reuse of report objects between and within reports for consistency and efficiency.
Answer: A
Question: 44
A developer has nested two non-measures in a Column visualization in a dashboard. How would the
developer manually order the columns to get the column order to show properly?
A. Use automatic sorting.
B. Uncheck sort automatically, and drag the columns to the correct order.
D. Use custom sorting.
Answer: D
Question: 45
DRAG DROP
Select all that apply
Place in order the steps that need to performed in order to set up a Multilingual Dashboard.
Answer:
Place dashboard in edit mode
Set default language
Add language
Enter translated string
Question: 46
What is a Jupyter Notebook?
A. An interface in Cognos Analytics that uses Cognos syntax to produce statistical and predictive
model
B. An open-source web application that allow you to create and share documents that contain live
code, equations, visualizations and narrative text
C. An area where the developer can comment on Cognos Analytics assets to help the end user and
embedded AI understand what is available
D. The core component used by Cognos Analytics for its AI in Intent based model, Nature Language
processing and Explorations
Answer: B
Question: 47
What time saving feature is available for a developer when developing a new data module using AI
intent based modeling?
A. Specify column dependencies
B. Add new sources
C. Add more tables.
D. Discover related tables.
Answer: C
Question: 48
Which statement is true when formatting text in a dashboard crosstab or table?
A. Table summary row may be formatted with a different color.
B. Column formatting gets inherited for the table/crosstab summary row.
C. Column titles may be individually formatted in any font/color/size.
D. The default object does not wrap text, but it is an option.
Answer: D
Question: 49
Which two types of saved report outputs can be used when the Drill-through target type is set to
Bookmark?
A. Excel Data
B. HTML
C. XML
D. CSV
E. PDF
Answer: BE
Question: 50
Which two items can the opposite edge Crosstab in a report?
A. The value of a member
B. A selected measure
C. Member caption
D. Node member
E. Crosstab intersection
Answer: CE
Question: 51
In a report, which of the following is true when enabling the local cache property on a query?
A. Local cache is only supported on batch re|
B. Data is cached and may improve performance.
C. A complete result set is cached for all queries in the model.
D. The scalability of a report is negatively impacted.
Answer: A
Question: 52
When developing a report, which two should be defined for a JOIN query?
A. a reference to two queries
B. only cached results
C. an expression editor
D. an intersection of two queries
E. arelationship defining cardinality
Answer: AD
Question: 53
Which technique is most likely to improve query performance?
A. Set the auto-sort property to maximum.
B. Set the detail aggregation to 'Calculated' for measures.
C. Avoid functions in filters.
D. Add more joins between queries.
Answer: B
Question: 54
A developer may improve the look and feel of a dashboard or story by adding images and shapes
from the Widgets panel. Which statement is true when adding widgets to a dashboard?
A. The widgets panel may contain an Image library tab that the administrator made available
B. Images may only be made available by URL reference.
C. Images can be uploaded to the Image through the upload option on the widgets panel.
D. Text widgets may only be positioned vertically or horizontally.
Answer: D
Question: 55
Which of the following is done for a report to use a Data set as a data source?
A. Ask the administrator to add the file as an external data source.
B. Add the Data set to a Data Module.
C. Add the Data set to a Framework Manager package.
D. Add the Data set as a source on the report.
Answer: A
Question: 56
What is a Cognos Analytics data set?
A. The data that is returned from the datasource and displayed within a report, dashboard or
exploration.
B. The Cognos Analytics name for a Python DataFrame in a Jupyter Notebook.
C. An extract from a package or data module compressed, locally stored and refreshed periodically or
manually.
D. A realtime set of data held in a streaming cache on the Cognos Analytics server.
Answer: C
Question: 57
To optimize the user experience for dashboards and explorations. Framework Manager packages
must be enriched. Which statement is true about enriching Framework Manager packages?
A. A developer can't enrich a package that includes dimensionally modeled (DMR) relational objects.
B. Framework Manager packages are automatically enriched when published to Cognos Analytics.
C. To access the enrich package functionality, you need read/execute/traverse permissions for the
package.
D. In order to have enough data to support the Al-functions in your dashboards and explorations, the
entire Framework Manager package must be enriched.
Answer: D
Question: 58
A developer has a source system provided by another company. One of the columns in a table has
spaces before each piece of data and is in uppercase which makes the reports unreadable. How can
this be solved in a data module?
A. there is no built in capability for this in a data module and the developer needs to create a
calculation for this
B. there is no built in capability for this in a data module and the report needs Trim and Lower
calculations added to it
C. using the 'Clean' menu item on the data item
D. using the 'Prepare' menu item on the data item
Answer: A
Question: 59
When selecting the Layout positioning property for a dashboard, which is the correct option for
dashboards that will be presented on different mobile devices?
A. Unbounded
B. Relative
C. Conditional
D. Absolute
Answer: C
Question: 60
A fast and user friendly way to create an initial dashboard is to use the text-based Assistant. When
using the Assistant, which option below will develop a dashboard?
A. In the Assistant, enter 'show data', select a datasource from the list, and enter 'create dashboard'
or 'build dashboard1.
B. In a new dashboard, select a datasource, and enter 'create visualization'.
C. In a new dashboard, select a template and a datasource.
D. In a new dashboard, search for data, select a template and enter 'create'.
Answer: D
What report authoring technique can be used to ensure consistent look and feel cross reports and reduce duplicate authoring rework?
what outputs from a jupyter notebook can be shared with an end user in the cognos analytics interface?
 
a - nothing is shared
b - the data and output cells such as visualizations
c - connections generated in the notebook
d - kernel properties and version information
 
What report authoring technique can be used to ensure consistent look and feel cross reports and reduce duplicate authoring rework?
 
a - saving multiple versions of the same report
b - style component reference
c - layout component reference
d - pinning contente
 
 
which feature is designed for authors to interactively view the performance of their reports?
 
a - interactive performance assistant
b - IPF Logging
c - Interactive Data property on Validate Options
d - XQE Logging
 
 
what technique can be used to identify if local processing is impacting query performance?
 
a - View the tabular data
b - adjust the processing property to database only and run the report
c - use the compatible query analyzer
d - review the report specification
 
 
Cognos Analytics out of the box offers a multi-value visualization that presents a nuber with it1s target, along with a trend indicator, variance and a trend line, this visualization is called?
 
a - Scoreboard
b - KPI
c - Driver analysis
d - Decision tree
 
 
Which of the following is true regarding report output format types, such as HTML and PDF?
 
A - MULTIPLE OUTPUT FORMAT TYPES MAY BE SELECTED WHEN CONFIGURING A REPORT TO RUN IN THE BACKGROUND
 
b - only the report's default output format type may be selected when configuring a report to run in the background
 
c - only a single output format type may be selected when configuring a report to run in the background if the type chosen is XML
 
d - Only a single output format type may be selected when configuring a report to run in the background.
 
 
In a summary filter within a report, what does specifying the scope define?
 
a - the detail at which the filter is applied
b - the solve order at which the filter is applied
c - the grouping level at which the filter is applied
d - the aggregates that get applied to the filter
 
 
There are several ways to filter data in a Cognos dashboard. Which statement is correct?
 
a - add a filter to be applied to all tabs or individual tabs in an infographic style dashboard
b - a locally defined filter on a single visualization can be modified by a global filter on the filter dock
c - use the data tray to filter the data in several columns. the columns are not required to be in the visualization
d - add a column to the canvas (context filter) and use it to filter data on other tabs
 
What are two valid reasons why a developer would relink their dashboard to another data source?
 
1 - attibute data types have changed and need to be updated in the dashboard.
2 - the developer needs to be able to start with a spreadsheet, and eventually move the dashboard to read a production database
3 - data values have changed in the database
4 - the developer needs to modify a data module from one data server to another data server, or from one schema to another schema
5 - the developer may not have production data available. test data can be used to create the initial dashboard. when the production source is ready, the developer can relink the source to the intended production source
 
what is the definition of a context filter in a dashboard?
 
a - A column on the canvas used as a widget filter
b - a context filter and slicer filter are used in the same context within dashboards.
c - context filters are not automatically linked to visualizations
d - a text field in the dashboard used as a filter
 
 
In a report, under which two circumstances can a defined table of contents be viewed?
 
1 - when run as full interactive HTML
2 - when run as PDF
3 - when run as non-interactive HTML
4 - when run as Excel Data
5 - when run as CSV
 
 
How is a time series forecast added to a dashboard line chart in Cognos Analytics?
 
a - Data must be exported to a third party tool and then re imported with the forecast data
b - Cognos Analytics requires Planning Analytics for forecasting
c - MDX empressions are used to extrapolate data in a data module and generate a forecast
d - select the forecast icon that appears on the visualization
 
 
Which is true when customizing tab styles on a tabbed dashboard in CognosAnalytics?
 
a - it is not possible to set the tab fill color
b - tabs may be nested and color coded
c - global tab styles will take precedence over individual tab definitions
d - a tab may contain an icon, and a user can select the color of that icon
 
What is the porpose of a bursted report in Cognos Analytics?
 
a - to run a report once but distribute the results to multiple burst recipients
b - to create page breaks within  a single report based on specified data and user criteria
c - to distribute a single report with the same data to a distribution list
d - to consolidata multiple reports into one report output
 
When defining a query calculation in a report, what happens when the validate button is pressed in Cognos Analytics?
 
a - a dialog box appears and warns you that the evaluation may take a long time and lets you cancel the activity
b - if there is a mistake unrelated to the query calculation anywhere in the report, the validation will fail
c - only the expression typed into the query calculation will be evaluated and nothing else
d - a dialog box appears and asks if you would like to evaluate the entire report or just the query calculation
 
A localized dashboard opens for users based on the languages in the languages list and the content language set in the user's preferences . What step would be taken to localize a cognos dashboard in Cognos Analytics?
 
a - change the default locale under the users preferences
b - set at least one default language in the dashboard properties. Then under Languages, select the menu icon for the  language you want to localize to, and select edit translations
c - upload a translated CSV file as a reference for you to manually localize a dashboard
d - no extra steps are required; cognos translates dashboards into all supported languages
 
 
when multiple visualizations on the canvas share a category or value, what would a developer change to automatically adjust the visualization collrs to mach in Cognos Analytics?
 
a - the visual theme property
b - order the colors within a palette
c - the color consistency property
d - create a custom palette
 
 
Which 2 actions can be taken to identify the root cause of report performance problems in Cognos Analytics??
 
a - review the database design
b - review the query execution plan with the database administrator
c - delete the old log files
d - update the audit database
e - increasing the maximum number of processes
 
 
 
What is intent-based modeling in Cognos Analytics?
 
a - the developer used clicks in the modeling interface to perform their chosen intent. an example is the selection of properties
b - the intent of the model is the description so that an end user can fully comprehend the purpose of the model and how to use it to effectively answer business questions
c - the model has been written with domain specific intent, such as modeling specific to manufacturing, by a developer
d - intent-based modeling features allow a user to provide an analysis intent phrase in natural language and propose a model to satisfy the user intent promptly
 
 
How does a developer creat a Cognos Analytics Data set?
 
a - the developer selects 'save as data set' from the reporting interface
b - the developer selects 'create data set' from the package or data module context menu (three dots)
c - the developer selects the 'new' menu and the 'create data set'
d - the developer or user selects 'save as data set' from a table in a report or dashboard
 
 
when a user experiences report performance issues, what technique can be used to evaluate query performance issues not caused by the Cognos application itself?
 
a - review the server logs
b - execute the native sql outside of cognos
c - convert the queries to stored procedures
d - convert the tables to views
 
 
to model the metadata for a relational database structure in a data module where role based security is required, which technique should be used?
 
a - creat a new table view to contain the appropriate filter
b - use CSVIdentifyList() in a filter expression to expose security groups
c - role based security is not supported in data modules
d - under data module sources, set data security, and add security definition
 
 
As a Cognos developer, the requirement is to create a report joining two tables in two different databases. As the join is enabled, performance has become a major concern, as data is not returning fast enough for the users. Which 2 options could offer performance gains in this scenario?
 
a - Create a synonym for the second table, within the first database. Reference both the synonym and the table for the join logic
b - set the cache for the first table in the data module, and then join results to the second table
c - creat a view of the two tables within the data module
e - create a joinede table within the data module referencing both tables, and set the join optimization to unique or range of values
 
what does the driver analysis visualization illustrate?
 
a - the predictive strength of one, two or a combination of data items on a single data item
b - the baseic statistical information that drives a measure value ie. mean, max, min, medium etc.
c - a diagram in the development process for data modules to understand which data items should be included in an end user metadata model
d - the results of various measure aggregate values within a data set to understand if thesholds for KPI targets are met in order to drive the business requirements
 
 
a developer creates a new data module on a data server . there are no tables or objects visible in the source but the database contains tables for the connected signon. what does the developer need to do ?
 
a - the developer must ask the dba to create a schema called "cognos" for the tables they need to create the data module against
b - the developer has forgotten to log out and then back in to refresh their browser's view and see the objects
c - the developer needs to "relink" the data source again to get an up to date view of the database4
d - under the schema on the data server connection the developer must execute "load metadata"
 
Cognos analytics can integrate out of the box to which third party collaboration platform?
a - slack
b - webex
c- domino
d – Dropbox