File Info
| Exam | Developing Microsoft SQL Server 2012/2014 Databases |
| Number | 70-464 |
| File Name | Microsoft.70-464.TestKing.2019-07-25.120q.tqb |
| Size | 10 MB |
| Posted | Jul 25, 2019 |
| Download | Microsoft.70-464.TestKing.2019-07-25.120q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
