IBM Certified Developer C1000-065 Real Exam Questions and Answers FREE Updated on Sep 29, 2021
C1000-065 Ultimate Study Guide - Test4Cram
NEW QUESTION 22
Which of the following can result in poor report performance?
- A. reports with filters
- B. models with outer joins and cross joins
- C. an optimized metadata model
- D. queries with database only processing
Answer: B
NEW QUESTION 23
Which two items can the opposite edge Crosstab in a report?
- A. Crosstab intersection
- B. Member caption
- C. The value of a member
- D. Node member
- E. A selected measure
Answer: A,B
NEW QUESTION 24
In a report, which of the following is true when enabling the local cache property on a query?
- A. Data is cached and may improve performance.
- B. A complete result set is cached for all queries in the model.
- C. The scalability of a report is negatively impacted.
- D. Local cache is only supported on batch re|
Answer: D
NEW QUESTION 25
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. An extract from a package or data module compressed, locally stored and refreshed periodically or manually.
- C. A realtime set of data held in a streaming cache on the Cognos Analytics server.
- D. The Cognos Analytics name for a Python DataFrame in a Jupyter Notebook.
Answer: B
NEW QUESTION 26
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. Framework Manager
- B. Administration console
- C. Microsoft Studio
- D. PowerPlay Studio
- E. Transformer
- F. PowerPlay Client
Answer: A,B,E
Explanation:
Explanation
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_powercub
NEW QUESTION 27
How might a report output type of PDF be secured?
- A. by setting a password in the schedule PDF options
- B. by selecting the "Secure this Report" option in the report properties
- C. by giving the PDF a name that starts with "confidential'
- D. by specifying a PDF encryption code in the schedule settings
Answer: B
NEW QUESTION 28
What is a Jupyter Notebook?
- A. The core component used by Cognos Analytics for its AI in Intent based model, Nature Language processing and Explorations
- 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 interface in Cognos Analytics that uses Cognos syntax to produce statistical and predictive model
- D. An area where the developer can comment on Cognos Analytics assets to help the end user and embedded AI understand what is available
Answer: B
NEW QUESTION 29
Which statement is true regarding Custom Sorts in dashboards?
- A. Custom sorts may be created by selecting a field in the source pane and going to properties.
- B. Custom sorts cannot be created on measures.
- C. Custom sorts may only be created in a Data Module.
- D. A user can create a custom sort on any type of data.
Answer: B
NEW QUESTION 30
What is the difference between a Cognos Analytics Story and Dashboard?
- A. Dashboards are live and interactive whereas a Story is the notes attached to the dashboard that help explain the content of a widget.
- B. Stories use report objects to present information in an exported format whilst a dashboard is interactive.
- C. A story adds to a dashboard's capability by augmenting it with animation and scene changes.
- D. A dashboard is a Cognos Analytics story.
Answer: B
NEW QUESTION 31
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. use the Create new table feature
- B. select the Age column, and select Create data group
- C. set range values in the data module
- D. define a Case..When calculated attribute in the dashboard
Answer: C
NEW QUESTION 32
What benefit does the Cognos Analytics integration with Jupyter Notebooks provide a developer?
- A. 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.
- B. Cognos Analytics does not integrate with Jupyter Notebooks.
- C. A Developer can add notes to content to better describe to an end user what data is available and how calculations work.
- D. Weather data can be used from the Jupyter service to enrich information and help identify trends Example: Ice cream sales on sunny days.
Answer: B
NEW QUESTION 33
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. using the 'Prepare' menu item on the data item
- 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. there is no built in capability for this in a data module and the developer needs to create a calculation for this
Answer: D
NEW QUESTION 34
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
NEW QUESTION 35
When should a dimensional function be used in a report's Query calculation?
- A. to convert a non-dimensional data source into a dimensionally-modeled data source
- B. when the data source is a dimensional or dimensionally-modeled data source
- C. to allow drill up and down on a non-dimensional data source
- D. to allow relative date functions to be performed against a non-dimensional data source
Answer: D
NEW QUESTION 36
A Framework Manager model may be designed to incorporate Dimensionally Modeled Relational (DMR) objects, designed to offer the end user OLAP behavior when navigating data. Which of the following statements is valid when designing DMR structures in Framework Manager?
- A. The order of the Determinants drives the hierarchy levels.
- B. The DMR structures need to resemble the objects in the star schema.
- C. Measures and Dimensions can reside in the same query subject.
- D. Each level in a hierarchy must reference a text-based attribute for its caption.
Answer: C
NEW QUESTION 37
Which two types of saved report outputs can be used when the Drill-through target type is set to Bookmark?
- A. HTML
- B. XML
- C. PDF
- D. CSV
- E. Excel Data
Answer: A,C
NEW QUESTION 38
When developing a report, which two should be defined for a JOIN query?
- A. only cached results
- B. an intersection of two queries
- C. a relationship defining cardinality
- D. a reference to two queries
- E. an expression editor
Answer: B,D
NEW QUESTION 39
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
NEW QUESTION 40
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 the Cognos installer when upgrading the server components.
- B. Under the Data Server Connection in the Administration Console configuration select "Allow Framework Manager".
- C. Select "Allow web-based modeling" in Cognos Configuration when starting the server
- D. Under the Data Source Connection in the Administration Console configuration select "Allow web-based modeling".
Answer: A
NEW QUESTION 41
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, search for data, select a template and enter 'create'.
- C. In a new dashboard, select a datasource, and enter 'create visualization'.
- D. In a new dashboard, select a template and a datasource.
Answer: B
NEW QUESTION 42
Which two of the following statements are true when creating a Drill-through for a visualization in a dashboard?
- A. A developer can create a Drill-through to a Webpage.
- B. One can pass selected data points to the target Drill-through as long as its data source uses the same values.
- C. Each visualization can only have a single Drill-through.
- D. A developer can create Drill-throughs to other dashboards and reports.
- E. A developer can create Drill-throughs to a specific story that is created.
Answer: B,D
NEW QUESTION 43
......
Ultimate Guide to Prepare C1000-065 Certification Exam for IBM Certified Developer: https://www.test4cram.com/C1000-065_real-exam-dumps.html