🔍

DEA-C01 — questions

Page 11 of 16 · 313 total questions.

DEA-C01 Question 201

Single page →
Topic 1 · Question 201

A company uses Amazon DataZone as a data governance and business catalog solution. The company stores data in an Amazon S3 data lake. The company uses AWS Glue with an AWS Glue Data Catalog. A data engineer needs to publish AWS Glue Data Quality scores to the Amazon DataZone portal. Which solution will meet this requirement?

  • ACreate a data quality ruleset with Data Quality Definition language (DQDL) rules that apply to a specific AWS Glue table. Schedule the ruleset to run daily. Configure the Amazon DataZone project to have an Amazon Redshift data source. Enable the data quality configuration for the data source.
  • BConfigure AWS Glue ETL jobs to use an Evaluate Data Quality transform. Define a data quality ruleset inside the jobs. Configure the Amazon DataZone project to have an AWS Glue data source. Enable the data quality configuration for the data source.
  • CCreate a data quality ruleset with Data Quality Definition language (DQDL) rules that apply to a specific AWS Glue table. Schedule the ruleset to run daily. Configure the Amazon DataZone project to have an AWS Glue data source. Enable the data quality configuration for the data source. (correct answer)
  • DConfigure AWS Glue ETL jobs to use an Evaluate Data Quality transform. Define a data quality ruleset inside the jobs. Configure the Amazon DataZone project to have an Amazon Redshift data source. Enable the data quality configuration for the data source.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Create a data quality ruleset with Data Quality Definition language (DQDL) rules that apply to a specific AWS Glue table. Schedule the ruleset to run daily. Configure the Amazon DataZone project to have an AWS Glue da...

Explanation

AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. AWS Config tracks resource configuration changes and evaluates compliance.

DEA-C01 Question 202

Single page →
Topic 1 · Question 202

A company has a data warehouse in Amazon Redshift. To comply with security regulations, the company needs to log and store all user activities and connection activities for the data warehouse. Which solution will meet these requirements?

  • ACreate an Amazon S3 bucket. Enable logging for the Amazon Redshift cluster. Specify the S3 bucket in the logging configuration to store the logs. (correct answer)
  • BCreate an Amazon Elastic File System (Amazon EFS) file system. Enable logging for the Amazon Redshift cluster. Write logs to the EFS file system.
  • CCreate an Amazon Aurora MySQL database. Enable logging for the Amazon Redshift cluster. Write the logs to a table in the Aurora MySQL database.
  • DCreate an Amazon Elastic Block Store (Amazon EBS) volume. Enable logging for the Amazon Redshift cluster. Write the logs to the EBS volume.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Create an Amazon S3 bucket. Enable logging for the Amazon Redshift cluster. Specify the S3 bucket in the logging configuration to store the logs.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries. AWS Config tracks resource configuration changes and evaluates compliance.

DEA-C01 Question 203

Single page →
Topic 1 · Question 203

A company wants to migrate a data warehouse from Teradata to Amazon Redshift. Which solution will meet this requirement with the LEAST operational effort?

  • AUse AWS Database Migration Service (AWS DMS) Schema Conversion to migrate the schema. Use AWS DMS to migrate the data.
  • BUse the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data. (correct answer)
  • CUse AWS Database Migration Service (AWS DMS) to migrate the data. Use automatic schema conversion.
  • DManually export the schema definition from Teradata. Apply the schema to the Amazon Redshift database. Use AWS Database Migration Service (AWS DMS) to migrate the data.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use the AWS Schema Conversion Tool (AWS SCT) to migrate the schema. Use AWS Database Migration Service (AWS DMS) to migrate the data.

Explanation

AWS Database Migration Service migrates databases with minimal downtime.

DEA-C01 Question 204

Single page →
Topic 1 · Question 204

