Courseiva

CCNA Data Management Questions

49 questions · Data Management · All types, answers revealed

1
Multi-Selectmedium

Which TWO of the following are true regarding Dataplex security? (Choose two)

Select 2 answers
A.IAM roles can be applied at the Lake, Zone, or Asset level
B.Users must provide a password for each asset
C.Dataplex ignores existing storage permissions
D.Dataplex provides its own authentication system
E.Dataplex integrates with VPC Service Controls
AnswersA, E

Granular IAM is supported.

Why this answer

Dataplex uses IAM for access and integrates with GCP security features.

2
MCQhard

You need to control access to specific columns in a BigQuery table using Dataplex-integrated policy tags. What must you create before you can apply a policy tag to a column?

A.Data Zone
B.IAM Condition
C.BigQuery Dataset permission
D.Policy Tag Taxonomy
AnswerD

You must define the taxonomy and the specific tags within it first.

Why this answer

A Policy Tag Taxonomy must be created in the Data Catalog / Dataplex taxonomy management before tags can be applied to columns.

3
MCQmedium

You need to track lineage for a BigQuery table populated by a Dataflow pipeline. How does Dataplex help?

A.Lineage is not supported in Dataplex
B.You must use a third-party tool
C.Dataplex captures it automatically for supported services
D.You must manually enter the lineage in the Data Catalog UI
AnswerC

Lineage is automatically integrated for BigQuery and Dataflow.

Why this answer

Dataplex and Data Catalog integrate with BigQuery and Dataflow to capture lineage automatically when pipelines are correctly instrumented.

4
MCQmedium

You want to enforce that all data in a specific Dataplex Zone must be encrypted with a Customer-Managed Encryption Key (CMEK). How do you enforce this?

A.There is no way to enforce CMEK in Dataplex
B.Use a Dataflow job to re-encrypt
C.Configure CMEK at the Lake/Zone creation level
D.Apply it via an IAM policy
AnswerC

Dataplex allows specifying CMEK keys during resource creation to enforce encryption.

Why this answer

When creating a Dataplex Lake or Zone, you can configure CMEK settings that apply to the underlying resources.

5
MCQmedium

You are migrating data into a Dataplex Lake. You need to ensure that the data is partitioned by date to improve query performance. Where do you define this partitioning?

A.At the Zone level
B.At the Lake level
C.In the IAM policy
D.At the Asset level
AnswerD

Assets represent the physical data; partitioning is defined here.

Why this answer

In Dataplex, partitioning is defined at the asset level when linking the BigQuery table or Cloud Storage files.

6
MCQmedium

You need to restrict data access to specific geographic regions for compliance. Which Dataplex feature supports this?

A.Location-based IAM policies
B.Regionalized Lake and Zone definition
C.Data residency tags
D.VPC Service Controls
AnswerB

You define the region during the creation of Lakes and Zones.

Why this answer

Dataplex allows you to restrict the location of data assets when creating a lake or zone.

7
MCQmedium

You need to share a BigQuery dataset across multiple organizations. What is the recommended approach using Dataplex?

A.Grant public access to the dataset
B.Copy all data to a single project
C.Use Dataplex to aggregate the datasets in one Lake
D.Export the data to CSV files
AnswerC

Dataplex provides the logical layer to bridge these assets.

Why this answer

Dataplex allows you to link cross-project and cross-org assets into a single lake, provided the appropriate IAM permissions are set.

8
Multi-Selecthard

You are troubleshooting lineage issues. Which THREE of the following factors could prevent lineage from being captured? (Choose three)

Select 3 answers
A.The service account lacks 'lineage.events.create' permission
B.The user is not an administrator of the lake
C.The pipeline is not using the correct API endpoints
D.The job uses an unsupported service
E.The data files are in a multi-region bucket
AnswersA, C, D

Required permission for writing lineage.

Why this answer

Lineage requires specific services, proper permissions, and correct instrumentation.

9
MCQeasy

Which role is required to manage Dataplex assets within a Zone?

A.roles/storage.admin
B.roles/bigquery.admin
C.roles/dataplex.admin
D.roles/viewer
AnswerC

This role allows full management of lakes, zones, and assets.

Why this answer

The Dataplex Data Steward or Dataplex Admin role is required to manage assets, but specifically 'roles/dataplex.admin' or 'roles/dataplex.dataSteward' are used.

10
MCQhard

You want to perform data quality checks on a BigQuery table that is updated daily. How should you schedule the Dataplex task?

