What should you do?

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.

View Answer

Answer:

Explanation:

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.

✑ Open Synapse Studio, go to Manage > Linked services at left, click New to create a new linked service.

✑ Set up Hive Metastore linked service

✑ Choose Azure SQL Database or Azure Database for MySQL based on your database type, click Continue.

✑ Provide Name of the linked service. Record the name of the linked service, this info will be used to configure Spark shortly.

✑ 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.

✑ Provide User name and Password to set up the connection.

✑ Test connection to verify the username and password.

✑ Click Create to create the linked service.

Box 2: A Hive Metastore