最新なSASInstitute A00-260問題集（70題）、真実試験の問題を全部にカバー！

質問 1：
When writing postcode in the Precode and Postcode tab of the Transpose transformation in SAS Data Integration Studio, which symbol allows you to reference the transformation output table regardless of the actual physical name for that target table?
A. syslast
B. &target
C. &syslast
D. %target
正解：C

質問 2：
When using SAS Data Integration Studio's SQL Join transformation, which SQL join type can be constructed as either an implicit or an explicit join?
A. Full
B. Inner
C. Cross
D. Union
正解：B

質問 3：
Which statement is FALSE regarding foreign keys?
A. A table can have zero or more foreign keys.
B. A foreign key is one or more columns that are associated with a primary key or unique key in another table.
C. A table can have only one foreign key defined.
D. A foreign key cannot exist without an associated primary or unique key.
正解：C

質問 4：
Which statements are true regarding columns when using SAS Data Integration Studio's New Tables wizard? 1. You can access metadata for any column from any table already registered in metadata but cannot change it. 2. You can access metadata for any column from any table already registered in metadata and can override the imported information. 3. You can define new columns for the table. 4. You cannot define new columns.
A. 1 and 3
B. 2 and 4
C. 1 and 2
D. 2 and 3
正解：D

質問 5：
Which of the following is NOT a feature of SAS Data Integration Studio's Data Validation transformation?
A. The Data Validation transformation can perform missing-value detection and invalid-value validation in a single pass of the data.
B. The Data Validation transformation can generate match codes to provide de-duplication capabilities.
C. The Data Validation transformation provides de-duplication capabilities.
D. The Data Validation transformation provides error-condition handling.
正解：B

質問 6：
Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has defined source columns and defined target columns. One of the source columns, named COL1, is character with a length of 50. One of the target columns, named COL1, is also character but of length 25. What will happen if the COL1 columns are mapped?
A. The COL1 columns are mapped but an expression is defined for the target COL1 that uses a generic specification of the LENGTH function.
B. The COL1 columns are not mapped because the lengths are different.
C. The COL1 columns are successfully mapped, one-to-one, with no warnings.
D. The COL1 columns are successfully mapped, one-to-one, but a warning occurs.
正解：D

質問 7：
How can you make a SAS Data Integration Studio Generated transformation option required?
A. It is not possible to make an option required.
B. The option can be marked as Requires a non-blank value.
C. The type of the column has to be defined as Required Data source column.
D. The name of the option has to start with _REQUIRED.
正解：B