A company uses a variety of AWS and third-party data stores. The company wants to consolidate all the data into a central data warehouse to perform analytics. Users need fast response times for analytics queries. The company uses Amazon QuickSight in direct query mode to visualize the data. Users normally run queries during a few hours each day with unpredictable spikes. Which solution will meet these requirements with the LEAST operational overhead?

  • AUse Amazon Redshift Serverless to load all the data into Amazon Redshift managed storage (RMS). (correct answer)
  • BUse Amazon Athena to load all the data into Amazon S3 in Apache Parquet format.
  • CUse Amazon Redshift provisioned clusters to load all the data into Amazon Redshift managed storage (RMS).
  • DUse Amazon Aurora PostgreSQL to load all the data into Aurora.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use Amazon Redshift Serverless to load all the data into Amazon Redshift managed storage (RMS).

Explanation

Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries.

DEA-C01 Question 205

Single page →
Topic 1 · Question 205

A data engineer uses Amazon Kinesis Data Streams to ingest and process records that contain user behavior data from an application every day. The data engineer notices that the data stream is experiencing throttling because hot shards receive much more data than other shards in the data stream. How should the data engineer resolve the throttling issue?

  • AUse a random partition key to distribute the ingested records. (correct answer)
  • BIncrease the number of shards in the data stream. Distribute the records across the shards.
  • CLimit the number of records that are sent each second by the producer to match the capacity of the stream.
  • DDecrease the size of the records that the producer sends to match the capacity of the stream.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Use a random partition key to distribute the ingested records.

Explanation

Amazon RDS is a managed relational database that handles patching, backups and failover.

DEA-C01 Question 206

Single page →
Topic 1 · Question 206

A company has a data processing pipeline that includes several dozen steps. The data processing pipeline needs to send alerts in real time when a step fails or succeeds. The data processing pipeline uses a combination of Amazon S3 buckets, AWS Lambda functions, and AWS Step Functions state machines. A data engineer needs to create a solution to monitor the entire pipeline. Which solution will meet these requirements?

  • AConfigure the Step Functions state machines to store notifications in an Amazon S3 bucket when the state machines finish running. Enable S3 event notifications on the S3 bucket.
  • BConfigure the AWS Lambda functions to store notifications in an Amazon S3 bucket when the state machines finish running. Enable S3 event notifications on the S3 bucket.
  • CUse AWS CloudTrail to send a message to an Amazon Simple Notification Service (Amazon SNS) topic that sends notifications when a state machine fails to run or succeeds to run.
  • DConfigure an Amazon EventBridge rule to react when the execution status of a state machine changes. Configure the rule to send a message to an Amazon Simple Notification Service (Amazon SNS) topic that sends notifications. (correct answer)
Reveal answer & explanation
Correct answer: D

The correct answer is D. Option D: Configure an Amazon EventBridge rule to react when the execution status of a state machine changes. Configure the rule to send a message to an Amazon Simple Notification Service (Amazon SNS) topic that sends notificat...

Explanation

Amazon SNS is a managed pub/sub service for fan-out notifications to many subscribers. Amazon EventBridge routes events between services with rules, enabling event-driven, decoupled architectures. AWS Config tracks resource configuration changes and evaluates compliance. This option meets the real-time / low-latency performance requirement.

DEA-C01 Question 207

Single page →
Topic 1 · Question 207

A company has an application that uses an Amazon API Gateway REST API and an AWS Lambda function to retrieve data from an Amazon DynamoDB instance. Users recently reported intermittent high latency in the application's response times. A data engineer finds that the Lambda function experiences frequent throttling when the company's other Lambda functions experience increased invocations. The company wants to ensure the API's Lambda function operate without being affected by other Lambda functions. Which solution will meet this requirement MOST cost-effectively?

  • AIncrease the number of read capacity unit (RCU) in DynamoDB.
  • BConfigure provisioned concurrency for the Lambda function.
  • CConfigure reserved concurrency for the Lambda function. (correct answer)
  • DIncrease the Lambda function timeout and allocated memory.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Configure reserved concurrency for the Lambda function.

Explanation

AWS Lambda runs code without provisioning servers and scales automatically, which minimizes operational overhead. AWS Config tracks resource configuration changes and evaluates compliance. This option delivers the requirement at the lowest cost.

