Microsoft Certified Azure Data Engineer Associate · Free Practice Question Easy
Question 6
Within creating a notebook, you need to specify the pool that needs to be attached to the notebook that is, a SQL or Spark pool. When it comes to the languages, a notebook has to be set with a primary language.
True or False: It is possible to use multiple languages in one notebook.
-
A
False
-
B
True
Reveal correct answer
Correct answer: B
Explanation
Within creating a notebook, you need to specify the pool that needs to be attached to the notebook that is, a SQL or Spark pool. When it comes to the languages, a notebook has to be set with a primary language.
The primary languages available within the notebook environment are:
PySpark (Python)
Spark (Scala)
.NET Spark (C#)
Spark SQL
However, it is possible to use multiple languages in one notebook by specifying the language using a magic command at the beginning of a cell. The following table lists the magic commands to switch cell languages:
It is not possible to reference data or variables directly across different languages in a Synapse Studio notebook. In Spark, it is possible to reference a temporary table across languages.
A.
In Azure Synapse Analytics, it is indeed possible to use multiple languages in one notebook. This capability provides data engineers with the flexibility to choose the most suitable language for each specific task or analysis within the same notebook, enhancing productivity and efficiency in data processing and analytics.
B. True. It is possible to use multiple languages in one notebook within Azure Synapse Analytics. This flexibility allows data engineers to work with different languages such as SQL, Python, Scala, and C# within the same notebook, enabling them to leverage the strengths of each language for different tasks or analyses.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
