1Z0-1087-20 Online Practice Questions and Answers

Which two Bank File formats does Account Reconciliation support using pre-built adapters in Data Management? (Choose two.)

A. SWIFT MT940

B. BAI

C. EDI

D. XML

Which expression do you include in the Expression field of the Amount column in an import format to ensure that zero balances are loaded?

A. Source system

B. NZP

C. 0

D. Include Null

You want to load balances for both the Entered currency bucket and the Functional currency bucket in a single data load.

Which tool should you use?

A. `Import pre-mapped balances' option in the Periods page

B. Data Management data load rule

C. Smart View

D. Supplemental Data Management form

In a reconciliation profile, the Account Payable Reviewers team is assigned as the reviewer, and you want to require that ALL team members approve the reconciliation.

Which action should you perform?

A. In the Instructions tab of the profile, add instructions for all team members to review the reconciliation.

B. On the Workflow tab of the Profile, select All Reviewers in the Require Action By field.

C. Add a rule of the type Require Team Review to the Rules tab.

D. Do not select a Primary User for the Account Payable Reviewers team.

Which two conditions can make a profile invalid? (Choose two.)

A. The Normal Balance setting does not match the account type.

B. No preparer is assigned on the Workflow tab.

C. No currency buckets are enabled.

D. Aging limits have not been specified.

In the Balance Explanations tab of the Prepaid Expenses reconciliation, you want to include the transactions and attachments from the prior period in the current period.

Which action should you perform?

A. In the Balance Explanations tab of the current period reconciliation, select `Copy Transactions from Prior Reconciliation'.

B. In the profile for Prepaid Expenses reconciliations, select `Include Prior Period Transactions'.

C. In the Reconciliations list, copy the reconciliation from the prior period and paste it into the current period.

D. Export the transactions from the prior period reconciliation and then import them to the current period reconciliation.

Which statement about journals in transaction matching is FALSE?

A. You create separate journal column mappings for adjustments and transactions.

B. For transactions, you can apply a data source filter to the export.

C. You create separate journal columns for each match type.

D. For adjustments, the variance amount is exported to the Amount column.

You are creating a matching rule, and you want transactions that are within the specified tolerance range to be matched automatically, with no need for further user review.

Which option should you choose for the Match Status?

A. Suggested

B. Auto Approve

C. Auto Submit

D. Confirmed

Which is NOT a step in configuring journals in Transaction Matching?

A. create journal columns

B. map journal columns to data source attribute columns

C. define data source filters

D. create journal templates

Which two attribute types are required for each data source? (Choose two.)

A. Key Field

B. Accounting Date

C. Calculation

D. Balancing Attribute