DEA-C01 Question 208

Single page →
Topic 1 · Question 208

A company has as JSON file that contains personally identifiable information (PII) data and non-PII data. The company needs to make the data available for querying and analysis. The non-PII data must be available to everyone in the company. The PII data must be available only to a limited group of employees. Which solution will meet these requirements with the LEAST operational overhead?

  • AStore the JSON file in an Amazon S3 bucket. Configure AWS Glue to split the file into one file that contains the PII data and one file that contains the non-PII data. Store the output files in separate S3 buckets. Grant the required access to the buckets based on the type of user.
  • BStore the JSON file in an Amazon S3 bucket. Use Amazon Macie to identify PII data and to grant access based on the type of user.
  • CStore the JSON file in an Amazon S3 bucket. Catalog the file schema in AWS Lake Formation. Use Lake Formation permissions to provide access to the required data based on the type of user. (correct answer)
  • DCreate two Amazon RDS PostgreSQL databases. Load the PII data and the non-PII data into the separate databases. Grant access to the databases based on the type of user.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Store the JSON file in an Amazon S3 bucket. Catalog the file schema in AWS Lake Formation. Use Lake Formation permissions to provide access to the required data based on the type of user.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. AWS Lake Formation builds and secures data lakes quickly.

DEA-C01 Question 209

Single page →
Topic 1 · Question 209 · Select all that apply

A company uses AWS Key Management Service (AWS KMS) to encrypt an Amazon Redshift cluster. The company wants to configure a cross-Region snapshot of the Redshift cluster as part of disaster recovery (DR) strategy. A data engineer needs to use the AWS CLI to create the cross-Region snapshot. Which combination of steps will meet these requirements? (Choose two.)

  • ACreate a KMS key and configure a snapshot copy grant in the source AWS Region. (correct answer)
  • BIn the source AWS Region, enable snapshot copying. Specify the name of the snapshot copy grant that is created in the destination AWS Region.
  • CIn the source AWS Region, enable snapshot copying. Specify the name of the snapshot copy grant that is created in the source AWS Region. (correct answer)
  • DCreate a KMS key and configure a snapshot copy grant in the destination AWS Region.
  • EConvert the cluster to a Multi-AZ deployment.
Reveal answer & explanation
Correct answer: A, C

The correct answer is A, C. Option A: Create a KMS key and configure a snapshot copy grant in the source AWS Region. Option C: In the source AWS Region, enable snapshot copying. Specify the name of the snapshot copy grant that is created in the source AWS Region.

Explanation

AWS KMS manages encryption keys and integrates with most AWS services for encryption at rest. AWS Config tracks resource configuration changes and evaluates compliance. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

DEA-C01 Question 210

Single page →
Topic 1 · Question 210

A company is using Amazon S3 to build a data lake. The company needs to replicate records from multiple source databases into Apache Parquet format. Most of the source databases are hosted on Amazon RDS. However, one source database is an on-premises Microsoft SQL Server Enterprise instance. The company needs to implement a solution to replicate existing data from all source databases and all future changes to the target S3 data lake. Which solution will meet these requirements MOST cost-effectively?

  • AUse one AWS Glue job to replicate existing data. Use a second AWS Glue job to replicate future changes.
  • BUse AWS Database Migration Service (AWS DMS) to replicate existing data. Use AWS Glue jobs to replicate future changes.
  • CUse AWS Database Migration Service (AWS DMS) to replicate existing data and future changes. (correct answer)
  • DUse AWS Glue jobs to replicate existing data. Use Amazon Kinesis Data Streams to replicate future changes.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use AWS Database Migration Service (AWS DMS) to replicate existing data and future changes.

Explanation

AWS Database Migration Service migrates databases with minimal downtime. This option delivers the requirement at the lowest cost.

DEA-C01 Question 211

Single page →
Topic 1 · Question 211

