Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
mjam0410
Frequent Visitor

Applied Skills: Implement a lakehouse in Microsoft Fabric - Imprecise task/requirement description

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.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

you are supposed to eyeball the column contents and set whatever looks like a number to numeric, and whatever looks like dates to date.

View solution in original post

3 REPLIES 3
v-prasare
Community Support
Community Support

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"

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.