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 20 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 10 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
正解:C
質問 2:
Which three options are available for selecting when an audit rule fails? (Choose three)
A. Script
B. Email to List
C. Write Data to Error Table
D. Raise Exception
正解:A,B,D
質問 3:
Which two functions can you use in a Query? (Choose two)
A. Sleep
B. Count
C. Lookup_Ext
D. Exec
正解:B,C
質問 4:
Which three operations are available between a Local and Central Object Library?
(Choose three)
A. Import
B. Export
C. Get
D. Add
E. Check In
正解:C,D,E
質問 5:
Which two components are required to execute a batch job? (Choose two)
A. Central Management Console
B. Batch Server
C. Job Server
D. Designer
E. Repository
正解:C,E
質問 6:
Which lookup caching method reduces system memory usage?
A. Pre_Load_Cache
B. Smart_Cache
C. No_Cache
D. Demand_Load_Cache
正解:C
質問 7:
Under which two circumstances must you select "Use Input Keys" when updating a Target Table? (Choose two)
A. To specify an alternative key for the update
B. To optimize the pushdown SQL
C. No primary key is specified on the source table
D. No primary key is specified on the target table
正解:A,D
質問 8:
What transform must you use to join two source tables?
A. Map_Operation
B. Case
C. Query
D. Table_Comparison
正解:C
星名** -
この問題集の網羅性が高く分かりやすくなっているので、
是非、高得点での合格を目指してもらいたいです。
SAPさん最高です。