Question 76

You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table1.
You need to identify the extent of the data skew in Table1.
What should you do in Synapse Studio?
  • Question 77

    You plan to ingest streaming social media data by using Azure Stream Analytics. The data will be stored in files in Azure Data Lake Storage, and then consumed by using Azure Datiabricks and PolyBase in Azure Synapse Analytics.
    You need to recommend a Stream Analytics data output format to ensure that the queries from Databricks and PolyBase against the files encounter the fewest possible errors. The solution must ensure that the tiles can be queried quickly and that the data type information is retained.
    What should you recommend?
  • Question 78

    You are monitoring an Azure Stream Analytics job by using metrics in Azure.
    You discover that during the last 12 hours, the average watermark delay is consistently greater than the configured late arrival tolerance.
    What is a possible cause of this behavior?