Snowflake Certification Practice Test 06
Practice Test 06
Snowflake Certification Practice Test 06
Practice Test 06
Insightful Saga — Modern Data Engineering Certification Preparation
Question 81
## Question 81 A newly joined Data Engineer at a global banking company is assigned to a project containing customer account information. The compliance team has identified that account numbers, PAN numbers and national identifiers should only be visible to authorized users. Business analysts should still be able to query the table but must not see the actual sensitive values. What should the engineer recommend?
Dynamic Data Masking hides sensitive information based on user roles while allowing access to non-sensitive data. ---
Question 82
## Question 82 A healthcare company stores patient records in Snowflake. Doctors should only see patients assigned to their hospital. The same table contains records for all hospitals across the country. Which Snowflake capability best addresses this requirement?
Row Access Policies restrict which rows users can view based on access rules. ---
Question 83
## Question 83 A newly hired Snowflake Administrator discovers that users are receiving direct object permissions individually. Managing permissions has become extremely difficult as the company grows. What is the BEST long-term recommendation?
Question 84
## Question 84 A pharmaceutical company is preparing for an external regulatory audit. Auditors request evidence showing: - Who accessed datasets - When access occurred - Which objects were modified What should the engineering team review first?
Question 85
## Question 85 A company needs to classify datasets as: - Public - Internal - Confidential - Restricted The governance team wants these classifications attached directly to data assets. Which Snowflake capability should be evaluated?
Tags allow metadata classification and governance labeling of Snowflake objects. ---
Question 86
## Question 86 A retail company wants any dataset tagged as "Confidential" to automatically trigger stricter governance processes. What should be implemented?
Question 87
## Question 87 A newly joined Architect notices that marketing users have access to payroll tables. Management considers this a major security risk. Which access principle should be enforced?
Question 88
## Question 88 A company acquires another business and must securely share selected datasets with the acquired organization. The acquired company should access data without creating duplicate copies. Which Snowflake feature is most suitable?
Secure Data Sharing allows consumers to access data without physically copying it. ---
Question 89
## Question 89 A global insurance company wants external business partners to access shared Snowflake datasets. The partners do not own Snowflake accounts. Which capability should the Snowflake Architect evaluate?
Question 90
## Question 90 A banking company stores Personally Identifiable Information (PII). Executives want a governance framework ensuring sensitive information is properly identified and protected. What should be implemented FIRST?
Question 91
## Question 91 A newly joined Data Engineer wants to understand which downstream reports depend on a specific customer table before making structural changes. Which governance capability would be most valuable?
Question 92
## Question 92 A telecommunications company maintains thousands of Snowflake objects. Business users struggle to understand dataset purpose and ownership. What should be improved?
Question 93
## Question 93 A compliance officer requests proof that customer data is retained according to legal requirements. Which area should the data team review?
Question 94
## Question 94 A healthcare organization wants to prevent accidental exposure of sensitive patient information through analytical queries. What should be implemented?
Question 95
## Question 95 A company has hundreds of developers across multiple countries. Security teams want a standardized approach to granting object permissions. Which design is recommended?
Question 96
## Question 96 A newly hired Snowflake Engineer is told: "Any change to production datasets must be traceable." Which governance objective is being emphasized?
Question 97
## Question 97 A financial institution must restrict access to credit-card information while still allowing aggregate reporting. What capability most directly supports this requirement?
Question 98
## Question 98 A company wants all governance rules, classifications and ownership details applied consistently across departments. Which organizational approach is most beneficial?
Question 99
## Question 99 A newly joined Data Architect wants to ensure that every critical dataset has: - An owner - Documentation - Classification - Access policy Which concept is being implemented?
Question 100
## Question 100 A global enterprise is building a Snowflake platform expected to support thousands of users, hundreds of applications and regulatory audits across multiple countries. Management wants the platform to remain secure, auditable and compliant as adoption grows. Which architectural principle should guide the implementation?
Governance by Design ensures security, compliance, ownership, auditing and access controls are embedded into the platform from the beginning rather than added later. --- --- title: Snowflake Certification Practice Test 07 description: Design Review and ETL Architecture Scenarios ---