Q: 2
You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1.
Lakehouse1 contains the following tables:
• Table1: A Delta table created by using a shortcut
• Table2: An external table created by using Spark
• Table3: A managed table
You plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after
connecting to Lakehouse1?
Options
Discussion
Seriously, every time with these Lakehouse SQL endpoint questions, Microsoft never makes it straightforward. D
Looks like D is right since shortcuts to Delta tables let you update data via SQL endpoint, unlike managed or Spark external tables. Trap is B, which looks tempting but isn't supported for managed tables here.
Does the question mean "update" as in full write/delete access, or just insert/append? If full updates are needed, the answer might change.
Be respectful. No spam.
