You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1.You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs.What should you do first?
HOTSPOT -You are building an Azure Stream Analytics job that queries reference data from a product catalog file. The file is updated daily.The reference data input details for the file are shown in the Input exhibit. (Click the Input tab.)The storage account container view is shown in the Refdata exhibit. (Click the Refdata tab.)You need to configure the Stream Analytics job to pick up the new reference data.What should you configure? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
HOTSPOT -You have the following Azure Stream Analytics query.For each of the following statements, select Yes if the statement is true. Otherwise, select No.NOTE: Each correct selection is worth one point.Hot Area:
HOTSPOT -You are building a database in an Azure Synapse Analytics serverless SQL pool.You have data stored in Parquet files in an Azure Data Lake Storege Gen2 container.Records are structured as shown in the following sample.{"id": 123,"address_housenumber": "19c","address_line": "Memory Lane","applicant1_name": "Jane","applicant2_name": "Dev"}The records contain two applicants at most.You need to build a table that includes only the address fields.How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
HOTSPOT -You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1.You plan to access the files in Account1 by using an external table.You need to create a data source in Pool1 that you can reference when you create the external table.How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement.You need to alter the table to meet the following requirements:✑ Ensure that users can identify the current manager of employees.✑ Support creating an employee reporting hierarchy for your entire company.✑ Provide fast lookup of the managers' attributes such as name and job title.Which column should you add to the table?
