You are using the Database Engine Tuning Advisor (DTA) to analyze a workload. You need to save the recommendations generated by the DTA. Which command should you use? A. Export Session Results B. Export Session Definition C. Import Session Definition…

You have a table named Customer that has an XML column named Locations. This column stores an XML fragment that contains details of one or more locations, as show in the following examples. <Location City="Sydney" Address="…" PhoneNumber="…" /><Location City="Chicago" Address="…"…

Your company manufactures and distributes bicycle parts. You have a full-text catalog on the Inventory table which contains the PartName and Description columns. You also use a full-text thesaurus to expand common bicycle terms. You need to write a full-text…

You use a table that stores movie information in your database. The table has the following schema: CREATE TABLE Movies( MovieID nchar(4) NOT NULL, Title nvarchar(25) NOT NULL, MovieDescription nvarchar(50) NULL, Rating smallint NOT NULL CONSTRAINT Check_Rating CHECK (Rating between…

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 time, an…

You need to generate the following XML document. <ProductExport> <Product Price="99">Product1</Product> <Product Price="199">Product2</Product> <Product Price="299">Product3</Product> <Product Price="399">Product4</Product></ProductExport> Which query should you use? A. SELECT Price, ProductName FROM Products FOR XML AUTO, ROOT(‘ProductExport’) B. SELECT Price [@Price],ProductName AS [*] FROM Products…

You administer a Microsoft SQL Server 2008 R2 database that has a table named Customer. The table has the following definition: CREATE TABLE Customer ( CustomerID int NOT NULL PRIMARY KEY, FirstName varchar(255) NOT NULL, LastName varchar(255) NOT NULL, CustomerAddress…

You work for a company that provides marketing data to other companies. You have the following Transact-SQL statement: DECLARE @CustomerDemographics XML SET @CustomerDemographics=N'<CustomerDemographics> <Customer CustomerID="1" Age="21" Education="High School"> <IsCoffeeDrinker>0</IsCoffeeDrinker> </Customer> <Customer CustomerID="2" Age="27" Education="College"> <IsCoffeeDrinker>1</IsCoffeeDrinker> <IsFriendly>1</IsFriendly> </Customer> <Customer CustomerID="3" Age="35"…

You have a SQL Server database. The database contains two schemas named Marketing and Sales. The Marketing schema is owned by a user named MarketingManager. The Sales schema is owned by a user named SalesManager. A user named John must…

You create a stored procedure that contains proprietary formulas. You need to ensure that no users are able to access Microsoft SQL Server Management Studio to view the definition of the stored procedure. Which code segment should you use? A.…