Warning: Undefined variable $in_footer in /var/www/html/exam4training.com/wp-content/themes/ultra-child/functions.php on line 14
What should you create? - Exam4Training

What should you create?

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query.

What should you create?
A . a table
B . an index
C . scalar function
D . a view

Answer: D

Explanation:

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Latest DP-900 Dumps Valid Version with 134 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>