070-464 무료 덤프문제 온라인 액세스

You need to resolve the performance issues of the usp_getOpenings stored procedure.
Which three actions should you perform? Each correct answer presents part of the solution.

• A.Replace lines 12, 13, and 14 with the Transact SQL Segment:
  WHERE (Contains(o.Description, 'FORMSOF(INFLECTIONAL, '+@keyword+')'))
• B.Replace lines 12, 13, and 14 with the Transact_SQL segment:
  WHERE (CONTAINS(o.Description, @keyword))
• C.Delete lines 05 through 08
• D.Create a full text index on the Description column
• E.Replace lines 12, 13, and 14 with the Transact-SQL segment:
  WHERE (CONTAINS(o.Description, 'ISABOUT(' +@keyword+' weight (.5))'))

You need to implement a change to usp_ExportOpenings that meets the integration requirements.
What should you modify in usp_ExportOpenings? (Each correct answer presents part of the solution. Choose all that apply?)

• A.To the end of line 04, add [Opening!ELEMENT].
• B.To the end of line 06, add [Opening! salary].
• C.To the end of line 04, add [Opening].
• D.To the end of line 05, add [Opening! title].
• E.To the end of line 06, add [Opening!salary!ELEMENT].
• F.To line 10, add FOR XML AUTO.
• G.To line 10, add FOR XMLEXPLICIT.
• H.To line 10, add FOR XML RAW.
• I.To the end of line 05, add [Opening!title!ELEMENT].

An administrator provides a digital certificate named ServerCert.
You need to implement Transparent Data Encryption (TDE) on ProductsDB.
Which code segment should you use?

• A.USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY
  ENCRYPTION BY SERVER CERTIFICATE DBCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• B.USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = TRIPLE_DES_3KEY
  ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• C.USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256
  ENCRYPTION BY SERVER CERTIFICATE DBCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO
• D.USE PRODUCTSDB;
  GO
  CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256
  ENCRYPTION BY SERVER CERTIFICATE PRODUCTSCERT;
  GO
  ALTER DATABASE PRODUCTSDB SET ENCRYPTION ON;
  GO

You are evaluating the index design.
You need to recommend a change to Indexes.sql that will minimize the amount of time it takes for usp_AttendeesReport to execute. The solution must minimize the amount of database fragmentation.
Which line of code should you use to replace line 12 of Indexes.sql?

• A.(LastName) INCLUDE (FirstName);
• B.(LastName);
• C.(FirstName) INCLUDE (LastName);
• D.(LastName, FirstName);

You need to ensure that a new execution plan is used by usp_GetOrdersByProduct each time the stored procedure runs.
What should you do?

• A.Add WITH (FORCESEEK) to line 07 in usp_GetOrdersByProduct.
• B.Add WITH RECOMPILE to line 03 in usp_GetOrdersByProduct.
• C.Execute sp_help 'usp_GetOrdersByProduct'.
• D.Execute sp_recompile 'usp_GetOrdersByProduct'.