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

Exam DP-203 All Questions

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

Exam DP-203 topic 3 question 30 discussion

Actual exam question from Microsoft's DP-203
Question #: 30
Topic #: 3
[All DP-203 Questions]

HOTSPOT -
You have an Azure subscription that contains an Azure Databricks workspace named databricks1 and an Azure Synapse Analytics workspace named synapse1.
The synapse1 workspace contains an Apache Spark pool named pool1.
You need to share an Apache Hive catalog of pool1 with databricks1.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Azure SQL Database -
Use external Hive Metastore for Synapse Spark Pool
Azure Synapse Analytics allows Apache Spark pools in the same workspace to share a managed HMS (Hive Metastore) compatible metastore as their catalog.
Set up linked service to Hive Metastore
Follow below steps to set up a linked service to the external Hive Metastore in Synapse workspace.
1. Open Synapse Studio, go to Manage > Linked services at left, click New to create a new linked service.
2. Set up Hive Metastore linked service
3. Choose Azure SQL Database or Azure Database for MySQL based on your database type, click Continue.
4. Provide Name of the linked service. Record the name of the linked service, this info will be used to configure Spark shortly.
5. You can either select Azure SQL Database/Azure Database for MySQL for the external Hive Metastore from Azure subscription list, or enter the info manually.
6. Provide User name and Password to set up the connection.
7. Test connection to verify the username and password.
8. Click Create to create the linked service.

Box 2: A Hive Metastore -
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore
by federc at Sept. 7, 2022, 12:55 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
federc
Highly Voted 2 years, 1 month ago
I would say: 1. sql - this is correct 2. managed hive metastore
upvoted 10 times
federc
2 years, 1 month ago
scrath that, given anwers are correct. sql + hive metastore
upvoted 21 times
...
[Removed]
7 months ago
Only Azure SQL Database and Azure Database for MySQL are supported as an external Hive Metastore. And currently we only support User-Password authentication.
upvoted 2 times
...
...
Dusica
Most Recent 5 months, 3 weeks ago
It seems that it is Managed Hive Metastore; se the second green note in here: https://learn.microsoft.com/en-us/azure/hdinsight/share-hive-metastore-with-synapse
upvoted 1 times
...
Alongi
6 months ago
Correct for me
upvoted 1 times
...
matiandal
11 months, 2 weeks ago
b1-sql b2. managed hive metastore Why b2 a managed ? A Hive metastore is a central repository that stores metadata about the data stored in a Hive warehouse. A managed Hive metastore is a type of Hive metastore that is fully managed by Azure Databricks. It provides the following benefits over a self-managed Hive metastore: It is automatically created and configured when you create a Databricks workspace. It is automatically backed up and restored by Databricks. It is automatically scaled and optimized by Databricks. It is compatible with all Databricks features, such as Delta Lake, SQL Analytics, and Unity Catalog. A managed Hive metastore is recommended for most use cases, unless you have specific requirements that need a self-managed Hive metastore, such as: You want to use an external metastore service, such as AWS Glue or Azure SQL Database. You want to share the same metastore across multiple Databricks workspaces or other applications.
upvoted 1 times
matiandal
11 months, 2 weeks ago
b2. hive metastore, not a managed ! ( sorry ) Why b2 have to be " A Hive metastore" and not a managed one
upvoted 1 times
...
...
kkk5566
1 year, 1 month ago
1. sql db 2. hive metastore
upvoted 2 times
...
andjurovicela
1 year, 3 months ago
1 - definitely correct per documentation TestingCRM provided. 2 - I think the devil's in the detail here :/ documentation says "Azure Synapse Analytics allows Apache Spark pools in the same workspace to share a managed HMS (Hive Metastore) compatible metastore as their catalog". The word managed may sway you towards the answer managed hive metasotre SERVICE but the docs don't mention "service" at all, which is why I would go with Hive metastore
upvoted 4 times
...
TestingCRM
1 year, 4 months ago
1. sql - this is correct 2. managed hive metastore See https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore
upvoted 1 times
...
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