P2020-300 試験問題を無料オンラインアクセス

In Presenter, which two types of Transformations can you create? (Choose two.)

• A.Subtotal
• B.Aggregate
• C.Summed
• D.Transpose

Refer to the Exhibit below.

In Presenter, when preparing data sources for the report shown in the exhibit, which type of source must be created to produce the subtotals by payee?

• A.Aggregate Transformation
• B.Computed Row
• C.Data Source
• D.Subtotal Source

Which two alternative Web Client authentication methods does IBM Cognos ICM support? (Choose two.)

• A.SQL
• B.Excel
• C.SSO
• D.LDAP

Refer to the Exhibit below.

Referring to the exhibit, your model has two calculations - "Revenue" and "Commission" - partitioned by PayeeID, ProductGroup, Product, and Month.
What must you create to produce the summary report that shows revenue and commission by ProductGroup and Month?

• A.a Data Store that joins both calculations and select ProductGroup and Month as detail columns
• B.Aggregate Transformations in Presenter partitioned by ProductGroup and Month
• C.additional calculations to sum the results partitioned by ProductGroup and Month
• D.CalculatedRows in Presenter that sum both values by ProductGroup and Month

When joining two data sources in a Data Store, what should you select to ensure that all records of the first data source will return, even if the join does not find matching records in the second data source?

• A.Right outer join
• B.Anchor source rows
• C.Include empty partitions
• D.Full outer join