McAfee-Secured Website

Exam Bundle

Exam Code: Certified Data Engineer Associate

Exam Name Certified Data Engineer Associate

Certification Provider: Databricks

Corresponding Certification: Databricks Certified Data Engineer Associate

Databricks Certified Data Engineer Associate Bundle $44.99

100% Databricks Certified Data Engineer Associate Guaranteed Success With Testking Training Materials

Get Real Certified Data Engineer Associate Exam Questions & Expert Verified Answers as Experienced on the Real Exam!

  • Questions & Answers

    Certified Data Engineer Associate Questions & Answers

    280 Questions & Answers

    The ultimate exam preparation tool, Questions & Answers mirrors the actual Certified Data Engineer Associate exam while allowing you to hone and measure every aspect of your test-taking ability.

  • Certified Data Engineer Associate Video Course

    Certified Data Engineer Associate Video Course

    38 Video Lectures

    Certified Data Engineer Associate Video Course is developed by Databricks Professionals to help you pass the Certified Data Engineer Associate exam.

    Description

    This course will improve your knowledge and skills required to pass Certified Data Engineer Associate exam.
  • Study Guide

    Certified Data Engineer Associate Study Guide

    432 PDF Pages

    Developed by industry experts, this 432-page guide spells out in painstaking detail all of the information you need to ace Certified Data Engineer Associate exam.

Certified Data Engineer Associate 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: $194.97
Bundle Price: $149.98

Purchase Individually

  • Questions & Answers

    Questions & Answers

    280 Questions

    $124.99
  • Certified Data Engineer Associate Video Course

    Video Course

    38 Video Lectures

    $39.99
  • Study Guide

    Study Guide

    432 PDF Pages

    $29.99

Databricks Certified Data Engineer Associate Practice Test 58

Question 570

An organization assigns a row filter to one source table but later creates another sensitive table under the same catalog requiring identical rules. What validation most directly tests the stated objective?

  1. Unauthorized queries still succeed.
  2. SQL queries expose all rows.
  3. Both protected tables receive consistent restrictions based on governed sensitive tags.
  4. The new table leaks sensitive rows.

Explanation

Correct Answer

C:

This outcome directly verifies the scenario's required behavior: table-level filters require per-table administration; tag-driven ABAC scales central enforcement.

Incorrect Answers

A:

Comments are not enforced policy.

B:

Client-side filtering does not enforce security.

D:

Table-specific filters don't automatically propagate to peers.

Question 571

A table has a phone mask attached, but a user can access its unmasked raw backing files through an unmanaged external path. What is the most defensible engineering action?

  1. Rename columns in SQL views while leaving raw path exposed
  2. Hide the external path in documentation
  3. Remove unauthorized direct storage access and align governance of underlying files with query-time masks.
  4. Disable query auditing instead of fixing permissions

Explanation

Correct Answer

C:

Query masks are not sufficient if users retain unrestricted raw storage access.

Incorrect Answers

A:

Aliases do not alter source storage rights

B:

Security through obscurity doesn't revoke storage credentials

D:

Missing logs hide, not stop, data exposure

Question 572

A table has a phone mask attached, but a user can access its unmasked raw backing files through an unmanaged external path. Which result provides the clearest acceptance evidence?

  1. The user cannot bypass masking by reading the raw source through alternate paths.
  2. The user lists raw files directly.
  3. Raw downloads remain possible.
  4. The full phone number remains in objects.

Explanation

Correct Answer

A:

This outcome directly verifies the scenario's required behavior: query masks are not sufficient if users retain unrestricted raw storage access.

Incorrect Answers

B:

Security through obscurity doesn't revoke storage credentials.

C:

Missing logs hide, not stop, data exposure.

D:

Aliases do not alter source storage rights.

Question 573

A finance analyst with SELECT on a secured table complains that a row filter returns zero records when their department membership is missing. What should be changed before promoting this workflow?

  1. Copy source data to an unrestricted table
  2. Return TRUE for all principals as a quick fix
  3. Remove the filter permanently to restore report totals
  4. Validate effective group membership and row-filter conditions rather than granting blanket bypass.

Explanation

Correct Answer

D:

Row filters can intentionally deny all rows when identity attributes fail to match.

Incorrect Answers

A:

Ungoverned duplicates bypass governance controls

B:

An always-true filter discloses every department

C:

Deletion removes required row-level protection

Question 574

