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?

You develop a database application for a university. You need to create a view that will be indexed that meets
the following requirements:
Displays the details of only students from Canada.
Allows insertion of details of only students from Canada.
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 arrange them in the correct order.)

You create the following stored procedure. (Line numbers are included for reference only.)

You need to ensure that the stored procedure performs the following tasks:
If a record exists, update the record.
If no record exists, insert a new record.
Which four Transact-SQL statements should you insert at line 07? (To answer, move the appropriate
statements from the list of statements to the answer area and arrange them in the correct order.)

You use Microsoft SQL Server 2012 to develop a database application. You create two tables by using the
following table definitions.

Which six Transact-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 use Microsoft SQL Server 2012 to develop a database application. You create a table by using the
following definition:
CREATE TABLE Prices (
PriceId int IDENTITY(1,1) PRIMARY KEY,
ActualPrice NUMERIC(16,9),
PredictedPrice NUMERIC(16,9)
)
You need to create a computed column based on a user-defined function named udf_price_index. You also
need to ensure that the column supports an index. Which three 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.)