FC0-U61 · Question #616
A user wants to use a workstation to view data ad hoc from a company database. Which of the following access methods would be BEST?
The correct answer is B. Report builder. For ad hoc viewing of data from a company database, a report builder is the best access method as it allows users to create custom queries and reports without extensive technical knowledge.
Question
A user wants to use a workstation to view data ad hoc from a company database. Which of the following access methods would be BEST?
Options
- ACommand-line interface
- BReport builder
- CUser interface
- DProgrammatic
How the community answered
(45 responses)- A16% (7)
- B73% (33)
- C4% (2)
- D7% (3)
Why each option
For ad hoc viewing of data from a company database, a report builder is the best access method as it allows users to create custom queries and reports without extensive technical knowledge.
A command-line interface (CLI) for a database typically requires knowledge of SQL or specific database commands, which is not suitable for a general user wanting ad hoc access.
A report builder provides a graphical interface and tools for users to define criteria, select data fields, and generate custom reports from a database on demand, which is ideal for ad hoc data viewing without requiring advanced programming or SQL skills.
A general "user interface" is too broad; while a report builder has a UI, just any UI might not offer the flexibility for ad hoc querying specifically.
Programmatic access requires writing code (e.g., Python, Java) to interact with the database, which is beyond the scope of a user simply wanting to view data ad hoc.
Concept tested: Database ad hoc reporting tools
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/report-builder-in-sql-server-reporting-services?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.