Question 51

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 52

    You are planning a solution to aggregate streaming data that originates in Apache Kafka and is output to Azure Data Lake Storage Gen2. The developers who will implement the stream processing solution use Java, Which service should you recommend using to process the streaming data?
  • Question 53

    You have a Microsoft SQL Server database that uses a third normal form schema.
    You plan to migrate the data in the database to a star schema in an A?\ire Synapse Analytics dedicated SQI pool.
    You need to design the dimension tables. The solution must optimize read operations.
    What should you include in the solution? to answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 54

    You have two fact tables named Flight and Weather. Queries targeting the tables will be based on the join between the following columns.

    You need to recommend a solution that maximum query performance.
    What should you include in the recommendation?
  • Question 55

    You need to implement an Azure Synapse Analytics database object for storing the sales transactions dat a. The solution must meet the sales transaction dataset requirements.
    What solution must meet the sales transaction dataset requirements.
    What should you do? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.