A.Configure a CRON schedule on the task
B.Manually trigger via the UI
C.Wait for discovery to trigger it
D.Use Cloud Run to trigger the task
AnswerA

Tasks support scheduling for automation.

Why this answer

Dataplex tasks can be triggered on a schedule using cron syntax, allowing for daily alignment with data updates.

11
MCQeasy

Which of the following is NOT a benefit of using Dataplex?

A.High-frequency OLTP transaction support
B.Automated data discovery
C.Improved data compliance
D.Unified data management
AnswerA

Dataplex does not provide OLTP capabilities; that is for Cloud Spanner/SQL.

Why this answer

Dataplex is for data governance and management, not for high-frequency low-latency transaction processing (OLTP).

12
Multi-Selecteasy

Which TWO of the following tools allow you to interact with Dataplex? (Choose two)

Select 2 answers
A.Google Cloud CLI (gcloud)
B.A local database client like DBeaver
C.Text editor for configuration files
D.Google Cloud Console
E.A standard SSH client
AnswersA, D

Used for scripting and automation.

Why this answer

Users interact with Dataplex via the Cloud Console and the Google Cloud CLI (gcloud).

13
Multi-Selecthard

Which THREE of the following are common administrative tasks when managing a Dataplex Lake? (Choose three)

Select 3 answers
A.Adding and removing data assets
B.Manually editing individual data files
C.Rebuilding the physical database indexes
D.Configuring data quality task schedules
E.Managing IAM permissions for lake users
AnswersA, D, E

Managing the contents of the lake.

Why this answer

Admins handle access, assets, and task scheduling.

14
MCQmedium

A team requires access to a specific Dataplex Zone. You want to grant them the ability to view metadata and query the data without granting them full owner permissions. Which role should you assign at the Lake level?

A.roles/dataplex.dataViewer
B.roles/bigquery.dataViewer
C.roles/dataplex.viewer
D.roles/dataplex.admin
AnswerA

This role is designed to allow read access to metadata and underlying data.

Why this answer

The Dataplex Data Viewer role allows viewing metadata and querying data within the lake assets.

15
Multi-Selecthard

You need to ensure data compliance for PII. Which THREE of the following tools or features should you use in combination with Dataplex? (Choose three)

Select 3 answers
A.Cloud Audit Logs to monitor access
B.Cloud Data Loss Prevention (DLP) API
C.Cloud Build for data encryption
D.Cloud Scheduler for data deletion
E.Policy Tags for fine-grained access
AnswersA, B, E

Audit logs ensure accountability.

Why this answer

DLP API, Policy Tags, and Audit Logs are standard for compliance.

16
Multi-Selectmedium

When setting up a new Dataplex Lake, which TWO of the following configurations are required? (Choose two)

Select 2 answers
A.A unique name for the Lake
B.A default encryption key
C.A geographic region
D.An external URL for the data
E.A list of all users in the organization
AnswersA, C

Names must be unique within the project.

Why this answer

A name and a region are required for every Lake creation.

17
MCQmedium

You have a Dataplex Lake containing data from two different regions. How does this affect data access?

A.Users cannot access data across regions
B.Users must have access to both regional storage resources
C.Data access is automatically merged
D.The Lake automatically replicates data
AnswerB

Regional access rules still apply to the physical data.

Why this answer

You must ensure that users have the necessary IAM permissions to access the data in both regions; the lake acts as a logical container but does not override regional access restrictions.

18
MCQhard

You need to ensure that a Dataplex user cannot view the contents of files in a GCS bucket registered as an asset. What is the minimal configuration?

A.Remove the Storage Object Viewer role from the user
B.Remove the user from the Dataplex Lake Viewer role
C.Create a Dataplex deny-policy
D.Delete the asset from Dataplex
AnswerA

IAM roles on the underlying storage resource govern data access.

Why this answer

You must remove the Storage Object Viewer role from the user for that specific bucket, even if they have Dataplex viewer roles.

19
MCQmedium

You have a Data Catalog taxonomy that you want to share across multiple projects. How do you achieve this?

A.Move the taxonomy to the Organization node
B.Duplicate the taxonomy in each project
C.Define it in a central project and share access
D.Use Cloud Resource Manager to link them
AnswerC

Taxonomies can be created in a central project and referenced by others.

Why this answer

You create the taxonomy in a central host project and grant permissions to other projects to use it.

20
MCQhard

