A00-260 practice question 7 of 15
Which statement correctly defines a System DSN?
Full set: 70 questionsA 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.
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.
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.
Keep practicing
Take the free A00-260 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other A00-260 practice questions
- Question 1Which statement regarding scheduling SAS Data Integration Studio jobs is true?
- Question 3Assume that you have completed the Register Tables wizard in SAS Data Integration Studio.…
- Question 4Assume that SAS Data Integration Studio Table Loader is being used in a job. The load sty…
- Question 5When using the SCD Type 2 load method in SAS Data Integration Studio, which columns can b…
- Question 6The ability to deploy a SAS Data Integration Studio job as a Web service or a SAS Stored …
- Question 8Which action is required for enabling performance statistics on the executing SAS Workspa…
