MENU
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.
Suggested Answer: A, E
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
14 comments · newest first
EM
Emogene
12 months ago
Changing LastHireDate to date seems like a downgrade.
JO
Joseph
1 year ago
Definitely agree on using datetime2 for LastHireDate.
SH
Shawn
1 year ago
Surprised they even considered float for PhoneNumber!
SI
Silvana
1 year ago
I think PhoneNumber should be bigint, not float.
SH
Shelba
1 year ago
Changing Salary to money type makes sense for precision.
AU
Audria
1 year ago
I recall that using the date data type can save space compared to datetime. So, option E seems like a solid recommendation.
DA
Daisy
1 year ago
I think we practiced a similar question where we changed date types for performance. Option C sounds familiar, but I’m not confident about the specifics.
TA
Tammi
1 year ago
I'm not entirely sure about changing PhoneNumber to float; I feel like that could lead to issues with formatting. Maybe option D is better?
YV
Yvonne
1 year ago
I remember we discussed how using the money data type can help with precision for salary, so I think option A might be a good choice.
MO
Moon
1 year ago
I'm leaning towards option D. Using a Sub-Process node to initialize the review process model seems like a good way to encapsulate the review logic and keep the memory impact low.
SC
Scarlet
1 year ago
This is a tricky one. I'll need to think through the NSF capabilities and how they interact with the different routers.
KA
Kati
1 year ago
Hmm, this one seems tricky. I'll need to think it through carefully.
CI
Ciara
1 year ago
This seems pretty straightforward. I'll just run `kubectl top` with the `name=cpu-utilizer` label, find the pod with the highest CPU usage, and write the name to the file. Easy peasy!
LA
Laticia
1 year ago
Hmm, I'm a bit unsure about this one. I'll need to carefully read through the details and think about what information would be most important for sizing the VSP system.