When setting up a Dataplex Lake, you chose the 'Multi-region' location type. What is the implication of this choice?

A.It restricts access to users in a single region
B.It prevents the use of BigQuery datasets
C.It reduces the cost of storing data
D.It improves data availability and durability
AnswerD

Multi-region provides high availability and geo-redundancy.

Why this answer

Multi-region deployment increases availability and ensures data is replicated across multiple regions within the same geography.

21
MCQmedium

What is the role of the 'Dataplex Data Steward'?

A.To write SQL queries for the business
B.To manage metadata, quality rules, and compliance
C.To develop ETL pipelines
D.To manage the underlying infrastructure
AnswerB

Data stewards handle the 'data' aspects of the platform.

Why this answer

The Data Steward is responsible for defining metadata, managing quality rules, and ensuring data policies are met.

22
MCQeasy

Which console menu would you navigate to in order to access Dataplex?

A.Compute Engine
B.Operations
C.Analytics
D.Storage
AnswerC

Dataplex is grouped under Analytics services.

Why this answer

Dataplex is found under the 'Analytics' section in the Google Cloud console.

23
MCQmedium

You have multiple departments using the same Dataplex Lake. You need to ensure that each department can only see data belonging to their own projects. What should you configure?

A.Data tags on the assets
B.IAM roles on the bucket only
C.Separate Lakes for each department
D.Separate Zones within the Lake
AnswerD

Zones allow for scoping data and security boundaries within a single lake.

Why this answer

Dataplex Zones allow for logical separation within a Lake, where permissions can be scoped to the zone level.

24
MCQmedium

You need to move an asset from one Dataplex Zone to another. What is the correct procedure?

A.Update the IAM policy to include the new zone
B.Delete the asset from the first zone and recreate it in the second
C.Use the 'move' command in the CLI
D.Update the asset metadata to point to the new zone
AnswerB

Assets are zone-bound; deletion and recreation is the required path.

Why this answer

Assets are tied to a specific zone. To move an asset, you must remove it from the source zone and add it to the destination zone.

25
MCQeasy

What does 'Data Lineage' show you in Dataplex?

A.The path the data took through the system
B.The number of users accessing the data
C.The cost of storing data
D.The database schema version
AnswerA

Lineage captures the 'where did this come from' information.

Why this answer

Data lineage tracks the origin, movement, and transformations of data as it moves through the pipeline.

26
Multi-Selecthard

You need to migrate legacy data to a Dataplex Lake. Which THREE of the following should you consider for a successful migration? (Choose three)

Select 3 answers
A.Define a clear zone strategy
B.Audit existing IAM permissions for the source data
C.Disable all data quality checks
D.Manually copy every file using scp
E.Enable discovery to inventory existing data
AnswersA, B, E

Plan your organization structure.

Why this answer

Migration requires planning for IAM, discovery, and testing.

27
MCQhard

You are configuring a Dataplex asset that points to a GCS bucket. You want to ensure that only files in a specific folder are included in the asset. How do you specify this?

A.Define a SQL view on the folder
B.Use an IAM condition on the bucket
C.Specify a path filter in the asset definition
D.Move the files to a separate bucket
AnswerC

Dataplex assets support prefix filters for GCS buckets.

Why this answer

When adding a GCS bucket as an asset, you can provide a filter or prefix to limit the scope to a specific path.

28
MCQhard

You have an automated pipeline that deletes files in a GCS bucket every hour. Dataplex shows the asset as 'Out of sync'. Why?

A.The lake is locked for maintenance
B.The user does not have permission to delete files
C.Discovery needs to rescan to update metadata
D.The file deletion is violating the Dataplex policy
AnswerC

Metadata becomes stale if discovery hasn't refreshed the state.

Why this answer

Dataplex discovery scans periodically; if the physical data changes without the discovery job having run, the metadata might show as out of sync.

29
MCQhard

You need to audit who accessed sensitive data in a Dataplex Lake. Which service should you monitor to see access logs for these data assets?

A.Dataplex Task Logs
B.Cloud Audit Logs
C.BigQuery Query Logs
D.Data Catalog history
AnswerB

Audit logs capture all API requests and access to Google Cloud resources.

Why this answer

Cloud Audit Logs records all access to data assets; Dataplex provides a unified view, but the logs reside in Cloud Audit Logs.

30
MCQmedium

Which Dataplex component allows you to query data across different storage systems using a single SQL interface?

A.Dataproc
B.Data Catalog
C.Cloud Storage
D.BigQuery
AnswerD

