Microsoft DP-300 Exam - Topic 3 Question 18 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 18
Topic #: 3

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.

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.

Show Suggested 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:

Submit Cancel

Emogene

4 months ago

Changing LastHireDate to date seems like a downgrade.

upvoted 0 times

...

Joseph

4 months ago

Definitely agree on using datetime2 for LastHireDate.

upvoted 0 times

...

Shawn

4 months ago

Surprised they even considered float for PhoneNumber!

upvoted 0 times

...

Silvana

5 months ago

I think PhoneNumber should be bigint, not float.

upvoted 0 times

...

Shelba

5 months ago

Changing Salary to money type makes sense for precision.

upvoted 0 times

...

Audria

5 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

5 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

5 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

5 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

5 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

5 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

5 months ago

Hmm, this one seems tricky. I'll need to think it through carefully.

upvoted 0 times

...

Ciara

5 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

5 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

...