A finance analyst with SELECT on a secured table complains that a row filter returns zero records when their department membership is missing. Which result should determine whether the change is accepted?

  1. All users can access every row.
  2. Authorized membership restores only appropriate department rows, with all other rows still hidden.
  3. Cross-department records become visible.
  4. Unauthorized users see payroll data.

Explanation

Correct Answer

B:

This outcome directly verifies the scenario's required behavior: row filters can intentionally deny all rows when identity attributes fail to match.

Incorrect Answers

A:

Ungoverned duplicates bypass governance controls.

C:

Deletion removes required row-level protection.

D:

An always-true filter discloses every department.

Question 575

A data product wants users to read aggregated health metrics but not patient-identifiable columns in the same governed table. What is the correct next step for this pipeline?

  1. Put an internal policy warning in the dashboard header
  2. Use only row filters and expose full identifier columns in allowed rows
  3. Apply correct column masks or a restricted projection along with necessary row filters where applicable.
  4. Grant SELECT on unrestricted raw Bronze tables

Explanation

Correct Answer

C:

Column restriction and row restriction address distinct exposure dimensions.

Incorrect Answers

A:

A warning is not an enforced data access control

B:

A filtered row can still carry prohibited personal values

D:

Raw tables may contain all protected fields

Question 576

A data product wants users to read aggregated health metrics but not patient-identifiable columns in the same governed table. What should the engineer verify before declaring success?

  1. Users bypass curated masking.
  2. Analysts see patient IDs.
  3. The SQL client returns full identifiers.
  4. Ordinary analysts see approved metrics and cannot retrieve direct identifiers.

Explanation

Correct Answer

D:

This outcome directly verifies the scenario's required behavior: column restriction and row restriction address distinct exposure dimensions.

Incorrect Answers

A:

Raw tables may contain all protected fields.

B:

A filtered row can still carry prohibited personal values.

C:

A warning is not an enforced data access control.

Question 577

A large catalog has dozens of tables tagged with governed sensitivity=pii and central compliance wants identical masking across all of them. What should the data engineer do to address the stated issue?

  1. Use an ordinary ungoverned descriptive tag with no ABAC policy
  2. Manually apply a mask only to the first table
  3. Hide only the catalog browser column list
  4. Attach a supported Unity Catalog ABAC column-mask policy using the governed tag and scoped principals.

Explanation

Correct Answer

D:

Tag-based ABAC centralizes policy application without updating each table separately.

Incorrect Answers

A:

A label by itself doesn't enforce masking

B:

Other tagged tables remain unprotected

C:

UI appearance doesn't change SELECT output

Question 578

A large catalog has dozens of tables tagged with governed sensitivity=pii and central compliance wants identical masking across all of them. What validation most directly tests the stated objective?

  1. Sensitive values remain visible.
  2. Tagged sensitive columns are masked automatically across the policy scope under permitted queries.
  3. A new dataset exposes full PII.
  4. Direct SQL reveals the full values.

Explanation

Correct Answer

B:

This outcome directly verifies the scenario's required behavior: tag-based ABAC centralizes policy application without updating each table separately.

Incorrect Answers

A:

A label by itself doesn't enforce masking.

C:

Other tagged tables remain unprotected.

D:

UI appearance doesn't change SELECT output.

Question 579

A new tagged finance table is created under a catalog with an ABAC row policy, and the owner should not bypass central policy enforcement. What is the most defensible engineering action?

  1. Rely on table owners to remember manual filters
  2. Apply the centrally scoped governed-tag ABAC row filter and validate its effective scope.
  3. Set one table-specific filter and assume central enforcement exists
  4. Use only dashboard filter widgets

Explanation

Correct Answer

B:

ABAC policy scope and governed tags can enforce protections across new data objects.

Incorrect Answers

A:

Human omissions leave new tables exposed

C:

Per-table controls don't cover the catalog automatically

D:

UI filters are bypassable by SQL clients

Question 580

A new tagged finance table is created under a catalog with an ABAC row policy, and the owner should not bypass central policy enforcement. Which result provides the clearest acceptance evidence?

  1. The owner forgets to attach a filter.
  2. Another tagged table has no filter.
  3. A notebook returns every row.
  4. The new matching table is filtered at query time and its owner cannot remove central catalog policy.

Explanation

Correct Answer

D:

This outcome directly verifies the scenario's required behavior: aBAC policy scope and governed tags can enforce protections across new data objects.

Incorrect Answers

A:

Human omissions leave new tables exposed.

B:

Per-table controls don't cover the catalog automatically.

C:

UI filters are bypassable by SQL clients.