Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Azure Synapse Analytics Interview Questions and Answers
Home
Questions
Azure Synapse Analytics
0
votes
Q: A centrally managed solution that protects networks and all their endpoints against threats with the help of various security tools
answered
Mar 5, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: "Copy Activity" is one of the Data Transformation activities in Azure Data Factory.
answered
Mar 5, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: Which of the following is the default partition option set in Azure Data Flow?
answered
Mar 5, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: Databricks Jar Activity is a valid control flow activity in an Azure Data Factory pipeline.
answered
Mar 5, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
+1
vote
Q: The Debug mode must be enabled to view metadata in the Inspect pane of Azure Data Flow.
answered
Mar 5, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: HDInsight Spark Activity executes ___ programs on existing __ clusters.
answered
Mar 5, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: A Tumbling Window trigger can overlap with consecutive runs.
answered
Mar 5, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: A ___ activity defines a repeating control flow in the Azure Data Factory pipeline.
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure-synapse-analytics
0
votes
Q: In Synapse Analytics, machine learning training can be performed by using which of the following tools?
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: Which of the following data formats are supported in Serverless SQL pool?
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: Azure Data Factory supports which of the following file formats for data movement?
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: A Tumbling Window trigger has a __ relationship with a pipeline.
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: In Dedicated SQL pool, data is stored in __ tables with _ storage.
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: Table partition is supported in Serverless SQL pool.
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: What are the partition types available in Azure Data Flow?
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: Which of the following storage options are supported in Azure Synapse Analytics?
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: Which of the following triggers are present in Synapse Analytics?
answered
Mar 4, 2022
in
Azure Synapse Analytics
by
DavidAnderson
azure_synapse_analytics
0
votes
Q: For lookup tables, __ distribution is recommended.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
lookup-table
azure
0
votes
Q: Which of the following data objects are supported in Dedicated SQL pool?
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
data-object
azue-sql-pool
0
votes
Q: Serverless SQL pool is charged as a pay per ___ model.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
serverless-sql
0
votes
Q: Parquet files have ___ and ___ file formats.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
parquet-files
0
votes
Q: Cross Database queries are not supported in Dedicated SQL pool.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
cross-database
dedicated-sql-pool
0
votes
Q: Procedures are supported on Serverless SQL pool.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
sql-procedure
sql-pool
0
votes
Q: Which of the following query languages are supported in Serverless SQL pool?
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
query-language
serverless-sql-pool
azure
0
votes
Q: By colocating Azure storage account and Serverless SQL pool, the latency will ________.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
azure-storage-account
azure-data
0
votes
Q: The ___ function is used to transform an array to a normalized dataframe.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
transform-function
azure-array
0
votes
Q: Which of the following are Data Flow activities?
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
azure-data
data-flow-activities
0
votes
Q: The ___ function is used to flatten a nested schema to tabular form.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
azure-function
azure-schema
0
votes
Q: Dedicated SQL pool is charged as a pay per ______ model.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
sql-pool
0
votes
Q: Data is stored in a Dedicated SQL pool in _____ tables with ____ storage.
answered
Feb 25, 2022
in
Azure Synapse Analytics
by
sharadyadav1986
sql-pool
azure-data-factory
To see more, click for all the
questions in this category
.
...