BigQuery acts as the compute engine for querying data assets in the lake.

Why this answer

The Dataplex Lake provides a unified view, and BigQuery Omni or federated queries allow querying across different storage systems.

31
MCQhard

You are configuring a Dataplex Data Quality task. You want to validate that a 'user_id' column has no NULL values. Where do you define this rule?

A.In the Cloud Storage metadata
B.In a YAML configuration file
C.In the BigQuery table schema
D.In the Dataplex Asset definition
AnswerB

Dataplex expects a YAML file defining the quality rules to be passed to the task.

Why this answer

Data quality rules are defined in a YAML configuration file that Dataplex uses to run the quality check task.

32
Multi-Selecteasy

Which TWO of the following are valid locations for a Dataplex Lake? (Choose two)

Select 2 answers
A.A private on-premises data center
B.The root organization node
C.The user's local laptop
D.US (Multi-region)
E.US-central1
AnswersD, E

A valid multi-regional location.

Why this answer

Dataplex supports regional and multi-regional deployments.

33
MCQeasy

Which service allows you to view the schema and metadata of a BigQuery table that has been registered in Dataplex?

A.Data Catalog
B.Cloud Storage Console
C.Cloud Build
D.Cloud IAM console
AnswerA

Data Catalog is the tool used for viewing schema and metadata.

Why this answer

The Data Catalog interface within Dataplex provides a unified view of metadata, including schemas.

34
MCQeasy

What is the purpose of a 'Data Zone' in Dataplex?

A.To execute Spark jobs
B.To store query results
C.To act as a physical storage location
D.To provide a logical grouping for governance and policies
AnswerD

Zones serve as the logical boundary for policies and data management.

Why this answer

Zones are used to group data assets within a lake for common governance, security, and lifecycle policies.

35
MCQeasy

You have sensitive data in Cloud Storage that needs to be deleted after 30 days to comply with regulatory requirements. What is the most efficient way to manage this?

A.Use Cloud Storage lifecycle management policies
B.Run a manual BigQuery script
C.Write a Cloud Function to check dates and delete files
D.Create a Dataplex lifecycle task
AnswerA

Lifecycle rules are the native and most efficient way to handle object expiration.

Why this answer

Object lifecycle management rules in Cloud Storage are the standard way to automate data deletion based on age.

36
MCQeasy

Which service should you use to search for and discover datasets across your entire Google Cloud organization?

A.BigQuery Explorer
B.Cloud Storage Browser
C.Cloud Logging
D.Data Catalog
AnswerD

Data Catalog allows centralized search and metadata discovery.

Why this answer

Data Catalog is the primary discovery tool for finding and understanding data assets in Google Cloud.

37
MCQmedium

What happens if you delete a Dataplex Lake?

A.The data is moved to a 'trash' bucket
B.The lake is deleted, but the underlying assets remain
C.Access to the assets is granted to all users
D.All underlying data assets are deleted
AnswerB

The lake is just a logical view; the storage remains intact.

Why this answer

Deleting a Lake removes the logical grouping but does not delete the underlying data assets (like BigQuery datasets or GCS buckets).

38
Multi-Selectmedium

Which TWO of the following statements about Dataplex discovery are true? (Choose two)

Select 2 answers
A.Discovery must be manually triggered for every scan
B.Discovery works only for BigQuery tables
C.Discovery deletes duplicate files
D.Discovery scans and infers schema from the data
E.Discovery generates metadata for the data assets
AnswersD, E

It automatically detects schemas.

Why this answer

Discovery is automatic for registered assets and generates metadata including schema.

39
Multi-Selecthard

You have noticed that your data quality tasks are failing. Which THREE of the following are potential causes for failure? (Choose three)

Select 3 answers
A.The YAML rule configuration is malformed
B.The service account lacks permissions on the data
C.The user has a slow internet connection
D.The Dataproc environment is not available
E.The data files were moved to another lake
AnswersA, B, D

Invalid YAML structure will cause the task to fail.

Why this answer

Common failures include permission issues, invalid rule configurations, or missing execution environments.

40
MCQhard

You need to ensure that PII (Personally Identifiable Information) in BigQuery is automatically detected and tagged across your organization. Which Dataplex feature should you enable on your Lake?

A.Automatic data discovery
B.Data quality task
C.Lifecycle management policy
D.IAM policy inheritance
AnswerA

Data discovery scans the underlying storage to detect and label data.

Why this answer

