Misleading text in training

Question

Theres a confusion in the check knowledge question considering the traing text says :

Your model wont work if you try to build a relationship between two columns, where one column has a text data type and another column has an integer data type.

Answer 1

Hi Fola Animashaun,

Thanks for reaching out to us on Microsoft Q&A forum.

The article referenced says they should be the same data type but does not say they must be the same. It goes on to explain the implications if the data types are different. The knowledge check being challenged is asking what is true, not what is suggested.

While it recommends matching data types for consistency and accuracy, it acknowledges that different data types can be used but may lead to unexpected behavior or errors. Understanding the potential consequences of using different data types is key to making informed decisions in data management.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you.