C_BODI_20 무료 덤프문제 온라인 액세스

Which three elements can be contained in the output schema of a query? (Choose three)

• A.Nested Schemas
• B.Filters
• C.Order By
• D.Columns
• E.Functions
• F.Group By

You have declared a local variable in a Work Flow. Which three objects in the Work Flow can use the variable? (Choose three)

• A.Work Flow
• B.Data Flow
• C.Conditional
• D.Script
• E.While

Which two methods can you use to specify multiple files in the same source file format? (Choose two)

• A.Specify a file Lookup table
• B.Use a comma separated list of files
• C.Use wildcards(*.?)
• D.Create a file list .txt file

You want to join a "sales", "customer" and "product" table. Each table resides on a different data store and will not pushdown to one SQL command. The "sales" table contains approximately five millions rows. The "customer" table contains approximately five thousand rows. The "product" table contains fifty records.
How would you set the source table options to maximize performance of this operation?

• A.Set the sales table joins rank to 20 and cache to "No". Set the customer table joins rank to 10 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
• B.Set the sales table joins rank to 10 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 30 and cache to "yes".
• C.Set the sales table joins rank to 30 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
• D.Set the sales table joins rank to 20 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".

You are working in a multi-user central repository based environment. You select "Rename owner" on an object which is not checked out. The object has one or more dependent objects in the local repository. What is the outcome?

• A.Data Integrator renames the owner of all 0bjects within the selected data store.
• B.Data Integrator displays the "This object is checked out from central repository "X". Please select Tools Central Repository. to activate that repository before renaming Message.
• C.Data integrator displays a second window listing the dependent objects. when you click "continue" the object owner is renamed and all of the dependent objects are modified.
• D.Data Integrator renames the individual object owner.