Dataplex discovery scans data assets and can automatically apply labels and tags based on system-defined taxonomies.

41
MCQeasy

What is the primary function of the 'Dataplex Discovery' process?

A.To manage VPC firewall rules
B.To run SQL queries
C.To migrate data to the cloud
D.To automatically catalog and profile data
AnswerD

Discovery crawls the data to generate metadata and profile information.

Why this answer

Discovery automatically scans and catalogs data assets in your storage to make them discoverable.

42
MCQhard

You have data scattered across multiple projects and need to provide a unified data governance view. What is the recommended hierarchy?

A.A single GCS bucket for all data
B.Multiple Lakes, one per project, and manage them independently
C.One Lake, with assets added from multiple projects
D.One Lake per project, then use a project-linking tool
AnswerC

Dataplex Lakes can aggregate assets across projects.

Why this answer

You create one Lake, and within that Lake, you add assets from different projects (within the same organization).

43
Multi-Selectmedium

Which TWO of the following are true about the relationship between Data Catalog and Dataplex? (Choose two)

Select 2 answers
A.Dataplex uses Data Catalog to store metadata
B.Data Catalog is now a sub-feature of Dataplex
C.You must pay for them separately
D.They have separate IAM systems
E.They are completely separate products
AnswersA, B

Data Catalog is the underlying metadata service.

Why this answer

Dataplex integrates Data Catalog capabilities; they are tightly coupled.

44
MCQmedium

You are using Dataplex to manage data across multiple projects. You need to organize your BigQuery datasets and Cloud Storage buckets into a single logical entity for governance. Which Dataplex resource should you create?

A.Lake
B.Asset
C.Taxonomy
D.Data Zone
AnswerA

A Lake is the top-level container for organizing data assets.

Why this answer

A Lake in Dataplex is a logical grouping of data assets that provides a boundary for governance and security.

45
Multi-Selecthard

You are implementing a security strategy for your data lake. Which THREE of the following are supported ways to control access to data within a Dataplex Lake? (Choose three)

Select 3 answers
A.Grant Dataplex-specific roles to users
B.Apply IAM roles to the underlying storage resources
C.Use Policy Tags for column-level security
D.Use IP-based firewalls for all datasets
E.Assign roles to individual files
AnswersA, B, C

Dataplex roles control access to the governance layer.

Why this answer

Access is controlled via IAM at the resource level, policy tags for fine-grained control, and Dataplex roles for metadata access.

46
Multi-Selectmedium

A team is migrating to Dataplex. Which TWO of the following are prerequisites for adding a BigQuery dataset as an asset to a Lake? (Choose two)

Select 2 answers
A.The user needs BigQuery permissions on the dataset
B.The user needs Dataplex asset-management permissions
C.The dataset must be public
D.The dataset must exist in the same project as the Lake
E.The dataset must contain at least one table
AnswersA, B

You must have read access to link the dataset.

Why this answer

The user needs proper IAM permissions on the project and the dataset to register it as an asset.

47
Multi-Selectmedium

You need to organize your data governance strategy. Which TWO of the following are valid ways to use Dataplex Zones to improve your data organization? (Choose two)

Select 2 answers
A.Assign different IAM policies to different zones
B.Use zones to store query results
C.Create separate zones for each user
D.Group data by processing state (e.g., raw, curated)
E.Use zones to increase data storage speed
AnswersA, D

Zones act as security boundaries.

Why this answer

Zones are used to group assets by purpose (e.g., raw vs curated) and to enforce security policies.

48
MCQeasy

A user complains they cannot see a Dataplex Lake in the console. You verify they have the 'Viewer' role on the project. What is missing?

A.They need to refresh their browser
B.They need the 'roles/dataplex.viewer' role
C.They need the 'Owner' role
D.They need to be added to the project's whitelist
AnswerB

Specific product-level viewer roles are required for resource visibility.

Why this answer

The user needs a specific Dataplex role (like Dataplex Viewer) to see the Dataplex resources in the UI.

49
Multi-Selectmedium

Which TWO of the following are true about Dataplex assets? (Choose two)

Select 2 answers
A.Assets can be created without a storage resource
B.Assets inherit the location of the zone
C.An asset must belong to exactly one zone
D.Assets can only be BigQuery tables
E.Assets duplicate the physical data
AnswersB, C

Assets share the zone's region.

Why this answer

Assets point to existing storage and are managed within zones.

Ready to test yourself?

Try a timed practice session using only Data Management questions.