Exam Preparation Quiz

Explanations for each answer:

• Create a shortcut in the Files section is incorrect. The Files section is not suitable for SQL endpoint queries because it's designed for managing raw files and folders. To efficiently query data through the SQL endpoint, shortcuts must be created in the Tables section to ensure proper integration with the SQL query engine.
• Create a shortcut in the Tables section is correct.
• Use the Parquet format is correct.
• Use the CSV format is incorrect. CSV format is not optimal for SQL endpoint queries because it lacks the performance optimizations needed for analytical workloads. The SQL endpoint works best with Parquet format, which provides better compression, columnar storage, and query performance.
• Use the JSON format is incorrect. JSON format is not suitable for SQL endpoint queries because it's designed for semi-structured data and lacks the optimizations needed for analytical workloads. The SQL endpoint works best with Parquet format for optimal query performance and data organization.