Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
One of the tasks in the MS Applied Skills Assessment for lakehouses, includes the following requirement: "In tables that have a prefix of prod_, change the data type of all the numeric and date columns". But it's not specified to what kind of data type these columns shall be converted.
Solved! Go to Solution.
you are supposed to eyeball the column contents and set whatever looks like a number to numeric, and whatever looks like dates to date.
Hi @mjam0410,
Thanks for actively participating in MS Fabric community Support.
We wanted to check in to see if the answer provided by our Super User @lbendlin worked for you?
If you’re still facing any issues or have additional questions, please don’t hesitate to let us know.
We’re here to help and would be happy to assist further if needed.
Looking forward to your feedback!
Thanks,
Prashanth Are
MS Fabric community support.
Did we answer your question? Mark post as a solution, this will help others!
If our response(s) assisted you in any way, don't forget to drop me a "Kudos"
you are supposed to eyeball the column contents and set whatever looks like a number to numeric, and whatever looks like dates to date.
ok, but they already were correctly assigned numeric and date type after I imported them to the lakehouse, and converted them to tables, but I will have a look next time I take the assignment.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
7 | |
4 | |
2 | |
2 | |
1 |
User | Count |
---|---|
13 | |
7 | |
5 | |
5 | |
4 |