You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create? 

Answer options:

A. an index
B. a view
C. a scalar function
D. a table

B

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