InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Procedures are supported in Serverless SQL pool. |
|
Answer» Procedures are supported in SERVERLESS SQL pool. |
|
| 2. |
What are the partition types available in Azure Data Flow? |
|
Answer» What are the PARTITION types available in Azure Data Flow? |
|
| 3. |
Which of the following storage options are supported in Azure Synapse Analytics? |
|
Answer» Which of the following storage options are supported in Azure Synapse Analytics? |
|
| 4. |
Table partition is supported in Serverless SQL pool. |
|
Answer» Table partition is SUPPORTED in Serverless SQL pool. |
|
| 5. |
Which of the following triggers are present in Synapse Analytics? |
|
Answer» Which of the following triggers are PRESENT in Synapse ANALYTICS? |
|
| 6. |
To deploy ML models from an Azure ML model registry, which of the following format should be used? |
|
Answer» To deploy ML models from an Azure ML model registry, which of the following format should be USED? |
|
| 7. |
In Dedicated SQL pool, data is stored in __ tables with _ storage. |
|
Answer» In DEDICATED SQL pool, DATA is STORED in __ tables with _ storage. |
|
| 8. |
A ___ activity defines a repeating control flow in the Azure Data Factory pipeline. |
|
Answer» A ___ ACTIVITY defines a REPEATING CONTROL FLOW in the Azure Data Factory pipeline. |
|
| 9. |
Procedures are supported on Serverless SQL pool. |
|
Answer» PROCEDURES are SUPPORTED on Serverless SQL pool. Choose the CORRECT option from below LIST (1)FALSE (2)True Answer:-(2)True |
|
| 10. |
A Tumbling Window trigger can overlap with consecutive runs. |
|
Answer» A TUMBLING Window TRIGGER can overlap with consecutive runs. |
|
| 11. |
Dedicated SQL pool is charged as a pay per ______ model. |
|
Answer» Dedicated SQL pool is charged as a pay per ______ MODEL. Choose the correct option from below list (1)TB (2)All the above OPTIONS. (3)DWU (4)Hour Answer:-(3)DWU |
|
| 12. |
Azure Data Factory supports which of the following file formats for data movement? |
|
Answer» Azure Data Factory supports which of the FOLLOWING file formats for data movement? |
|
| 13. |
A Tumbling Window trigger has a __ relationship with a pipeline. |
|
Answer» A Tumbling Window trigger has a __ relationship with a pipeline. |
|
| 14. |
In Synapse Analytics, machine learning training can be performed by using which of the following tools? |
|
Answer» In Synapse Analytics, machine learning training can be performed by using which of the following TOOLS? |
|
| 15. |
Which of the following data formats are supported in Serverless SQL pool? |
|
Answer» Which of the following data formats are SUPPORTED in Serverless SQL pool? |
|
| 16. |
HDInsight Spark Activity executes ___ programs on existing __ clusters. |
|
Answer» HDInsight Spark Activity EXECUTES ___ PROGRAMS on EXISTING __ clusters. |
|
| 17. |
The Debug mode must be enabled to view metadata in the Inspect pane of Azure Data Flow. |
|
Answer» The DEBUG mode must be enabled to view METADATA in the Inspect PANE of Azure DATA Flow. |
|
| 18. |
Databricks Jar Activity is a valid control flow activity in an Azure Data Factory pipeline. |
|
Answer» Databricks Jar Activity is a VALID CONTROL flow activity in an AZURE DATA Factory pipeline. |
|
| 19. |
Which of the following data objects are supported in Dedicated SQL pool? |
|
Answer» Which of the following data objects are supported in Dedicated SQL pool? |
|
| 20. |
Which of the following is the default partition option set in Azure Data Flow? |
|
Answer» Which of the following is the DEFAULT PARTITION option set in Azure Data FLOW? |
|
| 21. |
For lookup tables, __ distribution is recommended. |
|
Answer» For lookup tables, __ distribution is recommended. |
|
| 22. |
Data Flow uses which of the following? |
|
Answer» Data Flow USES which of the following? |
|
| 23. |
By colocating Azure storage account and Serverless SQL pool, the latency will ________. |
|
Answer» By colocating Azure storage ACCOUNT and Serverless SQL pool, the LATENCY will ________. |
|
| 24. |
The ___ function is used to transform an array to a normalized dataframe. |
|
Answer» The ___ function is used to transform an array to a normalized dataframe. Choose the correct option from below LIST (1)explode (2)flatten_df (3)FLATTEN (4)falt_df ANSWER:-(1)explode |
|
| 25. |
Which of the following are Data Flow activities? |
|
Answer» Which of the following are Data Flow activities? Choose the correct OPTION from below list (1)All the above options (2)Control (3)Data transformation (4)Data movement Answer:-(1)All the above options. |
|
| 26. |
The ___ function is used to flatten a nested schema to tabular form. |
|
Answer» The ___ FUNCTION is used to flatten a nested schema to tabular FORM. Choose the CORRECT option from below list (1)flatten (2)flatten_df (3)falt_df (4)EXPLODE Answer:-(2)flatten_df |
|
| 27. |
Under which table in Azure Data Flow can we validate source schema? |
|
Answer» Under which table in Azure Data Flow can we validate source SCHEMA? Choose the correct option from below list (1)Inspect (2)Source/Transformation Settings (3)NONE of the OPTIONS. (4)OPTIMIZE Answer:-(2)Source/Transformation Settings |
|
| 28. |
"Copy Activity" is one of the Data Transformation activities in Azure Data Factory. |
|
Answer» "COPY ACTIVITY" is one of the DATA Transformation activities in AZURE Data Factory. Choose the CORRECT option from below list (1)True (2)False Answer:-(2)False |
|
| 29. |
Data is stored in a Dedicated SQL pool in _____ tables with ____ storage. |
|
Answer» Data is stored in a Dedicated SQL POOL in _____ tables with ____ storage. Choose the correct option from below list (1)Non-RELATIONAL, Key-value (2)Relational, Columnar (3)Non-relational, Columnar (4)Relational, Row Answer:-(2)Relational, Columnar |
|
| 30. |
Copy Activity in Data Factory can be used for which of the following? |
|
Answer» Copy Activity in Data Factory can be used for which of the following? Choose the correct option from below list (1)To publish transformation and analysis results for BUSINESS INTELLIGENCE. (2)All the above options. (3)To copy data from a source data store to a sink data store. Answer:-(2)All the above options. |
|
| 31. |
Which of the following Sink data stores are supported in Azure Data Factory? |
|
Answer» Which of the following Sink data stores are supported in Azure Data Factory? CHOOSE the CORRECT OPTION from below list (1)All the above options. (2)Blob (3)Cognitive Search Index (4)Cosmos DB ANSWER:-(1)All the above options. |
|
| 32. |
Which tab in Azure Data Flow represents data partitioning? |
|
Answer» Which tab in Azure DATA Flow represents data PARTITIONING? Choose the correct option from below list (1)None of the OPTIONS. (2)Inspect (3)Source/Transformation Settings (4)OPTIMIZE Answer:-(4)Optimize |
|
| 33. |
Which of the following Source data stores are supported in Azure Data Factory? |
|
Answer» Which of the following SOURCE data stores are supported in AZURE Data FACTORY? Choose the correct option from below list (1)All the above options. (2)RedShift (3)Cosmos DB (4)BLOB Answer:-(1)All the above options. |
|
| 34. |
Wait Activity is a valid control flow activity in an Azure Data Factory pipeline. |
|
Answer» Wait ACTIVITY is a valid control flow activity in an AZURE Data Factory PIPELINE. Choose the correct option from below list (1)TRUE (2)False Answer:-(1)True |
|
| 35. |
Under which table in Azure Data Flow can source schema be validated? |
|
Answer» Under which table in Azure Data Flow can SOURCE schema be validated? Choose the correct option from below LIST (1)NONE of the options. (2)Inspect (3)Source/Transformation Settings (4)OPTIMIZE Answer:-(3)Source/Transformation Settings |
|