You want to add a new GUID column named BookGUID toa table named dbo.Book that already contains data.
BookGUID will have a constraint to ensure that it always has a value when new rows are inserted into dbo.
Book. You need to ensure that the new column is assigned a GUID for existing rows. Which four Transact-SQL
statements should you use? (To answer, move the appropriate SQL statements from the list of statementsto
the answer area and arrange them in the correct order.)

You create a view based on the following statement:

You grant the Select permission to User1 for this view. You need to change the view so that it display s only the
records that were processed in the month prior to the current month. You need to ensure that after the
changes, the view functions correctly for User1. Which four Transact-SQL statements should you use? (To
answer, move the appropriate SQL statements from the list of statements to the answer area and arrangethem
in the correct order.)

You use a Microsoft SQL Server 2012 database. You need to create an indexed view within the database for a
report that displays Customer Name and the total revenue for that customer. Which four T-SQL statements
should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer
area and arrange them in the correct order.)

You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the following
definition:

You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only
rows that contain a value in the SpecialOfferID column. Which four Transact-SQL statements should you use?
(To answer, move the appropriate statements from the list of statements to the answer area and arrangethem
in the correct order.)

You use Microsoft SQL Server 2012 to develop a database application. You need to implement a computed
column that references a lookup table by using an INNER JOIN against another table.
What should you do?

You administer a Microsoft SQL Server 2012 databasenamed ContosoDb. The database contains a table
named Suppliers and a column named IsActive in the Purchases schema. You create a new user named
ContosoUser in ContosoDb. ContosoUser has no permissions to the Suppliers table. You need to ensure that
ContosoUser can delete rows that are not active from Suppliers. You also need to grant ContosoUser only the
minimum required permissions. Which Transact-SQL statement should you use?

You use a contained database named ContosoDb withina domain. You need to create a user who can log on
to the ContosoDb database. You also need to ensure that you can port the database to different database
servers within the domain without additional user account configurations. Which type of user should you
create?

You administer a Microsoft SQL Server 2012 databasethat has multiple tables in the Sales schema. Some
users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage
users who are prevented from deleting records in the Sales schema. You need to achieve this goal by using the
minimum amount of administrative effort. What should you do?

You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by
using the following definition:

You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What
should you do?

You generate a daily report according to the following query:

You need to improve the performance of the query. What should you do?