exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 145 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 145
Topic #: 1
[All Certified Data Engineer Associate Questions]

Which two conditions are applicable for governance in Databricks Unity Catalog? (Choose two.)

  • A. You can have more than 1 metastore within a databricks account console but only 1 per region.
  • B. Both catalog and schema must have a managed location in Unity Catalog provided metastore is not associated with a location
  • C. You can have multiple catalogs within metastore and 1 catalog can be associated with multiple metastore
  • D. If catalog is not associated with location, it’s mandatory to associate schema with managed locations
  • E. If metastore is not associated with location, it’s mandatory to associate catalog with managed locations
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️

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
CaoMengde09
1 month, 1 week ago
Selected Answer: AE
Databricks recommends that you assign managed storage at the catalog level for logical data isolation, with metastore-level and schema-level as options. New workspaces that are enabled for Unity Catalog automatically are created without a metastore-level managed storage location. It means that it's a must to create a managed location for a catalog for otpimal data isolations, otherwise you'll finish up with many schemas/tables data in the same managed location which is a bad prctice from governance perspective. Working with not isolated catalog in Unity Catalog is chaotic, i would prefer to be on my workspace rather than working in such bad governed Unity Catalog. Ans : ["A", "E"]
upvoted 1 times
...
grygi
1 month, 2 weeks ago
Selected Answer: AD
Had this on the exam. AD was correct, I maxed this area.
upvoted 3 times
...
MultiCloudIronMan
1 month, 3 weeks ago
Selected Answer: AE
The correct answers are A. You can have more than 1 metastore within a Databricks account console but only 1 per region and E. If metastore is not associated with location, it’s mandatory to associate catalog with managed locations. These conditions are applicable for governance in Databricks Unity Catalog
upvoted 2 times
...
sakis213
2 months, 1 week ago
Selected Answer: AD
D. If catalog is not associated with location, it’s mandatory to associate schema with managed locations
upvoted 1 times
...
806e7d2
2 months, 2 weeks ago
Selected Answer: AE
A. You can have more than 1 metastore within a Databricks account console but only 1 per region. Unity Catalog allows multiple metastores within a Databricks account console. However, each region can only have one active metastore due to geographic restrictions and for managing data governance in a region-specific manner. E. If metastore is not associated with location, it’s mandatory to associate catalog with managed locations. When a metastore does not have a default storage location, you must configure managed locations for each catalog to ensure governance and compliance. Managed locations define where Unity Catalog manages and stores data.
upvoted 2 times
sakis213
2 months, 1 week ago
Metastore must hv a managed location defined. AD is correct
upvoted 1 times
...
...
comoon
3 months, 1 week ago
Correct - A and D. A.Unity Catalog allows you to have multiple metastores within a single Databricks account, but each metastore is limited to a single region for data locality and compliance purposes. D. When a catalog does not have an associated managed location, it becomes necessary to associate schemas within the catalog with managed locations, ensuring that data is stored in a defined path.
upvoted 2 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago