Download Microsoft.70-464.TestKing.2019-07-25.120q.tqb
| Vendor: | Microsoft |
| Exam Code: | 70-464 |
| Exam Name: | Developing Microsoft SQL Server 2012/2014 Databases |
| Date: | Jul 25, 2019 |
| File Size: | 10 MB |
Demo Questions
Question 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?
- Option A
- Option B
- Option C
- Option D
Correct answer: B
Question 2
You need to create the InvoiceStatus table in DB1.
How should you define the InvoiceID column in the CREATE TABLE statement?
- Option A
- Option B
- Option C
- Option D
Correct answer: C
Question 3
Which data type should you use for CustomerID?
- varchar(11)
- bigint
- nvarchar(11)
- char(11)
Correct answer: D
Explanation:
Invoices.xml All 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 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807) References:http://msdn.microsoft.com/en-us/library/ms176089.aspxhttp://msdn.microsoft.com/en-us/library/ms187745.aspx Invoices.xml
All 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 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
References:
http://msdn.microsoft.com/en-us/library/ms176089.aspx
http://msdn.microsoft.com/en-us/library/ms187745.aspx
