Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 3 Question 18 Discussion

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.
A) Change Salary to the money data type. and E) Change LastHireDate to the date 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.

Microsoft DP-300 Exam - Topic 3 Question 18 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 18
Topic #: 3
[All DP-300 Questions]

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.

Show Suggested Answer Hide Answer
Suggested Answer: A, E

by Eladia at May 08, 2022, 07:43 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Emogene
9 months ago
Changing LastHireDate to date seems like a downgrade.
upvoted 0 times
...
Joseph
9 months ago
Definitely agree on using datetime2 for LastHireDate.
upvoted 0 times
...
Shawn
9 months ago
Surprised they even considered float for PhoneNumber!
upvoted 0 times
...
Silvana
9 months ago
I think PhoneNumber should be bigint, not float.
upvoted 0 times
...
Shelba
9 months ago
Changing Salary to money type makes sense for precision.
upvoted 0 times
...
Audria
9 months ago
I recall that using the date data type can save space compared to datetime. So, option E seems like a solid recommendation.
upvoted 0 times
...
Daisy
10 months 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.
upvoted 0 times
...
Tammi
10 months 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?
upvoted 0 times
...
Yvonne
10 months 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.
upvoted 0 times
...
Moon
10 months 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.
upvoted 0 times
...
Scarlet
10 months ago
This is a tricky one. I'll need to think through the NSF capabilities and how they interact with the different routers.
upvoted 0 times
...
Kati
10 months ago
Hmm, this one seems tricky. I'll need to think it through carefully.
upvoted 0 times
...
Ciara
10 months 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!
upvoted 0 times
...
Laticia
10 months 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.
upvoted 0 times
...

Save Cancel