Exam DP-203 topic 1 question 87 discussion

Provided answers are correct: 1. Yes: Azure Synapse Analytics allows Apache Spark pools in the same workspace to share a managed HMS (Hive Metastore) compatible metastore as their catalog. When customers want to persist the Hive catalog metadata outside of the workspace, and share catalog objects with other computational engines outside of the workspace, such as HDInsight and Azure Databricks, they can connect to an external Hive Metastore. Only Azure SQL Database and Azure Database for MySQL are supported as an external Hive Metastore. 2. Yes: And currently we only support User-Password authentication. 3. No: And currently we only support User-Password authentication. ==> STORAGE BLOB CONTRIBUTOR is an Azure RBAC (Role-Based Access Control) ==> NOT COMPATIBLE (it is supported User-Password authentication ONLY). ref. https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore

No-Yes-Yes

3.No If the underlying data of your Hive tables is stored in the workspace primary storage account, you don't need to do extra settings. It will just work as long as you followed storage setting up instructions during workspace creation. https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore#workspace-primary-storage-account

Yes, Yes , No 1. Yes: Azure Synapse Analytics allows Apache Spark pools in the same workspace to share a managed HMS (Hive Metastore) compatible metastore as their catalog. When customers want to persist the Hive catalog metadata outside of the workspace, and share catalog objects with other computational engines outside of the workspace, such as HDInsight and Azure Databricks, they can connect to an external Hive Metastore. Only Azure SQL Database and Azure Database for MySQL are supported as an external Hive Metastore. 2. Yes: And currently we only support User-Password authentication. 3. No: And currently we only support User-Password authentication. ==> STORAGE BLOB CONTRIBUTOR is an Azure RBAC (Role-Based Access Control) ==> NOT COMPATIBLE (it is supported User-Password authentication ONLY). ref. https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore

I got this question yesterday on my exam

Looks like the Storage Blob Data Contributor role does not need to be assigned. Workspace primary storage account If the underlying data of your Hive tables is stored in the workspace primary storage account, you don't need to do extra settings. It will just work as long as you followed storage setting up instructions during workspace creation. Other ADLS Gen 2 account If the underlying data of your Hive catalogs is stored in another ADLS Gen 2 account, you need to make sure the users who run Spark queries have Storage Blob Data Contributor role on the ADLS Gen2 storage account.

Got this question on my exam on january 17, answers are correct.

Confusing discussion section, no consensus

correct

given answer is correct https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore

Correct order should be Yes, No, Yes

https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore

What are the correct answers???

Only Azure SQL Database and Azure Database for MySQL are supported as an external Hive Metastore. And currently we only support User-Password authentication. https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-external-metastore

A ''Blob Data Contributor" role must be assigned to user in order to access the files in blob storage. So it's a "Yes" https://learn.microsoft.com/en-us/azure/storage/blobs/assign-azure-role-data-access?tabs=portal