A00-260 practice question 7 of 15

Which statement correctly defines a System DSN?

Full set: 70 questions
Answer options
A: Not specific to an individual user. Anyone with permission to access the data source can use it. Correct answer
B: Specific to an individual user. It is available only to the user who creates it.
C: Not specific to an individual user. It can be shared among users even though it is created locally.
D: Specific to an individual user. But it can be shared among users.
Correct Answer:
A. Not specific to an individual user. Anyone with permission to access the data source can use it.
Explanation

A System Data Source Name (DSN) is a connection definition stored on a specific computer, not within a user's profile. This configuration makes it available to all users and services running on that machine. Any user who logs into the computer can utilize the System DSN to connect to the database, provided they have the appropriate permissions for the underlying data source itself. This contrasts with a User DSN, which is accessible only to the user who created it.

Why Incorrect

B. This statement accurately defines a User DSN, which is private to the user account that created it and is not visible to other users on the same machine.
C. While a System DSN is not user-specific and is shared, option A provides a more complete and precise definition by including the crucial condition of permissions.
D. This statement is contradictory. A DSN cannot be both "specific to an individual user" and inherently shareable among all users in the way a System DSN is designed.

References

1. SAS Institute Inc. (2016). SAS/ACCESS® 9.4 Interface to ODBC: Reference, Fourth Edition. Cary, NC: SAS Institute Inc.

In Chapter 2, "Configuration for ODBC," the section "About the ODBC Driver Manager and ODBC Drivers" explains the different types of data sources. It states, "A system data source can be used by anyone who uses the system." This directly supports the definition in option A.

2. Microsoft. (2021). ODBC Programmer's Reference: Managing Data Sources. Microsoft Docs.

In the section detailing data source types, the documentation specifies that System DSNs are stored in the HKEYLOCALMACHINE tree in the system registry. It clarifies that "System data sources can be used by more than one user on one machine. They can also be used by system services..." This confirms that a System DSN is not user-specific and is available system-wide.

3. Indiana University. (2023). Create an ODBC data source on Windows. University Information Technology Services Knowledge Base.

In the article explaining ODBC setup, it defines the DSN types: "A System DSN is available to all users of a computer, and is the required type for services." This university resource corroborates that a System DSN is not specific to an individual user.

Scroll to Top