A data engineer needs to optimize the performance of a data pipeline that handles retail orders. Data about the orders is ingested daily into an Amazon S3 bucket. The data engineer runs queries once each week to extract metrics from the orders data based the order date for multiple date ranges. The data engineer needs an optimization solution that ensures the query performance will not degrade when the volume of data increases. Which solution will meet this requirement MOST cost-effectively?

  • APartition the data based on order date. Use Amazon Athena to query the data. (correct answer)
  • BPartition the data based on order date. Use Amazon Redshift to query the data.
  • CPartition the data based on load date. Use Amazon EMR to query the data.
  • DPartition the data based on load date. Use Amazon Aurora to query the data.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Partition the data based on order date. Use Amazon Athena to query the data.

Explanation

Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. This option delivers the requirement at the lowest cost.

DEA-C01 Question 212

Single page →
Topic 1 · Question 212

A data engineer has two datasets that contain sales information for multiple cities and states. One dataset is named reference, and the other dataset is named primary. The data engineer needs a solution to determine whether a specific set of values in the city and state columns of the primary dataset exactly match the same specific values in the reference dataset. The data engineer wants to use Data Quality Definition Language (DQDL) rules in an AWS Glue Data Quality job. Which rule will meet these requirements?

  • ADatasetMatch "reference” “city->ref_city, state->ref_state” = 1.0 (correct answer)
  • BReferentiallntegrity “city,state” “reference.{ref_city,ref_state}” = 1.0
  • CDatasetMatch “reference” “city->ref_city, state->ref_state” = 100
  • DReferentialintegrity “city,state” "reference.{ref_city,ref_state}” = 100
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: DatasetMatch "reference” “city->ref_city, state->ref_state” = 1.0.

DEA-C01 Question 213

Single page →
Topic 1 · Question 213

A company has an on-premises PostgreSQL database that contains customer data. The company wants to migrate the customer data to an Amazon Redshift data warehouse. The company has established a VPN connection between the on-premises database and AWS. The on-premises database is continuously updated. The company must ensure that the data in Amazon Redshift is updated as quickly as possible. Which solution will meet these requirements?

  • AUse the pg_dump utility to generate a backup of the PostgreSQL database. Use the AWS Schema Conversion Tool (AWS SCT) to upload the backup to Amazon Redshift. Set up a cron job to perform a backup. Upload the backup to Amazon Redshift every night.
  • BCreate an AWS Database Migration Service (AWS DMS) full-load task. Set Amazon Redshift as the target. Configure the task to use the change data capture (CDC) feature. (correct answer)
  • CUse the pg_dump utility to generate a backup of the PostgreSQL database. Upload the backup to an Amazon S3 bucket. Use the COPY command to import the data into Amazon Redshift.
  • DCreate an AWS Database Migration Service (AWS DMS) full-load task. Set Amazon Redshift as the target. Configure the task to perform a full load of the database to Amazon Redshift every night.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Create an AWS Database Migration Service (AWS DMS) full-load task. Set Amazon Redshift as the target. Configure the task to use the change data capture (CDC) feature.

Explanation

Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries. AWS Config tracks resource configuration changes and evaluates compliance. AWS Database Migration Service migrates databases with minimal downtime.

DEA-C01 Question 214

Single page →
Topic 1 · Question 214

A company has several new datasets in CSV and JSON formats. A data engineer needs to make the data available to a team of data analysts who will analyze the data by using SQL queries. Which solution will meet these requirements in the MOST cost-effective way?

  • ACreate an Amazon RDS MySQL cluster. Use AWS Glue to transform and load the CSV and JSON files into database tables. Provide the data analysts access to the MySQL cluster.
  • BCreate an AWS Glue DataBrew project that contains the new data. Make the DataBrew project available to the data analysts.
  • CStore the data in an Amazon S3 bucket. Use an AWS Glue crawler to catalog the S3 bucket as tables. Create an Amazon Athena workgroup that has a data usage threshold. Grant the data analysts access to the Athena workgroup. (correct answer)
  • DLoad the data into Super-fast, Parallel, In-memory Calculation Engine (SPICE) in Amazon QuickSight. Allow the data analysts to create analyses and dashboards in QuickSight.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Store the data in an Amazon S3 bucket. Use an AWS Glue crawler to catalog the S3 bucket as tables. Create an Amazon Athena workgroup that has a data usage threshold. Grant the data analysts access to the Athena workgr...

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. AWS Glue is a serverless ETL and data-catalog service that prepares and integrates data. This option delivers the requirement at the lowest cost.

