872 お客様のコメント
質問 1：
You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What option will enable jobs with a parallel transformer to execute in the customers production machines?
A. Add $APT_COMPILE_OPT=-portable
B. Use protected projects in the production environment.
C. Create a package with Information Server Manager and select the option to include executables.
D. Set $APT_COPY_TRANSFORM_OPERATOR
正解：C
質問 2：
Which statement is true about improving job performance when using Balanced Optimization?
A. Convert a job to use bulk staging tables for Big Data File stages.
B. Balance optimization attempts to balance the work between the source server, target sever, and the job.
C. If the job contains an Aggregator stage, data reduction stages will be pushed into a target data server by default.
D. To ensure that a particular stage can only be pushed into a source or target connector, you can set the Stage Affinity property to source or target.
正解：D
質問 3：
The ODBC stage can handle which two SQL Server data types? (Choose two.)
A. Datetime
B. Date
C. Time
D. SmallDateTime
E. GUID
正解：D,E
質問 4：
How must the input data set be organized for input into the Join stage? (Choose two.)
A. Key partitioned
B. Sorted by Join key
C. Hash partitioned
D. Entire partitioned
E. Unsorted
正解：A,B
質問 5：
What two binding types are supported by Information Services Director (ISD) for a parallel job that is designed to be used as a service? (Choose two.)
A. SQL
B. SOAP
C. STREAMS
D. EJB
E. HDFS
正解：B,D
質問 6：
What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)
A. SFTP
B. TFTP
C. RFTP
D. FTP
E. EFTP
正解：A,D
質問 7：
You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.
Which change will reduce the cost of partitioning that occurs in this job?
A. Use Entire partitioning on the input links to the Aggregator and Join stages.
B. Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on the Aggregator and Join stages.
C. Hash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.
D. Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.
正解：D
質問 8：
Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?
A. Overwrites an attribute in a dimension table.
B. Adds a new row to the fact table.
C. Adds a new row to a dimension table.
D. Overwrites an attribute in the fact table.
正解：A
質問 9：
The Score is divided into which two sections? (Choose two.)
A. File sets
B. Operators
C. Stages
D. Schemas
E. Data sets
正解：B,E
You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What option will enable jobs with a parallel transformer to execute in the customers production machines?
A. Add $APT_COMPILE_OPT=-portable
B. Use protected projects in the production environment.
C. Create a package with Information Server Manager and select the option to include executables.
D. Set $APT_COPY_TRANSFORM_OPERATOR
正解：C
質問 2：
Which statement is true about improving job performance when using Balanced Optimization?
A. Convert a job to use bulk staging tables for Big Data File stages.
B. Balance optimization attempts to balance the work between the source server, target sever, and the job.
C. If the job contains an Aggregator stage, data reduction stages will be pushed into a target data server by default.
D. To ensure that a particular stage can only be pushed into a source or target connector, you can set the Stage Affinity property to source or target.
正解：D
質問 3：
The ODBC stage can handle which two SQL Server data types? (Choose two.)
A. Datetime
B. Date
C. Time
D. SmallDateTime
E. GUID
正解：D,E
質問 4：
How must the input data set be organized for input into the Join stage? (Choose two.)
A. Key partitioned
B. Sorted by Join key
C. Hash partitioned
D. Entire partitioned
E. Unsorted
正解：A,B
質問 5：
What two binding types are supported by Information Services Director (ISD) for a parallel job that is designed to be used as a service? (Choose two.)
A. SQL
B. SOAP
C. STREAMS
D. EJB
E. HDFS
正解：B,D
質問 6：
What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)
A. SFTP
B. TFTP
C. RFTP
D. FTP
E. EFTP
正解：A,D
質問 7：
You are asked to optimize the fork join job design in the exhibit. This job uses the sort aggregator and a left outer join on the ZIP code column. Currently all partitioning is set to "Auto" and automatic sort insertion is allowed.
Which change will reduce the cost of partitioning that occurs in this job?
A. Use Entire partitioning on the input links to the Aggregator and Join stages.
B. Hash partition and sort on ZIP code column prior to the Copy stage and use entire partitioning on the Aggregator and Join stages.
C. Hash partition and sort on ZIP code column on the input links to the Aggregator and Join stages.
D. Hash partition and sort on ZIP code column prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.
正解：D
質問 8：
Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?
A. Overwrites an attribute in a dimension table.
B. Adds a new row to the fact table.
C. Adds a new row to a dimension table.
D. Overwrites an attribute in the fact table.
正解：A
質問 9：
The Score is divided into which two sections? (Choose two.)
A. File sets
B. Operators
C. Stages
D. Schemas
E. Data sets
正解：B,E
宝*舞 -
C2090-303試験の概要もちゃんとあり、基礎的な内容から書かれています。C2090-303合格に必要な力を手に入れました。