Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
You are tasked with creating a DBSQL warehouse for a financial services company. The company has strict regulatory requirements and needs to ensure that sensitive data is protected. Describe the steps you would take to implement robust data governance and access control mechanisms. Additionally, explain how you would use service principals to enhance security and compliance.
Simulated
A
Create a DBSQL warehouse with strict access controls, use service principals for secure connections, and implement data masking for sensitive data.
B
Create a DBSQL warehouse with relaxed access controls, use user accounts for connections, and avoid data masking.
C
Create a DBSQL warehouse with no access controls, use service principals for connections, and implement data masking.
D
Create a DBSQL warehouse with strict access controls, use user accounts for connections, and avoid data masking.
Explanation:
Creating a DBSQL warehouse with strict access controls ensures that only authorized users and service principals can access the data. Using service principals for connections enhances security by isolating access credentials and improving auditability. Implementing data masking protects sensitive data by obfuscating it, ensuring compliance with regulatory requirements.
Comments
Loading comments...