Ceritified Information
Correct Answer for the following Question is given below You need to monitor the health of your tables and indexes in order to implement the required index maintenance strategy.What should you do?From scenario:* You need to anticipate when POSTransaction table will need index maintenance.* The index maintenance strategy for the UserActivity table must provide the … Read more
Correct Answer for the following Question is given below You discover that usp.SelectSpeakersByName executes slowly if usp_UpdateSpeakerName executes simultaneously.You need to minimize the execution time of usp.SelectSpeakersByName. The solution must not affect the performance of the other stored procedures.What should you update?NOLOCKIs equivalent to READUNCOMMITTED.READUNCOMMITTEDSpecifies that dirty reads are allowed. Question: What should you update? … Read more
Correct Answer for the following Question is given below You execute IndexManagement.sql and you receive the following error message:”Msg 512, Level 16, State 1, Line 12Subquery returned more than 1 value. This is not permitted when the subquery follows =,! =, = or when the subquery is used as an expression.”You need to ensure that … Read more
Correct Answer for the following Question is given below Which data type should you use for CustomerID?Invoices.xmlAll customer IDs are 11 digits. The first three digits of a customer ID represent the customer’s country. The remaining eight digits are the customer’s account number. int: -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647) (just 10 digits max) bigint: -2^63 … Read more
Correct Answer for the following Question is given below You need to create the object used by the parameter of usp_UpdateEmployeeName.Which code segment should you use?Example Usage of Table-Valued Parameters (Database Engine) http://msdn.microsoft.com/en-us/library/bb510489.aspx (Benefits of using Table-Valued Parameters)/* Create a table type. */CREATE TYPE LocationTableType AS TABLE( LocationName VARCHAR(50), CostRate INT );GO/* Create a procedure … Read more
Correct Answer for the following Question is given below You need to modify the Orders table to store the XML data used by the retailers.Which statement should you execute?ADD originalOrder XML (ValidateOrder);ADD originalOrder XML;ADD originalOrder varchar(max);ADD originalOrder varbinary(max); Question: Which statement should you execute? Options: ALTER Orders ALTER Orders ALTER Orders ALTER Orders Correct Answer … Read more
Correct Answer for the following Question is given below You plan to create a database that has multiple tables. The tables will contain product information. Each product has a stock-keeping unit (SKU).You need to recommend a solution to ensure that each SKU starts with the letters “ADV” and is followed by 10 digits.The solution must … Read more
Correct Answer for the following Question is given below You need to modify the function in CountryFromID.sql to ensure that the country name is returned instead of the country ID.Which line of code should you modify in CountryFromID.sql?http://msdn.microsoft.com/en-us/library/ms186755.aspxhttp://msdn.microsoft.com/en-us/library/ms191320.aspx Question: Which line of code should you modify in CountryFromID.sql? Options: 4 5 6 19 Correct Answer … Read more
Correct Answer for the following Question is given below You have a Microsoft SQL Azure database that contains a table named Customers. You have a table-valued function named TopCustomers that returns a list of all the customers that have purchased items during the last 12 months. The ID of the customer is passed as an … Read more
Correct Answer for the following Question is given below You need to implement a solution that addresses the index monitoring requirements.What should you do? Question: What should you do? Options: Schedule a SQL Server Agent job that saves data from the dynamic management views to a table in the database. Create a SQL Server Audit … Read more