You need to build a stored procedure that amortizes the invoice amount. Which code segment should you use to create the stored procedure? To answer, move the appropriate code segments from the list of code segments to the answer area…
You need to provide referential integrity between the Sessions table and Speakers table. Which code segment should you add at line 47 of Tables.sql? A. Option A B. Option B C. Option C D. Option D
You execute usp_TestSpeakers. You discover that usp_SelectSpeakersByName uses inefficient execution plans. You need to update usp_SelectSpeakersByName to ensure that the most efficient execution plan is used. What should you add at line 30 of Procedures.sql? A. OPTION (FORCESCAN) B. OPTION…
You need to recommend a solution to ensure that SQL1 supports the auditing requirements of usp_UpdateSpeakerName. What should you include in the recommendation? A. The Distributed Transaction Coordinator (DTC) B. Transactional replication C. Change data capture D. Change tracking
You execute IndexManagement.sql and you receive the following error message: "Msg 512, Level 16, State 1, Line 12 Subquery returned more than 1 value. This is not permitted when the subquery follows =,! =, <, <= ,>, > = or…
Which data type should you use for CustomerID? A. varchar(11) B. bigint C. nvarchar(11) D. char(11)
You need to modify InsertInvoice to comply with the application requirements. Which code segment should you execute? A. Option A B. Option B C. Option C D. Option D
You attempt to process an invoice by using usp_InsertInvoice.sql and you receive the following error message: "Msg 515, Level 16, State 2, Procedure usp_InsertInvoice, Line 10 Cannot insert the value NULL into column ‘InvoiceDate’, table ‘DB1.Accounting.Invoices’; column does not allow…
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? A. 04 B. 05 C. 06 D. 19
You are testing disaster recovery procedures. You attempt to restore DB1 to a different server and you receive the following error message: "Msg 33111. Level 16, State 3, Line 1 Cannot find server certificate with thumbprint ,0xA694FBEA88C9354E5E2567C30A2A69E8FB4C44A9 Msg 3013, Level…