Question 96

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 97

    You need to collect application metrics, streaming query events, and application log messages for an Azure Databrick cluster.
    Which type of library and workspace should you implement? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 98

    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 99

    You have a table named SalesFact in an enterprise data warehouse in Azure Synapse Analytics. SalesFact contains sales data from the past 36 months and has the following characteristics:
    Is partitioned by month
    Contains one billion rows
    Has clustered columnstore indexes
    At the beginning of each month, you need to remove data from SalesFact that is older than 36 months as quickly as possible.
    Which three actions should you perform in sequence in a stored procedure? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    Question 100

    You plan to monitor an Azure data factory by using the Monitor & Manage app.
    You need to identify the status and duration of activities that reference a table in a source database.
    Which three actions should you perform in sequence? To answer, move the actions from the list of actions to the answer are and arrange them in the correct order.