QuestionQ85

VerifiedMonitor, configure, and optimize database resources

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

Question Image

You need to recommend data-type changes that 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.

Choose two
Explanation

money is an 8-byte SQL Server type designed for monetary values, making it more compact and appropriate than VARCHAR(20) for salary. When only a hire date is required, date stores the calendar date in 3 bytes, whereas datetime stores a date and time in 8 bytes. Phone numbers should remain character data because they are identifiers that can require formatting and are not used in numeric calculations.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!