C1000-065 Features of Certification Exam Dumps 2020

1. IBM C1000-065 IBM Cognos Analytics Developer V11.1.x Questions & Answers PDF For More Information: https://www.certswarrior.com/ Features: 90 Days Free Updates 30 Days Money Back Guarantee Instant Download Once Purchased 24/7 Online Chat Support Its Latest Version Visit us athttps://www.certswarrior.com/exam/c1000-065/

2. Total Questions: 60 Latest Version: 6.0 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

3. 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 https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.doc/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: 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 data. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

4. 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: 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 https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_exploratio ns.doc/ca_explore_relationship_diagram.html Visit us athttps://www.certswarrior.com/exam/c1000-065/

5. 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: 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

6. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

7. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

8. 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. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

9. 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 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: 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

10. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

11. 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 generate a 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

12. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

13. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

14. 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. Visit us athttps://www.certswarrior.com/exam/c1000-065/

15. 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. C. Select Sort remaining items by Auto. D. Use custom sorting. Answer: D Question: 45 Select all that apply Place in order the steps that need to performed in order to set up a Multilingual Dashboard. Answer: <map><m x1="68" x2="506" y1="43" y2="81" ss="0" a="0" /><m x1="68" x2="495" y1="86" y2="123" ss="0" a="0" /><m x1="69" x2="506" y1="126" y2="163" ss="0" a="0" /><m Visit us athttps://www.certswarrior.com/exam/c1000-065/

16. x1="70" x2="505" y1="169" y2="205" ss="0" a="0" /><m x1="528" x2="1024" y1="43" y2="85" ss="1" a="0" /><m x1="531" x2="1021" y1="96" y2="138" ss="1" a="0" /><m x1="531" x2="1019" y1="147" y2="186" ss="1" a="0" /><m x1="536" x2="1017" y1="195" y2="240" ss="1" a="0" /><c start="0" stop="0" /><c start="2" stop="1" /><c start="1" stop="2" /><c start="3" stop="3" /></map> 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

17. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

18. 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. a relationship 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. Visit us athttps://www.certswarrior.com/exam/c1000-065/

19. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

20. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

21. 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 Visit us athttps://www.certswarrior.com/exam/c1000-065/

22. http://www.certswarrior.com/ Questions and Answers (PDF) For More Information – Visit link below: http://www.certswarrior.com Disc ount Coupon Code: CERT SWARRIOR10 Page | 1 http://www.certswarrior.com/exam/M2180-651/ Visit us athttps://www.certswarrior.com/exam/c1000-065/ Powered by TCPDF (www.tcpdf.org)