Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series. You are a developer for a Microsoft SQL…

You have a table named Sales.SalesOrderHeader and a table named Person.Person. You are tasked to write a query that returns SalesOrderID and SalesPersonName that have an OrderDate greater than 20040101. SalesPersonName should be made up by concatenating the columns named…

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series. You are a developer for a Microsoft SQL…

You have two tables named Customer and SalesOrder. In the Customer table you have 1000 customers, of which 900 customers have orders in the SalesOrder table. You execute the following query to list all customers that have had at least…

You attempt to query sys.dm_db_index_usage_stats to check the status on the indexes in the Contoso database. The query fails and you receive the following error: "The user does not have permission to perform this action." You need to have the…

You have created an assembly that utilizes unmanaged code to access external resources. You need to deploy the assembly with the appropriate permissions. Which permission set should you use? A. UNSAFE B. EXTERNAL_ACCESS C. SAFE D. Default permission set

You have two tables. A table named Student.CurrentStudents contains the names of all students enrolled for the current year. Another table named Student.NewYearRoster contains the names of students who have enrolled for the upcoming year. You have been tasked to…

You have the following rows in the Customer Table: CustomerId Status 1 Active 2 Active 3 Inactive 4 NULL 5 Dormant 6 Dormant You write the following query to return all customers that do not have NULL or ‘Dormant’ for…

You are the database developer for a customer service application. The database has the following table and view. CREATE TABLE Tickets (TicketId int, Department varchar(200), Status varchar(200), IsArchived bit); GO CREATE VIEW SupportTickets (TicketId, Department, Status, IsArchived) AS SELECT t.TicketId,…

You administer a database named Contoso running on a Microsoft SQL Server 2008 R2 instance. You plan to implement custom error handling in your application. You need to implement custom error handling that meets the following requirements: •The custom message…