EnsurepassQUESTION 141 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…
Read more
EnsurepassQUESTION 131 You are the administrator of a SQL Server database. Database table modifications and additions must occur only between 11:00 P.M. and midnight. You need to ensure that if database table modifications or additions are attempted at any other…
Read more
EnsurepassQUESTION 121 You administer a Microsoft SQL Server 2008 database named AdventureWork that contains a table named Production.Product. The table has the following definition: CREATE TABLE [Production].[Product]( [ProductID] [int] IDENTITY(1,1) NOT NULL, [ProductName] [nvarchar](50) NOT NULL, [ListPrice] [money] NOT NULL,…
Read more
EnsurepassQUESTION 111 You have a table named Stores that has an XML column named OpenHours. This column contains the opening and closing times. <hours dayofWeek="Monday" open="8:00" closed="18:00" /> <hours dayofWeek="Tuesday" open="8:00" closed="18:00" /> … <hours dayofWeek="Saturday" open="8:00" closed="18:00" /> You…
Read more
EnsurepassQUESTION 101 You have a database server that has four quad-core processors. This database server executes complex queries that are used to generate reports. You need to force a query to use only one processor core without affecting other queries….
Read more
EnsurepassQUESTION 91 A table named Shirts includes an XML column named SizeAndColors that contains the sizes and colors of each shirt, as shown in the following code segment. <shirt size="XS" colors="Red" /><shirt size="S" colors="Red, Blue" />…<shirt size="XL" colors="Blue, Green" />…
Read more
EnsurepassQUESTION 81 You are tasked with creating a workload that will be used by the Database Engine Tuning Advisor (DTA). You need to create a workload in an appropriate format. Which format should you choose? (Each correct answer represents a…
Read more
EnsurepassQUESTION 71 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 administer a Microsoft SQL Server…
Read more
EnsurepassQUESTION 61 You have a server named Contoso with multiple databases. You have been tasked to write a PowerShell script to determine which databases on the server are larger than 100GB. You open PowerShell from SQL Server Management Studio. You…
Read more
EnsurepassQUESTION 51 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…
Read more
EnsurepassQUESTION 41 You have a database that contains two tables named ProductCategory and ProductSubCategory. You need to write a query that returns a list of product categories that contain more than ten sub-categories. Which query should you use? A. SELECT…
Read more
EnsurepassQUESTION 31 You have two tables named SalesPerson and SalesTerritory. You need to create sample data by using a Cartesian product that contains the data from the SalesPerson and SalesTerritory tables. Which code segment should you use? A. SELECT p.SalesPersonId,t.Name…
Read more