Registering metadata for an ODBC data source involves registering:

Question

Options

• Aa library that will use a SAS/ACCESS engine to a specific database
• Bonly an ODBC data source definition
• Ca server definition that points to the ODBC data source and a library accessing this server
• Da table pointing directly to the ODBC data source

• A
  4% (1)
• B
  4% (1)
• C
  92% (24)

Explanation

Registering an ODBC data source in SAS metadata requires two components: a server definition (which points to/defines the ODBC data source connection) and a library definition (which references that server to make data accessible). Neither piece alone is sufficient - the library needs the server to know where to connect, and the server definition alone doesn't expose any data to SAS users.

• A is wrong because a SAS/ACCESS engine library alone doesn't cover the full metadata registration; the server definition connecting to the ODBC source is also required.
• B is wrong because registering only the ODBC data source definition (the server side) omits the library that SAS processes actually use to access the data.
• D is wrong because metadata registration doesn't involve pointing a table directly to a data source - tables live inside libraries, which live inside the server/library hierarchy.

Memory tip: Think of it as a two-layer sandwich - the server definition is the bottom slice (points to the external ODBC source), and the library is the top slice (what SAS uses to read data). You need both slices to have a complete registration.

No community discussion yet for this question.