DEA-C01 Question 215

Single page →
Topic 1 · Question 215

A retail company stores order information in an Amazon Aurora table named Orders. The company needs to create operational reports from the Orders table with minimal latency. The Orders table contains billions of rows, and over 100,000 transactions can occur each second. A marketing team needs to join the Orders data with an Amazon Redshift table named Campaigns in the marketing team's data warehouse. The operational Aurora database must not be affected. Which solution will meet these requirements with the LEAST operational effort?

  • AUse AWS Database Migration Service (AWS DMS) Serverless to replicate the Orders table to Amazon Redshift. Create a materialized view in Amazon Redshift to join with the Campaigns table.
  • BUse the Aurora zero-ETL integration with Amazon Redshift to replicate the Orders table. Create a materialized view in Amazon Redshift to join with the Campaigns table. (correct answer)
  • CUse AWS Glue to replicate the Orders table to Amazon Redshift. Create a materialized view in Amazon Redshift to join with the Campaigns table.
  • DUse federated queries to query the Orders table directly from Aurora. Create a materialized view in Amazon Redshift to join with the Campaigns table.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Use the Aurora zero-ETL integration with Amazon Redshift to replicate the Orders table. Create a materialized view in Amazon Redshift to join with the Campaigns table.

Explanation

Amazon Aurora is a high-performance managed relational database with built-in replication and failover. Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries.

DEA-C01 Question 216

Single page →
Topic 1 · Question 216

A company is building a new application that ingests CSV files into Amazon Redshift. The company has developed the frontend for the application. The files are stored in an Amazon S3 bucket. Files are no larger than 5 MB. A data engineer is developing the extract, transform, and load (ETL) pipeline for the CSV files. The data engineer configured a Redshift cluster and an AWS Lambda function that copies the data out of the files into the Redshift cluster. Which additional steps should the data engineer perform to meet these requirements?

  • AConfigure the bucket to send S3 event notifications to Amazon EventBridge. Configure an EventBridge rule that matches S3 new object created events. Set the Lambda function as the target.
  • BConfigure the $3 bucket to send S3 event notifications to an Amazon Simple Queue Service (Amazon SQS) queue. Configure the Lambda function to process the queue. (correct answer)
  • CConfigure AWS Database Migration Service (AWS DMS) to stream new S3 objects to a data stream in Amazon Kinesis Data Streams. Set the Lambda function as the target of the data stream.
  • DConfigure an Amazon EventBridge rule that matches S3 new object created events. Set an Amazon Simple Queue Service (Amazon SQS) queue as the target of the rule. Configure the Lambda function to process the queue.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Configure the $3 bucket to send S3 event notifications to an Amazon Simple Queue Service (Amazon SQS) queue. Configure the Lambda function to process the queue.

Explanation

AWS Lambda runs code without provisioning servers and scales automatically, which minimizes operational overhead. Amazon S3 provides durable, scalable object storage that is fully managed. Amazon SQS is a fully managed message queue that decouples components and absorbs traffic spikes.

DEA-C01 Question 217

Single page →
Topic 1 · Question 217

A company stores sensitive data in an Amazon Redshift table. The company needs to give specific users the ability to access the sensitive data. The company must not create duplication in the data. Customer support users must be able to see the last four characters of the sensitive data. Audit users must be able to see the full value of the sensitive data. No other users can have the ability to access the sensitive information. Which solution will meet these requirements?

  • ACreate a dynamic data masking policy to allow access based on each user role. Create IAM roles that have specific access permissions. Attach the masking policy to the column that contains sensitive data. (correct answer)
  • BEnable metadata security on the Redshift cluster. Create IAM users and IAM roles for the customer support users and the audit users. Grant the IAM users and IAM roles permissions to view the metadata in the Redshift cluster.
  • CCreate a row-level security policy to allow access based on each user role. Create IAM roles that have specific access permissions. Attach the security policy to the table.
  • DCreate an AWS Glue job to redact the sensitive data and to load the data into a new Redshift table.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: Create a dynamic data masking policy to allow access based on each user role. Create IAM roles that have specific access permissions. Attach the masking policy to the column that contains sensitive data.

