READ Free Dumps For Microsoft- 70-462
| Question ID 18875 | You develop a database for a travel application.
You need to design tables and other database objects.
You create the Airline_Schedules table.
You need to store the departure and arrival dates and times of flights along with time zone
information.
What should you do?
|
| Option A | Use the CAST function.
|
| Option B | Use the DATE data type.
|
| Option C | Use the FORMAT function.
|
| Option D | Use an appropriate collation.
|
| Option E | Use a user-defined table type.
|
| Option F | Use the DATETIMEOFFSET data type.
|
| Correct Answer | F |
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/ff848733.aspx http://msdn.microsoft.com/en-us/library/bb630289.aspx
| Question ID 18876 | You are a database administrator for a Microsoft SQL Server 2012 environment.
You want to deploy a new application that will scale out the workload to at least five
different SQL Server instances.
You need to ensure that for each copy of the database, users are able to read and write
data that will then be synchronized between all of the database instances.
Which feature should you use?
|
| Option A | Database Mirroring
|
| Option B | Peer-to-Peer Replication
|
| Option C | Log Shipping
|
| Option D | Availability Groups
|
| Correct Answer | B |
Explanation