DP-300 · Question #9
DP-300 Question #9: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
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.
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.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.