Free IBM C2020-625 Exam Dumps Questions & Answers

A developer has added a data source connection to a Data Manager catalog. This connection points to a relational database. The developer wants to view the contents of this database, such as the number of tables that it contains. What tool could the administrator use?

• A.  ODBC Administrator
• B.  SQLTerm
• C.  Reference Explorer
• D.  SQLTXT Designer

A developer has created a fact build where separate summary tables will be created for monthly and quarterly data. What should be created on these fact deliveries to prevent monthly data from being delivered to the quarterly summary table?

• A.  Derivations
• B.  Level filters
• C.  User-defined functions
• D.  Output filters

A developer is attempting to test a derivation.

In the Input values section, what does the cross symbol beside Price indicate?

• A.  The option in the Top box should be set to Price.
• B.  The option in the Immediate box should be set to Price.
• C.  No value has yet been defined for Price in the Output values section.
• D.  A definition for Price has not been found.

Which element does Data Manager use to identify duplicate rows?

• A.  Attribute
• B.  Dimension
• C.  Measure
• D.  Index

Which would be reasons for modifying a hierarchy that was previously created using the Hierarchy wizard? (Choosetwo)

• A.  To add a measure element to the hierarchy.
• B.  To add an attribute to a hierarchy level.
• C.  To add a derived dimension element to the hierarchy.
• D.  To add a level to the hierarchy.
• E.  To specify a metadata dimension for the hierarchy.
• F.  To specify a fact build for the hierarchy.