You administer a Microsoft SQL Server database named Contoso on a server named Server01.
You need to collect data for a long period of time to troubleshoot wait statistics when querying Contoso. You also need to ensure minimum impact to the server.
What should you create?

• A. A Database Audit Specification
• B. An Extended Event session
• C. A SQL Profiler Trace
• D. A Server Audit Specification
• E. A Resource Pool
• F. A Policy
• G. An Alert

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?

• A. SELECT c.CustomerID, c.CustomerName, o.ShippingCountryFROM Customer cINNER JOIN(SELECT CustomerID, ShippingCountry,RANK() OVER (PARTITION BY CustomerIDORDER BY COUNT(OrderAmount) DESC) AS RnkFROM OrdersGROUP BY CustomerID, ShippingCountry) AS oON c.CustomerID = o.CustomerIDWHERE o.Rnk = 1
• B. SELECT c.CustomerID, c.CustomerName, o.ShippingCountryFROM Customer cINNER JOIN(SELECT CustomerID, ShippingCountry,COUNT(OrderAmount) DESC) AS OrderAmountFROM OrdersGROUP BY CustomerID, ShippingCountry) AS oON c.CustomerID = o.CustomerIDORDER BY OrderAmount DESC
• C. SELECT c.CustomerID, c.CustomerName, o.ShippingCountryFROM Customer cINNER JOIN(SELECT CustomerID, ShippingCountry,RANK() OVER (PARTITION BY CustomerIDORDER BY OrderAmount DESC) AS RnkFROM OrdersGROUP BY CustomerID, ShippingCountry) AS oON c.CustomerID = o.CustomerIDWHERE o.Rnk = 1
• D. SELECT c.CustomerID, c.CustomerName, o.ShippingCountryFROM(SELECT c.CustomerID, c.CustomerName, o.ShippingCountry,RANK() OVER (PARTITION BY CustomerIDORDER BY COUNT(o.OrderAmount) ASC) AS RnkFROM Customer cINNER JOIN Orders oON c.CustomerID = o.CustomerIDGROUP BY c.CustomerID, c.CustomerName, o.ShippingCountry) csWHERE Rnk = 1

You administer a Microsoft SQL Server database that 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?

• A. Create a custom database role that includes the users. Deny Delete permissions on the Sales schema for the custom database role.
• B. Create a custom database role that includes the users. Deny Delete permissions on each table in the Sales schema for the custom database role.
• C. Include the Sales schema as an owned schema for the db_denydatawriter role. Add the users to the db_denydatawriter role.
• D. Deny Delete permissions on each table in the Sales schema for each user.

You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance.
The application is unable to connect to the database on the named instance.
You need to ensure that the application can connect to the named instance.
What should you do?

• A. Use the Master Data Services Configuration Manager to configure the application.
• B. Start the SQL Server Integration Services Service.
• C. Use the Data Quality Client to configure the application.
• D. Start the SQL Server Browser Service.

You administer a Microsoft Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?

• A. Add all users to the db_datawriter role. Add all users to the db_datareader role.
• B. Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Add all users to the role. Add all users to the db_datareader role.
• C. Grant EXECUTE permission on p_AddInventory to all users. Grant VIEW DEFINITION to all users.
• D. Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Grant VIEW DEFINITION to the role. Add all users to the role.