BenchMark Quizzes by MDFT Pro

Select All Correct Spark Table Formats

You work for MDFT Pro, a well-known training agency with an Azure Synapse Analytics workspace named TrainingAnalytics. Mark, the Chief Technology Officer, has assigned you to work with an Apache Spark pool named StudentInsights.

You need to create a database called CourseData in the Spark pool to store processed student assessment results and course completion metrics. Mark has a specific requirement: the data science team using Spark notebooks and the reporting team using T-SQL queries both need access to the same tables. He wants you to ensure that when tables are created in the CourseData database, they automatically become available as external tables to the built-in serverless SQL pool without any manual synchronization steps.

Which data formats can you use for the tables in CourseData?

Choose all correct answers from the options below.

Explanations for each answer:

JSON is incorrect. JSON format is not automatically synchronized between Spark pools and serverless SQL pools. CSV, Parquet, and Delta are the formats that enable automatic synchronization.
CSV is correct. CSV format is automatically synchronized between Spark pools and serverless SQL pools. Tables created in Spark pools using CSV are automatically available as external tables in the serverless SQL pool.
Parquet is correct. Parquet is also a correct format. Tables created in Spark pools using Parquet are automatically available as external tables in the serverless SQL pool.
Delta is correct. Delta format is also supported and automatically synchronized between Spark pools and serverless SQL pools. Delta provides ACID properties and is commonly used for Spark workloads.
ORC is incorrect. ORC format is not automatically synchronized between Spark pools and serverless SQL pools. CSV, Parquet, and Delta are the formats that enable this feature.

Learn more about Shared Metadata Tables In Azure Synapse Analytics:

Shared Metadata Tables

Practice Exam

Select All Correct Spark Table Formats

Discuss this question on social media: