McAfee-Secured Website

Exam Bundle

Exam Code: SnowPro Core COF-C03

Exam Name SnowPro Core COF-C03

Certification Provider: Snowflake

Snowflake SnowPro Core COF-C03 Bundle $19.99

100% Snowflake SnowPro Core COF-C03 Guaranteed Success With Testking Training Materials

Get Real SnowPro Core COF-C03 Exam Questions & Expert Verified Answers as Experienced on the Real Exam!

  • Questions & Answers

    SnowPro Core COF-C03 Questions & Answers

    116 Questions & Answers

    The ultimate exam preparation tool, Questions & Answers mirrors the actual SnowPro Core COF-C03 exam while allowing you to hone and measure every aspect of your test-taking ability.

  • Study Guide

    SnowPro Core COF-C03 Study Guide

    222 PDF Pages

    Developed by industry experts, this 222-page guide spells out in painstaking detail all of the information you need to ace SnowPro Core COF-C03 exam.

SnowPro Core COF-C03 Practice Tests

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Total Cost: $154.98
Bundle Price: $134.99

Purchase Individually

  • Questions & Answers

    Questions & Answers

    116 Questions

    $124.99
  • Study Guide

    Study Guide

    222 PDF Pages

    $29.99

Snowflake SnowPro Core COF-C03 Practice Test 32

Question 310

An account-level business role can see only rows for its assigned branch. Which policy fits?

  1. Masking policy
  2. Aggregation policy
  3. Join policy
  4. Row access policy

Explanation

Correct Answer

D:

Correct: row visibility filtering. Row access policy filters visible rows according to a policy expression.

Incorrect Answers

A:

Incorrect for this requirement: Masking policy limits exposed values of protected columns conditionally; the problem instead calls for row visibility filtering.

B:

Incorrect for this requirement: Aggregation policy can require protected data to be queried in qualifying aggregate groups; the problem instead calls for row visibility filtering.

C:

Incorrect for this requirement: Join policy can limit which columns are permitted for joins on protected tables; the problem instead calls for row visibility filtering.

Question 311

A dataset provider wants to prevent revealing details about tiny groups while permitting aggregate analysis. Which policy type applies?

  1. Aggregation policy
  2. Masking policy
  3. Row access policy
  4. Join policy

Explanation

Correct Answer

A:

Correct: aggregation constraints. Aggregation policy can require protected data to be queried in qualifying aggregate groups.

Incorrect Answers

B:

Incorrect for this requirement: Masking policy limits exposed values of protected columns conditionally; the problem instead calls for aggregation constraints.

C:

Incorrect for this requirement: Row access policy filters visible rows according to a policy expression; the problem instead calls for aggregation constraints.

D:

Incorrect for this requirement: Join policy can limit which columns are permitted for joins on protected tables; the problem instead calls for aggregation constraints.

Question 312

A collaboration provider must restrict which key columns consumers can use to join to other datasets. Which policy type fits?

  1. Masking policy
  2. Row access policy
  3. Aggregation policy
  4. Join policy

Explanation

Correct Answer

D:

Correct: join-key restrictions. Join policy can limit which columns are permitted for joins on protected tables.

Incorrect Answers

A:

Incorrect for this requirement: Masking policy limits exposed values of protected columns conditionally; the problem instead calls for join-key restrictions.

B:

Incorrect for this requirement: Row access policy filters visible rows according to a policy expression; the problem instead calls for join-key restrictions.

C:

Incorrect for this requirement: Aggregation policy can require protected data to be queried in qualifying aggregate groups; the problem instead calls for join-key restrictions.

Question 313

A single SSN field should never appear in clear text to business users without a designated privilege. What policy fits?

  1. Row access policy
  2. Aggregation policy
  3. Join policy
  4. Masking policy

Explanation

Correct Answer

D:

Correct: masking the column value. Masking policy limits exposed values of protected columns conditionally.

Incorrect Answers

A:

Incorrect for this requirement: Row access policy filters visible rows according to a policy expression; the problem instead calls for masking the column value.

B:

Incorrect for this requirement: Aggregation policy can require protected data to be queried in qualifying aggregate groups; the problem instead calls for masking the column value.

C:

Incorrect for this requirement: Join policy can limit which columns are permitted for joins on protected tables; the problem instead calls for masking the column value.

Question 314

A customer support region should see only customer records from its own geography. Which policy type applies?

  1. Masking policy
  2. Row access policy
  3. Aggregation policy
  4. Join policy

Explanation

Correct Answer

B:

Correct: row-based security. Row access policy filters visible rows according to a policy expression.

Incorrect Answers

A:

Incorrect for this requirement: Masking policy limits exposed values of protected columns conditionally; the problem instead calls for row-based security.

C:

Incorrect for this requirement: Aggregation policy can require protected data to be queried in qualifying aggregate groups; the problem instead calls for row-based security.

