Online Access Free C2020-625 Exam Questions

A developer wants to copy data from one table to a table in another database. What type of fact build would be the most appropriate for the developer to specify in the Fact Build wizard?

• A.Cognos BI Mart (Star)
• B.Cognos BI Mart (Snowflake)
• C.Relational datamart
• D.Data transfer

A fact build is being manually created. What must the developer do to deliver the fact data to a relational table?

• A.Add a relational table delivery module to the fact build.
• B.Create a relational table delivery using SQLTerm.
• C.Modify the fact build DataStream to include a relational table delivery.
• D.Add a relational table delivery module to the Connections folder.

A lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). If the incoming currency is not available through the lookup, what can be done to prevent the fact row from being rejected?

• A.Create a derivation to insert a default value.
• B.Create a derived dimension to create a default value.
• C.Accept unmatched member identifiers.
• D.Set the "value if null" property on the table delivery.

Which of the following is are characteristics of surrogate keys? (choose three)

• A.Tend to be larger than keys from operational systems.
• B.Are unique.
• C.Are numbers.
• D.Are text-based.
• E.Have no intrinsic meaning.
• F.Are replaced by business keys in the data warehouse.

A developer has created a fact build to process the incoming data shown in the table: The build has been set to merge records with duplicate keys. Both the Customer and Date columns represent dimension elements. If the merge behavior for the Amount column is set to SUM, what will be the value of Amount for the first row delivered for customer 2?

• A.1200
• B.500
• C.200
• D.700