A Healthcare Company Uses AWS Data and Analytics Tools to Collect

question 107

Multiple Choice

A healthcare company uses AWS data and analytics tools to collect, ingest, and store electronic health record (EHR) data about its patients. The raw EHR data is stored in Amazon S3 in JSON format partitioned by hour, day, and year and is updated every hour. The company wants to maintain the data catalog and metadata in an AWS Glue Data Catalog to be able to access the data using Amazon Athena or Amazon Redshift Spectrum for analytics. When defining tables in the Data Catalog, the company has the following requirements: Choose the catalog table name and do not rely on the catalog table naming algorithm. Keep the table updated with new partitions loaded in the respective S3 bucket prefixes. Which solution meets these requirements with minimal effort?

• A) Run an AWS Glue crawler that connects to one or more data stores, determines the data structures, and writes tables in the Data Catalog.
• B) Use the AWS Glue console to manually create a table in the Data Catalog and schedule an AWS Lambda function to update the table partitions hourly.
• C) Use the AWS Glue API CreateTable operation to create a table in the Data Catalog. Create an AWS Glue crawler and specify the table as the source.
• D) Create an Apache Hive catalog in Amazon EMR with the table schema definition in Amazon S3, and update the table partition with a scheduled job. Migrate the Hive catalog to the Data Catalog.

---

Definitions:

Costs

The expenditure required to produce, acquire, or maintain a product or service, including materials, labor, and overhead expenses.

Absolute Advantage

The ability of an entity to produce a good or service more efficiently than its competitors, using fewer resources.

Comparative Advantage

The capacity for a person, company, or nation to generate a product or offer a service at a lesser opportunity cost compared to its rivals.

Opportunity Cost

The expense incurred by not choosing the second-best option available when a decision is made or an action is taken.