nerdexam
ServiceNow

CSA · Question #457

A manager is complaining that they can't get the data they need on a report because the data resides in two different tables. This data is used for many different reports in their department. You…

The correct answer is C. Create a Database View. In ServiceNow, when reporting data is required from multiple tables and dot-walking isn't feasible, creating a Database View is often the best approach. A Database View allows joining multiple tables virtually without creating new records, making it highly efficient for…

Submitted by yuriko_h· Apr 18, 2026Database Management and Platform Security

Question

A manager is complaining that they can't get the data they need on a report because the data resides in two different tables. This data is used for many different reports in their department. You have checked to see if dot-walking will meet the requirement, and it is not possible. What else might you try to help this manager?

Options

  • ACreate a custom table
  • BCreate a Report Template
  • CCreate a Database View
  • DExport the tables to a spreadsheet
  • ECreate a Report Source

How the community answered

(38 responses)
  • A
    5% (2)
  • B
    11% (4)
  • C
    82% (31)
  • D
    3% (1)

Explanation

In ServiceNow, when reporting data is required from multiple tables and dot-walking isn't feasible, creating a Database View is often the best approach. A Database View allows joining multiple tables virtually without creating new records, making it highly efficient for reporting. This view can then be used as a data source for reports, pulling information across tables without physically combining data. According to ServiceNow documentation, this is especially useful for creating complex reports that rely on data relationships across tables without altering the underlying data

Topics

#Database View#Reporting#Data Integration#Table relationships

Community Discussion

No community discussion yet for this question.

Full CSA Practice