Use cases for XMLA and SQL Endpoints

You can query data in a lakehouse or warehouse using a SQL interface or an XMLA interface. Which one to use depends on your particular requirements and your client tool of choice. In this exercise, you'll identify the distinct characteristics of the SQL endpoint and the XMLA endpoint.