ADE Q06: Cosmos DB, Azure Synapse Analytics and Stream Analytics Quiz

1. Which index type should be used for increasing the performance of queries that use multiple fields?

• A. Range Index
• B. Spatial Index
• C. Composite Index
• D. None of the above

2. Which of the following is true for an Azure Stream Analytics Job in a “Degraded” state:

• A. The job is not processing any incoming events
• B. The job is processing events but not in an optimal way
• C. The job has encountered an error and failed
• D. None of the above

3. Which of the following is not a valid optimization technique for Azure Stream Analytics?

• A. Stream Analytics should be used with partitioned tables and indexes
• B. In-memory tables should be used whenever possible
• C. When using Stream Analytics with a table that has clustered columnstore Index, the batch size should be set at 100,000 records
• D. Decreasing the number of input events per partition increases the write throughput

4. The following is a list of steps to run an Azure Function from Azure Stream Analytics:

a. Create an Azure function

b. Create an Azure Cache for Redis cache

c. Create Azure Stream Analytics Job

d. Update Stream Analytics job with Azure Function as Output

What is the correct order of steps to be performed to run an Azure Function from Azure Stream Analytics?

• A. abcd
• B. adbc
• C. cbad
• D. dcba

5. What is the primary use case and advantage of serverless SQL pool in Azure Synapse Analytics?

• A. Quick data discovery and exploration
• B. Advanced data transformations
• C. Both 1 & 2
• D. None of the above