Online Access Free C2090-625 Exam Questions

Which of the following is an advantage of using conformed dimensions in a data warehouse?

• A.Conformed dimensions enable users to drill from one area of their business to another.
• B.Conformed dimensions enable database views to be reused across the data warehouse.
• C.Conformed dimensions do not require the use of surrogate keys.
• D.Conformed dimensions do not require the use of lookups.

When delivering fact data to a text file, what can be specified?

• A.Default text editor to use with the file
• B.Maximum number of rows to be stored in the file
• C.Whether the file is in ASCII or EBCDIC format
• D.Line and field delimiters

When this JobStream is executed,

what is the maximum number of nodes that will run in parallel at any one time?

• A.8
• B.7
• C.4
• D.3

Where can a variable be declared?

• A.In a Data Manager folder.
• B.In a build specification.
• C.In a data source connection.
• D.In a hierarchy.

A text file contains a row at the top that only identifies the names of the columns. In order for this file to be processed successfully, what must the developer do in SQLTXT Designer?

• A.Specify that the file contains one header line.
• B.Specify that the header row ignore limit is one.
• C.Specify NL as the record delimiter.
• D.Specify CR as the record delimiter.