Answer A C QUESTION 128 A 100 MB input data set has even distribution across

Answer a c question 128 a 100 mb input data set has

This preview shows page 5 - 7 out of 7 pages.

Answer: A, C QUESTION: 128 A 100 MB input data set has even distribution across 400 unique key values. When run with a 4- node configuration file, which two changes could improve sort performance for this scenario? (Choose two.) A. Set $APT_TSORT_STRESS_BLOCKSIZE to 50 MB. B. Specify Round Robin partitioning on the input link to the Sort stage. C. Specify "Restrict Memory Usage" to 60 MB on the Sort stage properties. D. Alter the Sort stage properties to perform a Stable sort. Answer: A, C QUESTION: 129 You are assigned to write a job that reads in a Sequential File, applies some business logic, and writes the results to a database. However, the layout of the input file will change from run to run. All of the columns will remain the same, but the order of the columns will change. Which feature of the Sequential File stage would allow you to accomplish this task? 53
Image of page 5
A. Filter B. First Line Is Column Names C. Reject Mode D. Schema File Answer: D QUESTION: 130 Which requirement must be met to read from a database in parallel using the ODBC Enterprise stage? A. Specify the partitioncol property. B. ODBC Enterprise stage always reads in parallel. C. Configure environment variable $APT_PARTITION_COUNT. D. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE. Answer: A QUESTION: 131 Which two partitioning methods are keyless? (Choose two.) A. Round Robin B. Entire C. Hash D. Modulus Answer: A, B 54
Image of page 6
For More exams visit http s ://killexams.com /vendors-exam-list Kill your exam at First Attempt .... Guaranteed!
Image of page 7

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '19
  • Relational model, Stagecraft

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture