Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 13 discussion

Actual exam question from Microsoft's DP-600

Question #: 13
Topic #: 1

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?

A. Read Table3.
B. Update the data Table3.
C. Read Table2.
D. Update the data in Table1.

Show Suggested Answer

Suggested Answer: A 🗳️

by Fermd at Feb. 9, 2024, 12:09 p.m.

Comments

Submit Cancel

conie

Highly Voted 1 year, 6 months ago

Selected Answer: A

B & D is out as you can’t update a table in lakehouse using SQL endpoint as this is read only. You will need to use spark or dataflows. C is out because when you create external table using spark, you can see the table from the lakehouse but you can’t see the table from SQL endpoint let alone ready. A is the answer, as I was able to see and read a managed table using SQL Endpoint

upvoted 61 times

i_have_a_name

1 year, 2 months ago

It seems there is a way to have an external table created using Spark viewed using the Lkehouse SQL End point . This is the spark code I used for testing: df.write.format("delta").option("path","Tables/externalfolder").saveAsTable("testmanagedcsveditors") When I run the catalog query : spark.catalog.listTables(), it is returning as below : Table(name='unmanagedcsveditors', catalog='spark_catalog', namespace=['training_lakehouse'], description=None, tableType='EXTERNAL', isTemporary=False) Now if I go to the SQL end point, I can see a table named "externalfolder" . I agree that the table name should be "umanagedcsveditors", I can infact see 2 tables in the Lakehouse explorer - externalfolder and unmanagedcsveditors

upvoted 2 times

semauni

9 months, 2 weeks ago

Usually if it's this complicated, it's not the answer ;) even if you're right

upvoted 2 times

...

contactodonuno

Most Recent 5 months, 1 week ago

Selected Answer: A

The right answer is A. A managed table, it is stored within the Fabric storage and becomes immediately accessible through the SQL endpoint upon connection.

upvoted 1 times

...

Rakesh16

9 months ago

Selected Answer: A

Read Table3 (A managed table)

upvoted 1 times

...

jass007_k

9 months, 3 weeks ago

Correct option is A) as Lakehouse SQL endpoint is read only B) and D) are incorrect as Lakehouse SQL endpoint is read only Option C) is also incorrect as external tables created using spark in lakehouse are not visible to Lakehouse SQL endpoint Refer this document for option c: https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-visualization

upvoted 1 times

...

cafb698

11 months, 3 weeks ago

The SQL analytics endpoint operates in read-only mode over lakehouse Delta tables. You can only read data from Delta tables using the SQL analytics endpoint. They can save functions, views, and set SQL object-level security. Hence, B & D are out. External Delta tables created with Spark code won't be visible to the SQL analytics endpoint. Use shortcuts in Table space to make external Delta tables visible to the SQL analytics endpoint. Hence C is out. Correct Answer: A

upvoted 1 times

...

Sara0724

1 year ago

Selected Answer: A

The SQL analytics endpoint operates in read-only mode over lakehouse Delta tables. External Delta tables created with Spark code won't be visible to the SQL analytics endpoint. https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint

upvoted 3 times

...

Kang_24

1 year ago

Selected Answer: A

SQL Endpoint cannot update table --> B & D are outed. Table 2 is a external table so it won't be displayed in SQL Endpoint view --> C is outed.

upvoted 2 times

...

Ahmadpbi

1 year, 1 month ago

D is the correct answer. In a lakehouse, the tables that can be edited using SQL endpoints are primarily Delta tables. These tables are specifically designed to be compatible with SQL analytics endpoints, allowing you to perform various SQL operations such as querying, creating views, and applying SQL security. Other table formats like Parquet, CSV, and JSON are not directly editable through SQL endpoints; they need to be converted to Delta format first.

upvoted 1 times

...

b65ecca

1 year, 1 month ago

Selected Answer: A

External Delta tables created with Spark code won't be visible to the SQL analytics endpoint. https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint So C is out. B and D are also out since with a SQL endpoint we can't update tables.

upvoted 2 times

...

Parth_Mehta

1 year, 2 months ago

We can read table 1 and table 3 not table 2 and can't write any of them.... so ans will be A

upvoted 1 times

...

282b85d

1 year, 2 months ago

Managed tables are fully controlled by the database system. These tables typically allow both read and write operations, including updates, through SQL endpoints. After connecting to Lakehouse1 using its SQL endpoint, you will be able to: - **Read Table3** (A) - **Update the data in Table3** (B) So, the correct options are: **A. Read Table3.** **B. Update the data in Table3.**

upvoted 2 times

...

stilferx

1 year, 3 months ago

Selected Answer: A

IMHO, the answer is A. updates are prohibited at all. reading spark external table is a big no-no. Link: https://www.linkedin.com/pulse/use-shortcuts-instead-external-tables-reference-data-fabric-popovic/

upvoted 4 times

...

rmeng

1 year, 3 months ago

Selected Answer: A

C is not correct because the external tables are not accessible from the endpoint. B & D is out of question cause as SQL endpoint is read only.

upvoted 2 times

...

Chrys941

1 year, 3 months ago

Selected Answer: A

D is completely wrong is not typically feasible through a shortcut in SQL endpoint setup. B Generally Supported but depends on the SQL endpoint permissions for such operations A you should be able to read data from table3 since it is a managed table and such operations are standard through Sql Endpoints

upvoted 2 times

...

GPerez73

1 year, 4 months ago

Selected Answer: A

A is correct. Tested!

upvoted 2 times

...

a_51

1 year, 4 months ago

Selected Answer: A

A is correct, D is not. SQL endpoint is read-only. https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint

upvoted 4 times

a_51

1 year, 4 months ago

In that link it tells you as well to modify you have to switch "To modify data in Lakehouse delta tables, you have to switch to lakehouse mode and use Apache Spark."

upvoted 1 times

...

mtroyano

1 year, 4 months ago

Selected Answer: A

Options B and D are incorrect because an endpoint does not support DML operations. Option C is not correct because the external tables are not accessible from the endpoint. The correct answer is A, the managed tables can be read from the connection point.

upvoted 2 times

...

Load full discussion...