You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.
The Sales database is configured as shown in the following table. You discover that Sales_2.ndf is
corrupt. You need to recover the corrupted data in the minimum amount of time. What should you
do?

You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an
application. You need to evaluate existing and potential clustered and non-clustered indexes that

will improve performance. What should you do?

You use a contained database named ContosoDb within a 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 use a contained database named ContosoDb within a 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 database named 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 Microsoft SQL Server 2012 to develop a database application. You need to create an
object that meets the following requirements:
– Takes an input variable.
– Returns a table of values Cannot be referenced within a view.
Which object should you use?

You are a database developer for an application hosted on a Microsoft SQL Server 2012 server.
The database contains two tables that have the following definitions:

Global customers place orders from several countries. You need to view the country from which
each customer has placed the most orders. Which Transact-SQL query do you use?

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 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 database that includes a table named Customers that contains more than 750
rows. You create a new column named PartitionNumber of the int type in the table. You need to
assign a PartitionNumber for each record in the Customers table. You also need to ensure that the
PartitionNumber satisfies the following conditions:
– Always starts with 1.
– Starts again from 1 after it reaches 100.
Which Transact-SQL statement should you use?