What function should be used in a serverless SQL pool to query an analytical store in Azure Cosmos DB?

The function that should be used in a serverless SQL pool to query an analytical store in Azure Cosmos DB is OPENROWSET. This function allows you to access data directly from external sources, such as Azure Cosmos DB's analytical store, without needing to create a permanent table in your SQL database.

When using OPENROWSET, you can specify the format of the data and query the necessary information directly from the analytical store, making it fit seamlessly into serverless architectures. It particularly caters to scenarios where you want on-the-fly querying, which aligns perfectly with serverless SQL pools, as they are designed to handle such transient data access without pre-provisioned resources.

Utilizing OPENROWSET enables you to interoperate with a variety of external data sources within Azure, enhancing your ability to perform analytical queries over diverse datasets while leveraging the scalability of the cloud.