Microsoft Azure Data Fundamentals DP-900 Practice Question
In Azure SQL Database, you must give analysts a single, simplified, read-only object that combines data from multiple tables. The object should return current data each time it is queried and must not physically store the rows. Which database object should you create?
A view is a virtual table whose definition is a stored SELECT statement. Because it holds no persistent data, each query against the view retrieves the latest rows from its underlying tables, giving analysts an up-to-date, simplified result set. A table physically stores data, a stored procedure runs predefined code rather than acting as a reusable query object, and an index only speeds data access-it does not present data in a combined, user-friendly form.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is an Azure SQL Database view?
Open an interactive chat with Bash
How do views differ from stored procedures in Azure SQL Database?
Open an interactive chat with Bash
Can views improve data querying performance in Azure SQL Database?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Identify considerations for relational data on Azure
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .