70-469 Exam - Free Microsoft Questions and Answers

Question #6 (Topic: Topic 1)

You need to modify InsertInvoice to comply with the application requirements.
Which code segment should you execute?
[Microsoft-70-469-5.0/Microsoft-70-469-12_2.png]

A. Option A B. Option B C. Option C D. Option D

Answer: D

Question #7 (Topic: Topic 1)

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 when the subquery is used as an expression."
You need to ensure that IndexManagement.sql executes properly.
Which WHILE statement should you use at line 18?

A. WHILE SUM(@RowNumber) < (SELECT @counter FROM @indextable) B. WHILE @counter < (SELECT COUNT(RowNumber) FROM @indextable) C. WHILE COUNT(@RowNumber) < (SELECT @counter FROM @indextable) D. WHILE @counter < (SELECT SUM(RowNumber) FROM @indextabie)

Answer: B

Question #8 (Topic: Topic 1)

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

Answer: D

Question #9 (Topic: Topic 1)

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 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally."
You need to ensure that you can restore DB1 to a different server.
Which code segment should you execute?
[Microsoft-70-469-5.0/Microsoft-70-469-14_2.png]

A. Option A B. Option B C. Option C D. Option D

Answer: B

Question #10 (Topic: Topic 1)

Which data type should you use for CustomerID?

A. varchar(11) B. bigint C. nvarchar(11) D. char(11)

Answer: D

Microsoft 70-469 - Recertification for MCSE: Data Platform Exam