A company has a real-time data analysis solution that is hosted on Microsoft Azure. The solution uses Azure Event Hub to ingest data and an Azure StreamAnalytics cloud job to analyze the data. The cloud job is configured to use 120 Streaming Units (SU).You need to optimize performance for the Azure Stream Analytics job.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark database named mytestdb.You run the following command in an Azure Synapse Analytics Spark pool in MyWorkspace.CREATE TABLE mytestdb.myParquetTable(EmployeeID int,EmployeeName string,EmployeeStartDate date)USING Parquet -You then use Spark to insert a row into mytestdb.myParquetTable. The row contains the following data.One minute later, you execute the following query from a serverless SQL pool in MyWorkspace.SELECT EmployeeID -FROM mytestdb.dbo.myParquetTableWHERE EmployeeName = 'Alice';What will be returned by the query?
DRAG DROP -You need to ensure that the Twitter feed data can be analyzed in the dedicated SQL pool. The solution must meet the customer sentiment analytics requirements.Which three Transact-SQL DDL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.Select and Place:
DRAG DROP -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 indexAt 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.Select and Place:
You plan to create an Azure Synapse Analytics dedicated SQL pool.You need to minimize the time it takes to identify queries that return confidential information as defined by the company's data privacy regulations and the users who executed the queues.Which two components should you include in the solution? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?
