Which is the correct data type for MarketType on Thursday when Empty Attributes is set to Use Default Data Type?

Prepare for the FME Certified Professional Exam. Study with flashcards and multiple-choice questions; each question includes hints and explanations. Ensure your success!

Multiple Choice

Which is the correct data type for MarketType on Thursday when Empty Attributes is set to Use Default Data Type?

Explanation:
When Empty Attributes is set to Use Default Data Type, the system uses the smallest data type that can hold the actual values in the field. MarketType is a short code, typically a single character, so the proper default is a one-character varchar. That’s why fme_varchar(1) is the best choice. A numeric type isn’t appropriate because this field isn’t a number, and using a longer varchar (like 22 or 255) would be unnecessary and could allow values that won’t occur.

When Empty Attributes is set to Use Default Data Type, the system uses the smallest data type that can hold the actual values in the field. MarketType is a short code, typically a single character, so the proper default is a one-character varchar. That’s why fme_varchar(1) is the best choice. A numeric type isn’t appropriate because this field isn’t a number, and using a longer varchar (like 22 or 255) would be unnecessary and could allow values that won’t occur.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy