IBM c1000-065 practice test

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

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

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.

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

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’’

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

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

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.

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).

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.