Exam DP-600 topic 1 question 36 discussion

Answer is DE. To be able to use the SQL Endpoint you need to create the shortcut in the Tables section. The file also needs to be in the delta format to be recognised as a managed table. If you try to add a parquet file to the tables section, it will not be recognised as a table object and you won't be able to query it.

B,D are the correct answers, since the Parquet file format within S3, and the pointing to it via a lakehouse Table shortcut, allows the shorcut to be recognized by Fabric as a Delta table and hence provide access to the SQL endpoint. Explanation: As per the provided links: "If the target of the shortcut contains data in the Delta\Parquet format, the lakehouse automatically synchronizes the metadata and recognizes the folder as a table". It is stated that S3 contains sales data files, that is files not tables. Besides, delta tables are not supported in S3. So the file format needs to be either CSV or Parquet, leading us to choose the latter for all the reasons stated in other comments. So creating a shortcut in Table section that points to S3 Parquet files, will allow Fabric to recognise it as a Delta table, which in turn enables the SQL endpoint.

S3 does not support delta format but supports parquet + shortcut in tables section can enable sql endpoint access . Csv files cannot be queried by sql endpoint if I am not mistaken and data in file section is not available for sql endpoint query.

This is another bad question. only delta format file can build tables and query by SQL endpoint. Other file formats, such as parquet and csv will put to unidentified folder and missing from SQL endpoint. However, why we keep delta type files inside S3?

SQL Endpoint you need to create the shortcut in the Tables section.

B.use parquet format D.create a shortcut in the table section

D. Create a shortcut in the Tables section. E. Use the delta format

B OR E (Use the Parquet format or Use the delta format) D Create a shortcut in the Tables section

B & D is the answer

Delta uis supported: https://blog.fabric.microsoft.com/en-us/blog/public-preview-of-onelake-shortcuts-to-s3-compatible-data-sources?ft=All ""If your data is already in the Delta Lake format, create your shortcut in the Tables section of your lakehouse. This will allow your table shortcut to benefit from metadata synchronization across Fabric engines, letting you use this structured data where tables are used in Fabric.""

chat GBT also agree with BD

CSV is best if the data is not that large

There is no mention of how big the data is , using CSV will be better if the data is small

ChatGPT is saying amazon S3 supports both Delta and Parquet files

B- Because Parquet format is supported in Amazon S3 https://learn.microsoft.com/en-us/azure/data-factory/format-parquet D- Because you need to use the Shortcuts as managed portion of the lakehouse.

I guess MS documentation says Delta rather than Parquet? https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint

D and E. Tested. You can turn delta files available in your AWS Service and create a shortcut here.