CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C1000-065

Free C1000-065 Exam Braindumps (page: 6)

Page 5 of 16
PDF with 60 Questions

Which is true about creating a context filter for a crosstab report using a dimensional data source?

  1. it changes the measure values and the items in the rows and columns
  2. it is applied after aggregation and changes the rows and columns
  3. it changes the measure values and suppresses zeros
  4. it filters only the measure values, not the items in the rows and columns

Answer(s): C



What advantage does multidimensional report writing have on query maintenance for complex queries?

  1. There is no need to use calculations as the data source contains all the required data items.
  2. Fewer queries are required and the need for unions of queries is reduced due to the flexibility of MDX.
  3. Unions and Joins are always required for queries making it easier for a developer to understand the query intent.
  4. There is no advantage and multidimensional query constructs should be avoided.

Answer(s): B



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?

  1. All queries are collapsed and a standard join across all three tables (a, b, c) is performed.
  2. 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).
  3. 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.
  4. The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).

Answer(s): D



What is the significance of 'Clothes' in the following filter expression of a report query? [Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#

  1. 'Clothes' is the default text to include in the generated query at runtime.
  2. The string 'Clothes' will precede the text of the prompt value selected at runtime.
  3. The string 'Clothes' will be appended to the end of the text of the prompt value selected at runtime.
  4. 'Clothes' is a required value to include in the generated query at runtime.

Answer(s): C






Post your Comments and Discuss IBM C1000-065 exam with other Community members:

C1000-065 Discussions & Posts