Explanation

An IAM role grants temporary, least-privilege permissions to AWS resources without long-term credentials. AWS IAM controls authenticated and authorized access to AWS resources with fine-grained policies.

DEA-C01 Question 218

Single page →
Topic 1 · Question 218

A data engineer uses AWS Lake Formation to manage access to data that is stored in an Amazon S3 bucket. The data engineer configures an AWS Glue crawler to discover data at a specific file location in the bucket, s3://examplepath. The crawler execution fails with the following error: “The S3 location: s3://examplepath is not registered.” The data engineer needs to resolve the error. Which solution will meet this requirement?

  • AAttach an appropriate IAM policy to the IAM role of the AWS Glue crawler to grant the crawler permission to read the S3 location.
  • BRegister the S3 location in Lake Formation to allow the crawler to access the data. (correct answer)
  • CCreate a new AWS Glue database. Assign the correct permissions to the database for the crawler.
  • DConfigure the S3 bucket policy to allow cross-account access.
Reveal answer & explanation
Correct answer: B

The correct answer is B. Option B: Register the S3 location in Lake Formation to allow the crawler to access the data.

Explanation

Amazon S3 provides durable, scalable object storage that is fully managed. AWS Lake Formation builds and secures data lakes quickly.

DEA-C01 Question 219

Single page →
Topic 1 · Question 219

A company built a data lake and a data warehouse on AWS. The company wants to implement a data catalog to enhance the current data storage solutions. The company wants to have the capability to add business metadata and glossary information to the data catalog for every asset. Which solution will meet these requirements with the LEAST operational overhead?

  • AUse AWS Glue Catalog. Create a user table for the business glossary. Use the AWS Glue API to change table properties to add business metadata. Create a web application to access the metadata.
  • BUse an Apache Hive metastore. Create a user table for the business glossary. Use the ALTER TABLE command to change table properties to add business metadata. Create a web application to access the metadata.
  • CUse Amazon DataZone. Create the business glossaries. Create metadata forms. Use the Amazon DataZone data portal to access the metadata. (correct answer)
  • DUse Amazon OpenSearch Service. Create an index for the business glossary. Create a second index for the business metadata. Use the OpenSearch Service dashboard to access the metadata.
Reveal answer & explanation
Correct answer: C

The correct answer is C. Option C: Use Amazon DataZone. Create the business glossaries. Create metadata forms. Use the Amazon DataZone data portal to access the metadata.

DEA-C01 Question 220

Single page →
Topic 1 · Question 220

A data engineer is using an AWS Glue ETL job to remove outdated customer records from a table that contains customer account information. The data engineer is using the following SQL command to remove customers that exist in a table named monthly_accounts_update table from the customer accounts table: MERGE INTO accounts t USING monthly_accounts_update s ON t.customer = s.customer - WHEN MATCHED - THEN DELETE - What will happen when the data engineer runs the SQL command?

  • AAll customer records that exist in both the customer accounts table and the monthly_accounts_update table will be deleted from the accounts table. (correct answer)
  • BOnly customer records that are present in both tables will be retained in the customer accounts table.
  • CThe monthly_accounts_update table will be deleted.
  • DNo records will be deleted because the command syntax is not valid in AWS Glue.
Reveal answer & explanation
Correct answer: A

The correct answer is A. Option A: All customer records that exist in both the customer accounts table and the monthly_accounts_update table will be deleted from the accounts table.

Explanation

Amazon RDS is a managed relational database that handles patching, backups and failover.

Showing questions 201–220 of 313 · Page 11 of 16