70-463 Question #108: Real Exam Question with Answer & Explanation

The correct answer is D: Boolean. The ValidateExternalMetaData property in an SSIS data flow component is of type Boolean, controlling whether external metadata is validated against the data source at design time.

Question

You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the ValidateExternalMetaData property for a data flow. Which of the following represents the data type for this property?

Options

AInteger
BIDTSExternalMetadataColumn100
CString
DBoolean

Explanation

The ValidateExternalMetaData property in an SSIS data flow component is of type Boolean, controlling whether external metadata is validated against the data source at design time.

Common mistakes.

A. The property is not an Integer; it represents a binary true/false validation flag, not a numeric value.
B. IDTSExternalMetadataColumn100 is an interface representing an individual external metadata column object, not the data type of the ValidateExternalMetaData property itself.
C. The property is not a String; it cannot hold text values and strictly represents a binary on/off validation setting.

Concept tested. SSIS data flow ValidateExternalMetaData property data type

Reference. https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-custom-objects/data-flow/validating-a-data-flow-component

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice