Microsoft
DP-300 · Question #9
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…
The correct answer is A. Change Salary to the money data type. E. Change LastHireDate to the date data type. A: Money takes less space compared to VARCHAR(20) E: Date takes less space compared to Datetime. https://docs.microsoft.com/eN-Us/sql/t-sql/data-types/data-types-transact-sql
Submitted by femi9· Mar 6, 2026Plan and implement data platform resources
Question
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.
Exhibits
Options
- AChange Salary to the money data type.
- BChange PhoneNumber to the float data type.
- CChange LastHireDate to the datetime2(7) data type.
- DChange PhoneNumber to the bigint data type.
- EChange LastHireDate to the date data type.
How the community answered
(17 responses)- A71% (12)
- B18% (3)
- C6% (1)
- D6% (1)
Explanation
A: Money takes less space compared to VARCHAR(20) E: Date takes less space compared to Datetime. https://docs.microsoft.com/eN-Us/sql/t-sql/data-types/data-types-transact-sql
Community Discussion
No community discussion yet for this question.