D:

Incorrect for this requirement: Join policy can limit which columns are permitted for joins on protected tables; the problem instead calls for row-based security.

Question 315

A protected population dataset should be consumed only through aggregates meeting minimum-group criteria. Which policy fits?

  1. Aggregation policy
  2. Masking policy
  3. Row access policy
  4. Join policy

Explanation

Correct Answer

A:

Correct: aggregation policy. Aggregation policy can require protected data to be queried in qualifying aggregate groups.

Incorrect Answers

B:

Incorrect for this requirement: Masking policy limits exposed values of protected columns conditionally; the problem instead calls for aggregation policy.

C:

Incorrect for this requirement: Row access policy filters visible rows according to a policy expression; the problem instead calls for aggregation policy.

D:

Incorrect for this requirement: Join policy can limit which columns are permitted for joins on protected tables; the problem instead calls for aggregation policy.

Question 316

An analyst always starts with an inappropriate primary role after signing in. Which user property should be reviewed?

  1. DEFAULT_WAREHOUSE
  2. DEFAULT_NAMESPACE
  3. DEFAULT_ROLE
  4. DISABLED user property

Explanation

Correct Answer

C:

Correct: initial role selection. DEFAULT_ROLE sets a user's default primary role on login when applicable.

Incorrect Answers

A:

Incorrect: DEFAULT_WAREHOUSE sets a user's preferred initial compute warehouse; this case calls for initial role selection.

B:

Incorrect: DEFAULT_NAMESPACE selects the initial database and schema context; this case calls for initial role selection.

D:

Incorrect: DISABLED user property blocks the specified user from logging in when the account is disabled; this case calls for initial role selection.

Question 317

A BI user can run reports but must select the warehouse manually at every login. What user property helps?

  1. DEFAULT_WAREHOUSE
  2. DEFAULT_ROLE
  3. DEFAULT_NAMESPACE
  4. DISABLED user property

Explanation

Correct Answer

A:

Correct: default query compute. DEFAULT_WAREHOUSE sets a user's preferred initial compute warehouse.

Incorrect Answers

B:

Incorrect: DEFAULT_ROLE sets a user's default primary role on login when applicable; this case calls for default query compute.

C:

Incorrect: DEFAULT_NAMESPACE selects the initial database and schema context; this case calls for default query compute.

D:

Incorrect: DISABLED user property blocks the specified user from logging in when the account is disabled; this case calls for default query compute.

Question 318

A SQL client resolves unqualified object names against the wrong database/schema after login. Which property sets the starting context?

  1. DEFAULT_NAMESPACE
  2. DEFAULT_ROLE
  3. DEFAULT_WAREHOUSE
  4. DISABLED user property

Explanation

Correct Answer

A:

Correct: initial namespace selection. DEFAULT_NAMESPACE selects the initial database and schema context.

Incorrect Answers

B:

Incorrect: DEFAULT_ROLE sets a user's default primary role on login when applicable; this case calls for initial namespace selection.

C:

Incorrect: DEFAULT_WAREHOUSE sets a user's preferred initial compute warehouse; this case calls for initial namespace selection.

D:

Incorrect: DISABLED user property blocks the specified user from logging in when the account is disabled; this case calls for initial namespace selection.

Question 319

A departed employee's user object should remain for audit but must no longer be able to authenticate. What account setting fits?

  1. DISABLED user property
  2. DEFAULT_ROLE
  3. DEFAULT_WAREHOUSE
  4. DEFAULT_NAMESPACE

Explanation

Correct Answer

A:

Correct: disabling the user. DISABLED user property blocks the specified user from logging in when the account is disabled.

Incorrect Answers

B:

Incorrect: DEFAULT_ROLE sets a user's default primary role on login when applicable; this case calls for disabling the user.

C:

Incorrect: DEFAULT_WAREHOUSE sets a user's preferred initial compute warehouse; this case calls for disabling the user.

D:

Incorrect: DEFAULT_NAMESPACE selects the initial database and schema context; this case calls for disabling the user.

Question 320

A service user needs least-privilege READ_ONLY selected automatically at session start. What default property addresses this?

  1. DEFAULT_WAREHOUSE
  2. DEFAULT_NAMESPACE
  3. DISABLED user property
  4. DEFAULT_ROLE

Explanation

Correct Answer

D:

Correct: session primary role. DEFAULT_ROLE sets a user's default primary role on login when applicable.

Incorrect Answers

A:

Incorrect: DEFAULT_WAREHOUSE sets a user's preferred initial compute warehouse; this case calls for session primary role.

B:

Incorrect: DEFAULT_NAMESPACE selects the initial database and schema context; this case calls for session primary role.

C:

Incorrect: DISABLED user property blocks the specified user from logging in when the account is disabled; this case calls for session primary role.