70-463 · Question #229
Which of the following T-SQL functions is not very useful for capturing lineage information?
The correct answer is C. DEVICE_STATUS(). DEVICE_STATUS() is not a real T-SQL function and therefore cannot be used for capturing lineage information. The other functions return session, user, or login context.
Question
Which of the following T-SQL functions is not very useful for capturing lineage information?
Options
- AAPP_NAME()
- BUSER_NAME()
- CDEVICE_STATUS()
- DSUSER_SNAME()
How the community answered
(27 responses)- A7% (2)
- C89% (24)
- D4% (1)
Why each option
DEVICE_STATUS() is not a real T-SQL function and therefore cannot be used for capturing lineage information. The other functions return session, user, or login context.
APP_NAME() returns the name of the application connected to the current session, making it useful for tracking which application wrote or modified data.
USER_NAME() returns the database username of the current session, which is directly useful for recording who performed a data operation.
DEVICE_STATUS() does not exist as a T-SQL system function; it is a fictitious option and has no ability to return any session or identity context useful for data lineage tracking.
SUSER_SNAME() returns the login name associated with a security identification number, providing server-level identity context valuable for lineage auditing.
Concept tested: T-SQL system functions for data lineage and auditing
Source: https://learn.microsoft.com/en-us/sql/t-sql/functions/app-name-transact-sql
Topics
Community Discussion
No community discussion yet for this question.