DP-300 Web TestEngine demo

A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table.

You need to recommend changes to the data types to reduce storage and improve performance.

Which two actions should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply.

• A

  Change Salary to the money data type.

• B

  Change PhoneNumber to the float data type.

• C

  Change LastHireDate to the datetime2(7) data type.

• D

  Change PhoneNumber to the bigint data type.

• E

  Change LastHireDate to the date data type.