Task 2.2: Understand Data Cataloging Systems DEA-C01 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A company has multiple data sources: an S3 bucket with CSV files, a JDBC database, and a streaming data source. The data engineering team wants to provide a unified view of all these sources to analysts using Athena. What is the primary benefit of using a data catalog in this scenario?

   • AIt provides a central metadata repository so analysts can query all sources without knowing their physical locations or formats.
   • BIt automatically replicates the data from all sources into a single S3 bucket for faster queries.
   • CIt transforms the data into a common format like Parquet to improve query performance.
   • DIt enforces data quality rules on all sources before they are queried.
   Reveal Solution Discussion Select an answer first
2. 12expert · medium

   A company uses SageMaker Catalog to share ML datasets. The data science team wants to publish a new version of a dataset, but they need to ensure that only a specific group of users can access the new version, while other users can still access the previous version. What is the most efficient way to achieve this?

   • AUpdate the existing SageMaker Asset with the new version and change the permissions to allow only the specific group.
   • BStore the new version in a different S3 bucket and create a new SageMaker Asset with a different name.
   • CCreate a new SageMaker Asset for the new version and update the permissions on the old asset to restrict access.
   • DUse SageMaker Catalog's versioning feature to add the new version to the existing asset and set permissions per version.
   Reveal Solution Discussion Select an answer first
4. 13expert · medium

   A company has an S3 bucket with data in Parquet format. The data is partitioned by date, and new partitions are added daily. A data engineer creates a table in the AWS Glue Data Catalog using a crawler. The crawler runs daily and successfully adds new partitions. However, the engineer notices that the table's schema is outdated: a new column was added to the Parquet files, but the crawler did not update the table schema. What is the most likely cause?

   • AThe crawler's 'Partition indexing' is disabled, so new columns are not detected.
   • BThe crawler's 'Schema updates' option is set to 'Add new columns only', which prevents the crawler from updating the table definition with the new column.
   • CThe crawler's 'Grouping behavior for S3 data' is set to 'Create a single table', which prevents schema updates.
   • DThe crawler's 'Schedule' is set to run on-demand, so it does not update the schema.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What is the primary purpose of a data cataloging system in a data analytics environment?

   • ATo store the actual data files that are ingested from source systems.
   • BTo provide a centralized metadata repository that describes data assets, making them discoverable and queryable.
   • CTo enforce security policies on the data files stored in the data lake.
   • DTo transform raw data into a clean, queryable format before it is stored.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A marketing analytics team uses Amazon Athena to query data stored in S3. They have a new dataset in a different S3 bucket with a complex schema. The team wants to make this dataset queryable in Athena without writing DDL statements. What should they do first?

   • ACreate a SageMaker Catalog entry for the dataset.
   • BUse the Athena 'CREATE TABLE' statement with the schema manually.
   • CCreate an AWS Glue connection to the S3 bucket.
   • DRun an AWS Glue crawler on the S3 bucket to populate the Data Catalog.
   Reveal Solution Discussion Select an answer first