C-BODI-20 試験問題を無料オンラインアクセス

You are unfamiliar with the data in your customer dimension table. You decide to run column profile on the table. Which three insights will you gain from reviewing the column profile results? (Choose three)

• A.Columns that contain only null data
• B.SUM of the numeric column values
• C.Count of distinct values in a column
• D.Distinct values in a column

Data integrator conations "Execute only once" logic on which two objects? (Choose two)

• A.Work flows
• B.Conditionals
• C.Scripts
• D.Data flows

How long is the table data within a persistent cache data store retained?

• A.Until the execution of the batch job.
• B.Until the table is reloaded
• C.Until the real-time service is restarted
• D.Until the job server is restarted.

You create an expression that tests in the "Zip code" field matches a standard format to five numeric digits and the value begins with a 1or 2 which expression must you use to do this?

• A.match_pattern( value.'?[112]9999')
• B.match_pattern( value.'[12]9999')
• C.match_pattern( value.'[112]9999')
• D.match_pattern( value.'?[12]9999')

You are using an oracle 10G database for the source and target tables in your data flow. In which circumstance will data integrator optimize the SQL to use the oracle "merge" command?

• A.The Map_Operation is used to map all items from " normal " to" update now operations
• B.The "Auto Correct load" option is selected on the Target table.
• C.A table comparison is used to compare the source with the target
• D.The "Use input Keys" option is selected on the target table editor