Using a DB2 for z/OS source database, a 200 million row source table with 30 million distinct values must be aggregated to calculate the average value of two column attributes. What would provide optimal performance while satisfying the business requirements?
A. Using custom SQL with an ORDER BY clause based on key columns, select all source rows using the DB2 API stage. Aggregate using a Hash Aggregator.
B. Using custom SQL with AVG functions and a DISTINCT clause, select all source rows using a DB2 Enterprise stage.
C. Select all source rows using a DB2 Enterprise stage, use a parallel Sort stage with the specified sort keys, calculate the average values using a parallel Transformer with stage variables and output link constraints.
D. Select all source rows using a DB2 API stage. Aggregate using a Sort Aggregator.
正解:D
質問 2:
In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the stages.
You have been asked to reduce the number of sorts to improve the performance of the job.
Which two ways might be used to accomplish this without changing how the job functions? (Select two)
A. In the second Sort stage change the Sort Mode property of the state column to "Don't sort, previously sorted.".
B. In the second Sort stage change the Sort Mode property of the area column to "Don't sort, previously sorted.".
C. Remove the second Sort stage. Add area as an additional sort key.
D. Remove the first Sort stage. Retain the existing sort keys in the second Sort stage.
正解:B,D
質問 3:
The Change Apply stage produces a change Data Set with a new column representing the code for the type of change. What are three change values identified by these code values? (Choose three.)
A. Final
B. Copy
C. Deleted
D. Edit
E. Remove Duplicates
正解:B,C,D
質問 4:
What is the lowest CPU cost partitioning method?
A. Random
B. Hash
C. Round Robin
D. Entire
正解:C
質問 5:
What are three valid join operations for the Join stage? (Choose three.)
A. Bottom inner join
B. Left outer join
C. Right outer join
D. Top outer join
E. Inner Join
正解:B,C,E
質問 6:
You are required to use a Make Vector stage in your job. What three requirements must be met in order to use this stage? (Choose three.)
A. Input columns must form a numeric sequence.
B. All columns are combined into a vector of the same length as the number of columns.
C. Input columns must all be of the same data type.
D. Columns must be in consecutive order.
E. Input columns that do not have a name of form <column_name>0 to <column_name>n, where <column_name> is the column name and 0 and n are the first and last of its consecutive numbers will not be included in the vector and will be dropped.
正解:A,B,C
質問 7:
Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1.
Before you create the package you will have to ensure the project is up to date with version 1.
What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Select two)
A. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.
B. Right-click the asset and click Replace From Source Control Workspace.
C. Right-click the asset and click the Team Import command.
D. Right-click the asset and click the Deploy command.
正解:A,C
五十** -
簡単にC2090-421試験に合格することは信じられないです。ずっとC2090-421試験は難しいと思っています。しかし、C2090-421試験資料があったら、優しくなりました。