You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the
contents of a fact table that contains a non-clustered columnstore index. You need to run an update
statement against the table. What should you do first?

You need to create a view named uv_CustomerFullNames. The view must prevent the underlying
structure of the customer table from being changed. Part of the correct T-SQL statement has been
provided in the answer area. Provide the complete code.

Which of the following functions would you consider using to generate surrogate keys? (Choose all
that apply.)

Why is it important to use the appropriate type for attributes?

Which of the following practices are considered bad practices? (Choose all that apply.)

What are the mandatory clauses in a SELECT query, according to T-SQL?

What is the importance of the ability to assign attribute aliases in T-SQL? (Choose all that apply.)

What is true about the result of a query without an ORDER BY clause?

Which of the following is invalid? (Choose all that apply.)

Which of the following correctly represents the logical query processing order of the various query
clauses?