70-459 試験問題を無料オンラインアクセス

You need to configure security on the Product table for customer support representatives.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

• A.Create a user-defined data type called CustProduct that includes columns ProductID, ProductName, Product Description, and ProductPrice.
• B.Create a view called CustProduct that includes columns ProductID. ProductName, Product Description, QuantityOnHand, ProductPrice, ProductCost, and ProductSupplierID.
• C.Create a view called CustProduct that includes columns ProductID, ProductName, Product Description, QuantityOnHand, and ProductPrice.
• D.GRANT SELECT on CustProduct TO OurDomain\CustomerSupport.
• E.GRANT SELECT on CustProduct TO public.
• F.GRANT ALL on CustProduct TO OurDomain\CustomerSupport

You need to modify Production.ProductDetails_Insert to comply with the application requirements.
Which code segment should you execute?

• A.OPEN DBCERT;
  ALTER PROCEDURE Production. ProductDetails_Insert
  WITH ENCRYPTION;
  CLOSE D3CERT;
• B.ADD SIGNATURE TO Production.ProductDetails_Insert
  BY CERTIFICATE DBCERT;
• C.ADD SIGNATURE TO Production.ProductDetails_Insert
  BY CERTIFICATE PRODUCTSCERT;
• D.OPEN PRODUCTSCERT;
  ALTER PROCEDURE Production. ProductDetails_Insert
  WITH ENCRYPTION;
  CLOSE PRODUCTSCERT;

DRAG DROP
You need to create the usp_AssignUser stored procedure.
Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.

正解：

You are troubleshooting an application that runs a query. The application frequently causes
deadlocks.
You need to identify which transaction causes the deadlock.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Create an extended events session to capture deadlock information.
• B.Query the sys.dm_exec_sessions dynamic management view.
• C.Create a trace in SQL Server Profiler that contains the Deadlock graph event.
• D.Query the sys.dm_exec_requests dynamic management view.

DRAG DROP
You plan to deploy SQL Server 2012.
Your company identifies the following monitoring requirements for the database: - An e-mail message must be sent if the SQL Server Authentication mode changes.
- An e-mail message must be sent if CPU utilization exceeds 90 percent. You need to identify which feature meets each monitoring requirement. Which features should you identify?
To answer, drag the appropriate feature to the correct monitoring requirement in the answer area.

正解：