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

Questions 6–10

1. 6foundation · easy

   Which AWS service can be used to automatically add new partitions to the AWS Glue Data Catalog as new data arrives in S3?

   • AAmazon CloudWatch Events
   • BAWS Glue Crawler
   • CAWS Lambda
   • DAmazon S3 lifecycle policies
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which of the following is a typical use case for an AWS Glue connection?

   • ATo allow an AWS Glue crawler to connect to a JDBC data source like Amazon Redshift.
   • BTo store the output data of an AWS Glue ETL job.
   • CTo schedule AWS Glue jobs.
   • DTo define the transformation logic of an AWS Glue ETL job.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Why is it important to synchronize partitions in a data catalog when new data is added to an S3 location?

   • ATo physically move the new data into the catalog's storage.
   • BTo delete old partitions that are no longer needed.
   • CTo ensure the data catalog reflects the new partitions, allowing query engines to read the new data.
   • DTo encrypt the new partitions for security.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A company runs an Amazon EMR cluster with Spark. They want to use the AWS Glue Data Catalog as the metastore so that tables created in Spark are visible to Athena and other services. What configuration is needed on the EMR cluster?

   • ASet 'spark.hadoop.fs.s3a.impl' to the EMR S3 filesystem.
   • BSet 'spark.sql.warehouse.dir' to an S3 path.
   • CSet 'hive.metastore.glue.catalogid' to the AWS account ID in the Hive configuration.
   • DSet 'hive-site' configuration with 'hive.metastore.client.factory.class' to use the AWS Glue Data Catalog.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A financial services company runs AWS Glue ETL jobs that read from a self-managed PostgreSQL database in a private VPC. The database is in a different subnet than the Glue job. The engineer creates a new AWS Glue connection to the database, but the job fails with a connection timeout. The security groups and network ACLs are correctly configured. What is the most likely missing configuration?

   • AThe connection's 'JDBC connection string' uses 'postgresql' instead of 'postgres' as the protocol.
   • BThe connection's 'Authentication' is set to 'No authentication', but the database requires a username and password.
   • CThe connection's 'Availability' is set to 'Multiple' but the database is in a single Availability Zone.
   • DThe connection's 'Network options' do not specify the VPC, subnet, and security group for the Glue job to use.
   Reveal Solution Discussion Select an answer first