What should you recommend?

You need to recommend a solution that addresses the concurrency requirement. What should you recommend?A . Break each stored procedure into two separate procedures, one that changes Sales.Table1 and one that changes Sales.Table2.B . Make calls to Sales.Proc1 and Sales.Proc2 synchronously.C . Call the stored procedures in a Distributed Transaction Coordinator (DTC) transaction.D ....

Continue reading

Which command should you use only during the monthly maintenance window?

You are designing your maintenance plan. Which command should you use only during the monthly maintenance window?A . DBCC INDEXDEFRAG (ProdDB, SalesOrderDetail, SODIndex)B . ALTER INDEX SODIndex ON SalesOrderDetail REORGANIZEC . ALTER INDEX SODIndex ON SalesOrderDetail REBUILDD . ALTER INDEX SODIndex ON SalesOrderDetail REBUILD WITH (ONLINE * ON) View Answer Answer: D Explanation: *...

Continue reading

What should you recommend?

You need to recommend a solution that addresses the security requirement. What should you recommend?A . Revoke user permissions on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures.B . Grant the users the SELECT permission on the tables. Create views that retrieve data from...

Continue reading
  • Sign up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.