Home » Microsoft » 70-762 » What should you add at line 02?
You need to create a view that can be indexed.
You write the following statement.
What should you add at line 02?
A. with check_option
B. with recompile
C. with view_metadata
D. with schemabinding
Correct Answer: D
Explanation/Reference:
Explanation:
The following steps are required to create an indexed view and are critical to the successful implementation of the indexed view:
1. Verify the SET options are correct for all existing tables that will be referenced in the view.
2. Verify that the SET options for the session are set correctly before you create any tables and the view.
3. Verify that the view definition is deterministic.
4. Create the view by using the WITH SCHEMABINDING option.
5. Create the unique clustered index on the view.
References: https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-2017