In an Azure SQL Database, you want to expose a predefined SELECT statement as a reusable, logical table that does not permanently store data but can be referenced in other queries. Which type of database object meets this requirement?
Trigger
Stored procedure
View
Index
A view is a virtual table whose result set is defined by a stored SELECT statement. It contains no persisted rows; instead, the query in the view definition runs each time the view is referenced, making the data appear as a table while remaining logically separated from physical storage. An index is a physical on-disk structure used to speed up data access, not to present query results. A trigger is a piece of code that automatically executes in response to data modification events, and a stored procedure is an executable batch of T-SQL that must be explicitly invoked with EXEC and is not queried like a table. Therefore, only a view satisfies the requirement for a reusable, data-agnostic, table-like object.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.