ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 13 discussion

Actual exam question from Microsoft's DP-600
Question #: 13
Topic #: 1
[All DP-600 Questions]

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 Hide Answer
Suggested Answer: A 🗳️
by Fermd at Feb. 9, 2024, 12:09 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
conie
Highly Voted 1 year, 1 month 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 58 times
i_have_a_name
9 months, 2 weeks 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
4 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 6 days, 3 hours 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
4 months ago
Selected Answer: A
Read Table3 (A managed table)
upvoted 1 times
...
jass007_k
4 months, 2 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
6 months, 2 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
7 months, 2 weeks 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
7 months, 3 weeks 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
8 months 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
8 months, 1 week 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
9 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
9 months, 3 weeks 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
10 months, 1 week 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
10 months, 2 weeks 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
10 months, 3 weeks 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
11 months, 1 week ago
Selected Answer: A
A is correct. Tested!
upvoted 2 times
...
a_51
12 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
12 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
12 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...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago