AWS Data Engineer Associate - Test 14

The AWS Data Engineer DEA-C01 mock test is an excellent way to validate your knowledge of AWS data services. It demonstrates your ability to design pipelines, manage ETL processes, and optimize storage solutions. Employers respect certifications, but they expect more than exam readiness. To get hired, you need proficiency in visualization tools like Power BI and Tableau, querying languages like SQL, and statistical platforms such as SAS. Data engineering skills in Snowflake, Databricks, and PySpark are critical for managing pipelines. On top of that, data science and AI expertise in TensorFlow, PyTorch, LLMs, and Generative AI are increasingly required. Modern roles blend data analysis, engineering, and AI, demanding versatility.

The SynergisticIT Data Science Job Placement Program ensures you go beyond certification, equipping you with advanced skills, project work, and interview preparation. Explore more opportunities through the SynergisticIT Job Placement Program.

Welcome to your AWS Data Engineer Associate – Test-14

Name

Phone

Q1. A data analyst is using Amazon QuickSight to create visualizations for a sales report. They notice some inconsistencies in the dataset, such as missing values and incorrect data entries. What should the analyst do within QuickSight to address these data quality issues before finalizing the visualizations?

Select 1 option(s):

Use QuickSight‘s ML Insights to automatically correct inconsistencies and missing values.

Apply QuickSight‘s data preparation features to filter out or modify inconsistent data.

Implement AWS Glue DataBrew jobs to clean the data before importing it into QuickSight.

Configure Amazon Redshift data quality features to clean the data before analysis in QuickSight.

Q2. A data engineering team is using AWS Lambda to automate the process of verifying and cleaning data files as they are uploaded to an Amazon S3 bucket. The files need to be checked for completeness and consistency. Which approach should the team take to implement this process?

Select 1 option(s):

Trigger a Lambda function on S3 PUT events to validate and clean the data.

Use AWS Step Functions to periodically scan the S3 bucket and clean the data.

Set up Amazon CloudWatch to monitor the S3 bucket and trigger data cleaning in Lambda.

Implement Amazon Redshift Spectrum to query the data in S3 and validate its integrity.

Q3. A data engineering team is configuring S3 Access Points to simplify managing access to shared datasets in S3 buckets. They need to enforce specific access policies for different departments within the company. How should they apply IAM policies in this scenario?

Select 1 option(s):

Create an IAM user for each department and apply IAM policies directly to these users.

Attach IAM policies to the S3 buckets and use bucket policies to differentiate access.

Associate IAM policies with each S3 Access Point to control access for different departments.

Implement Network Access Control Lists (NACLs) for each department to manage S3 access.

Q4. A company stores transaction data in Amazon S3 and plans to use Amazon Athena for analysis. The data engineer discovers that some transaction records are incomplete. Which approach should be taken to exclude these incomplete records from Athena queries?

Select 1 option(s):

Implement Amazon S3 Object Lambda to automatically repair incomplete records.

Use Athena queries with WHERE clauses to filter out records with missing fields.

Configure an AWS Glue ETL job to transform and clean the data before querying with Athena.

Schedule an AWS Data Pipeline task to remove incomplete records from the S3 dataset.

Q5. An organization has multiple AWS Lambda functions that interact with various AWS services. They want to ensure that each Lambda function has only the permissions necessary to perform its specific tasks. What is the best practice for implementing this authorization method?

Select 1 option(s):

Attach individual IAM policies directly to each Lambda function.

Create a single IAM role with broad permissions and use it for all Lambda functions.

Utilize Amazon Cognito to manage permissions for each Lambda function.

Implement IAM roles with the principle of least privilege and associate each role with the respective Lambda function.

Q6. An organization is using Amazon Redshift for data warehousing. A data analyst needs to write a query that lists each customers total number of orders and the average order value, grouped by the customers city. Assuming the relevant table is orders with columns customer_id, city, and order_value, which query achieves this?

Select 1 option(s):

Q7. A digital marketing company wants to process clickstream data in real-time. The data is ingested via Amazon Kinesis and needs to be processed by a series of AWS Lambda functions before being stored in Amazon DynamoDB. Which AWS service should they use to orchestrate this serverless workflow?

Select 1 option(s):

Amazon EC2

AWS Step Functions

Amazon RDS

Amazon Redshift

Q8. A company stores sensitive data in an Amazon S3 bucket and utilizes AWS Lambda for data processing. They need to ensure that only the Lambda function can access this specific S3 bucket. Which method provides the most secure approach to protect the data from unauthorized access?

Select 1 option(s):

Enable server-side encryption on the S3 bucket with an AWS managed key.

Apply an S3 bucket policy that allows access only from the specific Lambda function‘s ARN.

Use Network Access Control Lists (NACLs) to restrict access to the S3 bucket.

Implement an IAM user with exclusive read and write permissions to the S3 bucket and use it in the Lambda function.

Q9. You are working on a data engineering project where you need to provision and configure AWS resources for a data pipeline. You want to use Infrastructure as Code (IaC) for repeatable deployments. Which AWS service allows you to define your infrastructure using a familiar programming language like TypeScript or Python and provision AWS resources with CloudFormation?

Select 1 option(s):

AWS Lambda

AWS Glue

AWS Cloud Development Kit (AWS CDK)

AWS Step Functions

Q10. A company wants to automate a complex ETL pipeline that includes various AWS services like Lambda for data processing and Amazon S3 for data storage. They need a service to manage and orchestrate these different tasks in a specific sequence. Which AWS service is most suitable for building and managing this workflow?

Select 1 option(s):

AWS Step Functions

Amazon EC2

Amazon Redshift

Amazon Kinesis

Q11. A data engineer is working with Amazon EMR to process a large dataset, but the cluster repeatedly fails. What is the most effective method to identify the cause of the failures?

Select 1 option(s):

Immediately increase the size of the EMR cluster.

Review the EMR cluster logs in Amazon S3.

Switch the processing to AWS Lambda functions.

Disable logging to improve cluster performance.

Q12. A company wants to establish a data catalog to manage and organize metadata for various data sources including Amazon S3, RDS, and DynamoDB. The catalog should allow data discovery, searchability, and governance. Which AWS service should they use to create this data catalog?

Select 1 option(s):

AWS Glue Data Catalog

Amazon Athena

Amazon Redshift

AWS DataSync

Q13. A company operates critical data pipelines for its e-commerce platform, and downtime is not acceptable during peak shopping seasons. Which AWS service should be used to build highly available data pipelines to ensure uninterrupted data processing?

Select 1 option(s):

AWS Lambda

Amazon EC2

AWS Glue

Amazon Data Pipeline

Q14. A financial institution is implementing a data cataloging system. They need to classify data based on sensitivity and compliance requirements, such as personal identifiable information (PII) and financial transaction records. Which approach should they take for effective data classification in their catalog?

Select 1 option(s):

Apply a uniform security policy across all data.

Classify data based on volume and velocity

Implement tag-based classification for sensitivity and compliance

Use data deduplication techniques for classification.

Q15. An enterprise plans to analyze a variety of log files stored in different formats in Amazon S3. They need to understand the structure of these files to effectively process and analyze them. What is the most efficient way to automatically identify the schema and data types of these log files and catalog them for analysis?

Select 1 option(s):

Use AWS Glue Crawlers

Implement Amazon S3 Select

Deploy Amazon EMR

Utilize Amazon QuickSight

Q16. You are developing a CI/CD (Continuous Integration and Continuous Delivery) pipeline for your data analytics project. To ensure data quality and reliability, you want to implement automated testing of SQL queries used for data transformations. Which AWS service can you use to automate the testing of SQL queries in your pipeline?

Select 1 option(s):

AWS Glue ETL

Amazon Redshift

AWS Lambda

Amazon S3

Q17. When establishing a data catalog in an organization, which component of metadata is essential for enhancing data discovery and usability, especially in a scenario involving diverse data sets from different departments?

Select 1 option(s):

Data Lineage

Data Volume Metrics

Data Processing Logs

Data Source Descriptions

Q18. A healthcare research organization needs to catalog a vast amount of data, including patient records, clinical studies, and genomic data. They must classify this data to ensure appropriate access controls and privacy standards are maintained. What should be their primary focus for data classification in the catalog?

Select 1 option(s):

Classify data based on the size of datasets.

Focus on the format of data (structured or unstructured).

Classify data based on privacy and regulatory requirements.

Organize data based on the source of data generation.

Q19. A company stores customer data in an Amazon DynamoDB table. They want to use an AWS service to periodically verify the data for duplication and remove any duplicate entries. Which AWS service is most appropriate for this task?

Select 1 option(s):

Configure Amazon QuickSight to detect and report duplicate entries.

Use AWS Glue DataBrew for data cleaning and deduplication.

Schedule an AWS Lambda function to scan the table and remove duplicates.

Apply Amazon Athena queries to identify and delete duplicate records.

Q20. A company wants to expose its product catalog, stored in Amazon DynamoDB, through a RESTful API to allow third-party vendors to access the latest product information. Which AWS service combination is most appropriate to create and manage this data API?

Select 1 option(s):

Amazon EC2 and Amazon RDS

AWS Lambda and Amazon API Gateway

Amazon S3 and AWS Glue

Amazon Kinesis and Amazon Redshift

Q21. A company is using AWS PrivateLink to securely connect their VPC to services hosted in another VPC. They need to ensure that only specific IAM roles within their VPC can access these services. How should they apply IAM policies in this context?

Select 1 option(s):

Attach IAM policies directly to the PrivateLink endpoint allowing access to the specified roles.

Create IAM policies for each service and apply them to the VPC endpoints for AWS PrivateLink.

Implement Network Access Control Lists (NACLs) to restrict access to the services through PrivateLink.

Configure IAM roles with policies that grant access to the services and associate these roles with the VPC endpoints.

Q22. An entertainment company wants to migrate their large video library from an on-premises data center to Amazon S3. The migration should be fast, secure, and minimize operational disruption. The company also requires the ability to automate and schedule the data transfer process. Which AWS service is best suited for this requirement?

Select 1 option(s):

AWS Snowball

AWS Transfer Family

AWS DataSync

Amazon Glacier

Q23. A healthcare organization is building data pipelines to process patient health records. Data availability and reliability are critical for regulatory compliance. Which AWS service can help ensure data availability and reliability in this scenario?

Select 1 option(s):

AWS Data Pipeline

Amazon Kinesis

Amazon S3

AWS Step Functions

Q24. In an AWS environment, a data scientist is using a Jupyter Notebook to explore a large dataset hosted in Amazon S3. The dataset has some records with incorrectly formatted dates. What is the most effective way for the data scientist to correct these date formats directly in the Jupyter Notebook?

Select 1 option(s):

Utilize Amazon Redshift SQL commands within the notebook to reformat the dates.

Implement Python code in the notebook using the datetime library to parse and correct date formats.

Use AWS Data Pipeline to transform and correct the date formats before analysis in the notebook.

Apply AWS Lambda functions from within the notebook to modify the date formats in the dataset.

Q25. A data engineering team is setting up AWS infrastructure for different projects. They want to ensure that team members working on Project A have access only to the AWS resources related to Project A, and similarly for Project B. What is the most effective way to implement this role-based access control considering the expected access patterns?

Select 1 option(s):

Grant all team members administrative access and rely on trust to ensure they access only their project resources.

Create IAM roles specific to each project with policies granting access only to the resources required for that project.

Use a single IAM role for all team members and define resource-based policies on each AWS resource.

Implement Network Access Control Lists (NACLs) to segregate network traffic based on the project.

Q26. A data processing system in your organization relies on real-time data from an external service. You want to be notified immediately if there are any issues with receiving this data. Which AWS service should you use to send real-time alerts in this scenario?

Select 1 option(s):

Amazon S3

AWS Lambda

Amazon SNS (Simple Notification Service)

AWS Glue

Q27. When analyzing sales data in Amazon QuickSight, a data engineer discovers that the dataset has duplicate entries, affecting the accuracy of the analysis. What is the most efficient approach within QuickSight to eliminate these duplicates for accurate reporting?

Select 1 option(s):

Utilize QuickSight‘s calculated field feature to identify and exclude duplicate entries.

Configure an AWS Lambda function to remove duplicates from the dataset in Amazon S3.

Apply Amazon Athena to the dataset in S3 to remove duplicates before analysis in QuickSight.

Use AWS Glue DataBrew to preprocess and deduplicate the data before importing it into QuickSight.

Q28. A data engineering team is using Amazon SageMaker Data Wrangler for cleaning a dataset that contains numerous missing values and outliers. Which feature should they primarily utilize within Data Wrangler to efficiently handle these issues?

Select 1 option(s):

Use the built-in feature engineering capabilities to automatically replace missing values and remove outliers.

Implement custom SQL queries within Data Wrangler to identify and handle missing values and outliers.

Apply AWS Glue DataBrew transformations within Data Wrangler to manage missing values and outliers.

Configure Amazon QuickSight from Data Wrangler to visualize and manually clean the data.

Q29. You are building a CI/CD (Continuous Integration and Continuous Delivery) pipeline for your data engineering project. As part of the pipeline, you need to implement automated testing to ensure the quality and correctness of your data transformations. Which AWS service can you use to automate the testing of your data pipelines?

Select 1 option(s):

AWS Data Pipeline

AWS Glue ETL

AWS Lambda

AWS CodePipeline

Q30. A company is setting up IAM policies for their team members who are managing AWS resources. One of the team members is responsible for managing only Amazon S3 buckets. In line with the principle of least privilege, how should the companys AWS administrator set up this team members IAM policy?

Select 1 option(s):

Grant full administrative access to ensure they can perform all necessary tasks on AWS.

Provide access restricted to only Amazon S3 with the necessary permissions to manage the buckets.

Assign read-only access to all AWS services to prevent unintended modifications.

Use an IAM managed policy for S3 that includes additional permissions for Amazon EC2, to cover potential future needs.

Q31. A data analyst wants to use an AWS service to visualize and explore data interactively without writing code. The analyst needs to clean, normalize, and visualize the data for preliminary analysis. Which AWS service is most suitable for these requirements?

Select 1 option(s):

AWS Glue DataBrew

Amazon QuickSight

Amazon Athena

AWS Data Pipeline

Q32. A healthcare organization needs to catalog their diverse set of data assets, including patient records, clinical trials, and research data, to enable efficient data management and compliance with regulatory standards. What AWS service should they use to create a central data catalog for these purposes?

Select 1 option(s):

AWS Lake Formation

Amazon S3

Amazon DynamoDB

AWS Glue Data Catalog

Q33. A multinational company needs to analyze data that is stored across different databases, including Amazon RDS and Aurora, without moving the data into a central repository. The analysis should combine data from these various sources. Which AWS service enables this kind of data integration and analysis?

Select 1 option(s):

Amazon S3

Amazon Redshift with Federated Query

AWS Glue

Amazon DynamoDB

Q34. A mobile application company requires a database to store user profiles and session data. The database needs to provide fast and consistent read/write access, scale automatically based on demand, and handle large volumes of small transactions. Which AWS service is most appropriate for this requirement?

Select 1 option(s):

Amazon RDS

Amazon Redshift

Amazon DynamoDB

Amazon S3

Q35. An analytics team needs to perform complex queries on their PostgreSQL database hosted on-premises and combine the results with their Amazon Redshift data warehouse. The solution should allow querying the on-premises database without migrating the data to the cloud. Which AWS service should be used?

Select 1 option(s):

AWS DataSync

AWS Direct Connect

Amazon Redshift with Federated Query

Amazon RDS

Q36. A media company needs to transcode video files as soon as they are uploaded to an Amazon S3 bucket. The transcoded files should then be stored in a different S3 bucket. What is the most efficient way to implement this process using an event-driven architecture?

Select 1 option(s):

Use Amazon RDS to trigger a Lambda function for transcoding.

Configure S3 Event Notifications to trigger an AWS Lambda function for transcoding.

Implement Amazon EC2 Auto Scaling to handle video transcoding.

Deploy Amazon Kinesis Data Firehose for real-time transcoding.

Q37. You are tasked with implementing a CI/CD (Continuous Integration and Continuous Delivery) pipeline for a data processing application on AWS. The pipeline should automatically build, test, and deploy your application when changes are pushed to the source code repository. Which AWS service can you use to achieve this?

Select 1 option(s):

Amazon S3 (Simple Storage Service)

AWS Lambda

AWS CodePipeline

Amazon Redshift

Q38. A healthcare organization needs to securely provide access to patient health records, stored in Amazon RDS, to authorized external healthcare providers via an API. Which AWS service should they primarily use to implement secure and controlled access to the data through an API?

Select 1 option(s):

Amazon Kinesis Data Firehose

Amazon RDS

Amazon API Gateway

Amazon S3

Q39. An organization needs to catalog their large datasets stored in various formats across Amazon S3, Amazon Redshift, and external Hive Metastore for a unified view and efficient querying. Which AWS service should be used to create a data catalog that allows seamless consumption of data from these diverse sources?

Select 1 option(s):

AWS DataSync

AWS Glue Data Catalog

Amazon RDS

Amazon QuickSight

Q40. A healthcare organization needs to aggregate patient data from various sources, process the data using AWS Lambda, and then load the processed data into an Amazon S3 bucket. The entire process should be serverless and triggered whenever new data is available. Which AWS service combination is most suitable for this requirement?

Select 1 option(s):

AWS Data Pipeline and Amazon EC2

Amazon EMR and Amazon Redshift

AWS Lambda and Amazon S3 with AWS Step Functions

Amazon Kinesis Data Firehose and Amazon RDS

Q41. A financial services company needs to regularly transfer large amounts of sensitive financial data files from their on-premises servers to AWS, ensuring secure data transfer and compatibility with existing SFTP-based workflows. Which AWS service should they use to integrate into their data processing system for this purpose?

Select 1 option(s):

AWS DataSync

AWS Transfer Family

Amazon S3

AWS Direct Connect

Q42. A data engineering team requires fine-grained access control for an Amazon S3 bucket, where different team members need access to specific prefixes within the bucket. The existing AWS managed policies are too broad for their requirements. What should the team do to implement the required access control?

Select 1 option(s):

Use a managed policy for Amazon S3 and restrict access by implementing Network Access Control Lists (NACLs).

Create custom IAM policies that specify access to the particular S3 bucket prefixes and attach them to the respective team members.

Assign IAM users to each team member, giving them full S3 access, and rely on them to only access their specific prefixes.

Implement AWS Organizations Service Control Policies (SCPs) to restrict access at the organizational level.

Q43. A company needs to create an ETL pipeline that extracts data from various sources, transforms it, and loads it into an Amazon Redshift data warehouse. They also require scheduling and orchestration capabilities for this pipeline. Which combination of AWS services should they use to fulfill these requirements?

Select 1 option(s):

AWS Glue for ETL, Amazon Redshift for data warehousing, and AWS Step Functions for orchestration

Amazon EC2 for ETL, Amazon S3 for data warehousing, and Amazon CloudWatch for orchestration

Amazon Kinesis for ETL, Amazon DynamoDB for data warehousing, and AWS Lambda for orchestration

Q44. A data engineer needs to set up an ETL pipeline that involves extracting data from Amazon RDS, transforming it with AWS Lambda, and then loading the processed data into Amazon Redshift. The process requires scheduling and error handling capabilities. Which AWS service should they use to orchestrate this ETL pipeline?

Select 1 option(s):

Amazon Managed Workflows for Apache Airflow (Amazon MWAA)

AWS Data Pipeline

Amazon S3

Amazon EC2

Q45. A media company needs to store a large collection of high-definition video files for their streaming service. These files will be accessed frequently and need to be delivered with low latency to a global audience. The storage solution should also offer scalability and durability. Which AWS service is the most suitable for this requirement?

Select 1 option(s):

Amazon RDS

Amazon S3

Amazon EBS

Amazon DynamoDB

Q46. A large enterprise is implementing attribute-based access control (ABAC) in their AWS environment to manage access to their Amazon S3 data lake. They want to authorize access based on the department attribute of IAM users. Which approach should they use for this ABAC implementation?

Select 1 option(s):

Configure S3 bucket policies that grant access based on the ‘department‘ attribute in IAM user metadata.

Implement Network Access Control Lists (NACLs) that filter access based on the ‘department‘ attribute of IAM users.

Create IAM policies with conditions that utilize the ‘department‘ attribute to control access to S3 buckets.

Use AWS KMS customer managed keys (CMKs) to encrypt data and grant access based on IAM user ‘department‘ attributes.

Q47. Your organization is building a complex data pipeline that processes large volumes of data. You want to implement a message queue system to decouple the components of the pipeline and ensure reliability. Which AWS service is suitable for implementing this message queue system?

Select 1 option(s):

Amazon S3 (Simple Storage Service)

Amazon SQS (Simple Queue Service)

Amazon SNS (Simple Notification Service)

AWS Lambda

Q48. An organization is setting up a multi-account AWS environment. They need to ensure that certain development teams only have access to specific AWS resources in their respective accounts. What is the most appropriate policy-based authorization method to achieve this?

Select 1 option(s):

Utilize AWS Resource Access Manager (RAM) to share resources between accounts with specified policies.

Create and apply IAM policies within each account that define the specific resource access for each team.

Configure Network Access Control Lists (NACLs) with policies to restrict team access to certain resources.

Q49. A retail organization wants to ingest customer data from an online transaction system into Amazon S3, process the data using AWS Glue, and then load it into Amazon Redshift for analysis. Which AWS service should they use to automate and manage the execution of these steps in sequence?

Select 1 option(s):

AWS Data Pipeline

Amazon EC2 Auto Scaling

Amazon EMR

Amazon Kinesis Data Streams

Q50. In a data catalog, what component of metadata is essential for ensuring compliance with data governance policies and regulations, especially in industries like healthcare and finance?

Select 1 option(s):

Data Access Patterns

Data Security Classifications

File Format Types

Data Storage Locations

Q51. A company wants to process data whenever a new file is uploaded to an Amazon S3 bucket. The processing involves transforming the data and then loading it into an Amazon DynamoDB table. Which AWS service combination should be used to implement this event-driven architecture effectively?

Select 1 option(s):

Amazon EC2 and Amazon RDS

Amazon Kinesis and Amazon Redshift

AWS Lambda and Amazon S3

AWS Step Functions and Amazon EMR

Q52. A company needs to run a daily ETL job in AWS Glue that depends on the successful completion of a data import job in Amazon RDS. Which AWS service should they use to orchestrate this pipeline, ensuring that the ETL job runs only after the RDS job completion?

Select 1 option(s):

Amazon CloudWatch

Amazon EC2 Auto Scaling

AWS Step Functions

Amazon Kinesis Data Firehose

Q53. A company wants to implement an authorization mechanism where access to AWS resources is controlled based on specific project tags. They plan to apply these tags to various AWS resources like EC2 instances, S3 buckets, and Lambda functions. Which approach should they use to enforce tag-based authorization?

Select 1 option(s):

Create IAM user policies that grant access based on the presence of specific tags on AWS resources.

Use AWS Key Management Service (KMS) to encrypt resources with keys associated with specific tags.

Implement Amazon Cognito user pools and assign resources based on tags.

Q54. A company is integrating data from various sources including Amazon RDS, Amazon S3, and on-premises databases for analytics. They want to manage this data centrally to streamline access and analysis. Which AWS service should they use to build and reference a data catalog for this purpose?

Select 1 option(s):

Amazon Athena

AWS Glue Data Catalog

Amazon Redshift

Amazon DynamoDB

Q55. You are tasked with transforming a dataset stored in a relational database using SQL queries. You need to aggregate the data to calculate the total sales revenue for each product category. Which SQL operation should you use to perform this aggregation?

Select 1 option(s):

SELECT

JOIN

SUM

WHERE

Q56. A data engineer needs to verify and clean a large dataset stored in Amazon S3, which will be queried using Amazon Athena. The dataset contains several duplicate records. What is the most effective way to identify and remove duplicates using Athena?

Select 1 option(s):

Q57. A data engineer is using AWS Jupyter Notebooks for analyzing a dataset stored in Amazon S3. The dataset contains several duplicate records and missing values. What should the engineer do within the Jupyter Notebook to effectively clean the data?

Select 1 option(s):

Use AWS Glue DataBrew within the notebook to remove duplicates and handle missing values.

Write Python code using pandas to drop duplicate records and fill or remove missing values.

Directly apply Amazon Athena queries in the notebook to eliminate duplicates and missing entries.

Configure Amazon QuickSight from the notebook to visualize and filter out the duplicate data.

Q58. An organization is utilizing AWS PrivateLink to connect to a third-party service. They want to ensure that only designated applications in their AWS environment can access this service. What is the best method to restrict access to the service via PrivateLink?

Select 1 option(s):

Set up Security Groups for the VPC endpoint that allow access only from the designated applications.

Configure IAM user policies to restrict access to the PrivateLink service.

Apply IAM roles to the applications with permissions to access the PrivateLink service.

Implement AWS WAF rules on the PrivateLink endpoint to allow only designated applications.

Q59. A company is using Amazon QuickSight for business intelligence and data visualization. They want to create an interactive dashboard to visualize sales data from an Amazon Redshift cluster. The requirement is to enable end-users to drill down into sales by region and time. Which feature in Amazon QuickSight should be used to meet this requirement?

Select 1 option(s):

Use ML Insights for automatic visual generation.

Implement dashboard filters for region and time.

Create calculated fields to summarize sales by region and time.

Utilize Actions to set up drill-downs based on region and time.

Q60. A data engineering team is using Amazon RDS for database services and Amazon EC2 for application servers. They want to ensure that the database is only accessible from the application servers. What is the most effective authorization mechanism to achieve this?

Select 1 option(s):

Enable AWS IAM database authentication for the Amazon RDS instance.

Set up Security Groups for the RDS instance to allow inbound traffic solely from the EC2 instances.

Implement AWS Shield Advanced to protect the RDS instance from unauthorized access.

Configure an Amazon Cognito user pool for the EC2 instances to access the RDS database.

AWS Data Engineer Associate - Test 14

Q2. A data engineering team is using AWS Lambda to automate the process of verifying and cleaning data files as they are uploaded to an Amazon S3 bucket. The files need to be checked for completeness and consistency. Which approach should the team take to implement this process?

Q3. A data engineering team is configuring S3 Access Points to simplify managing access to shared datasets in S3 buckets. They need to enforce specific access policies for different departments within the company. How should they apply IAM policies in this scenario?

Q4. A company stores transaction data in Amazon S3 and plans to use Amazon Athena for analysis. The data engineer discovers that some transaction records are incomplete. Which approach should be taken to exclude these incomplete records from Athena queries?

Q5. An organization has multiple AWS Lambda functions that interact with various AWS services. They want to ensure that each Lambda function has only the permissions necessary to perform its specific tasks. What is the best practice for implementing this authorization method?

Q7. A digital marketing company wants to process clickstream data in real-time. The data is ingested via Amazon Kinesis and needs to be processed by a series of AWS Lambda functions before being stored in Amazon DynamoDB. Which AWS service should they use to orchestrate this serverless workflow?

Q8. A company stores sensitive data in an Amazon S3 bucket and utilizes AWS Lambda for data processing. They need to ensure that only the Lambda function can access this specific S3 bucket. Which method provides the most secure approach to protect the data from unauthorized access?

Q11. A data engineer is working with Amazon EMR to process a large dataset, but the cluster repeatedly fails. What is the most effective method to identify the cause of the failures?

Q12. A company wants to establish a data catalog to manage and organize metadata for various data sources including Amazon S3, RDS, and DynamoDB. The catalog should allow data discovery, searchability, and governance. Which AWS service should they use to create this data catalog?

Q13. A company operates critical data pipelines for its e-commerce platform, and downtime is not acceptable during peak shopping seasons. Which AWS service should be used to build highly available data pipelines to ensure uninterrupted data processing?

Q17. When establishing a data catalog in an organization, which component of metadata is essential for enhancing data discovery and usability, especially in a scenario involving diverse data sets from different departments?

Q19. A company stores customer data in an Amazon DynamoDB table. They want to use an AWS service to periodically verify the data for duplication and remove any duplicate entries. Which AWS service is most appropriate for this task?

Q20. A company wants to expose its product catalog, stored in Amazon DynamoDB, through a RESTful API to allow third-party vendors to access the latest product information. Which AWS service combination is most appropriate to create and manage this data API?

Q21. A company is using AWS PrivateLink to securely connect their VPC to services hosted in another VPC. They need to ensure that only specific IAM roles within their VPC can access these services. How should they apply IAM policies in this context?

Q23. A healthcare organization is building data pipelines to process patient health records. Data availability and reliability are critical for regulatory compliance. Which AWS service can help ensure data availability and reliability in this scenario?

Q26. A data processing system in your organization relies on real-time data from an external service. You want to be notified immediately if there are any issues with receiving this data. Which AWS service should you use to send real-time alerts in this scenario?

Q27. When analyzing sales data in Amazon QuickSight, a data engineer discovers that the dataset has duplicate entries, affecting the accuracy of the analysis. What is the most efficient approach within QuickSight to eliminate these duplicates for accurate reporting?

Q28. A data engineering team is using Amazon SageMaker Data Wrangler for cleaning a dataset that contains numerous missing values and outliers. Which feature should they primarily utilize within Data Wrangler to efficiently handle these issues?

Q30. A company is setting up IAM policies for their team members who are managing AWS resources. One of the team members is responsible for managing only Amazon S3 buckets. In line with the principle of least privilege, how should the companys AWS administrator set up this team members IAM policy?

Q31. A data analyst wants to use an AWS service to visualize and explore data interactively without writing code. The analyst needs to clean, normalize, and visualize the data for preliminary analysis. Which AWS service is most suitable for these requirements?

Q36. A media company needs to transcode video files as soon as they are uploaded to an Amazon S3 bucket. The transcoded files should then be stored in a different S3 bucket. What is the most efficient way to implement this process using an event-driven architecture?

Q38. A healthcare organization needs to securely provide access to patient health records, stored in Amazon RDS, to authorized external healthcare providers via an API. Which AWS service should they primarily use to implement secure and controlled access to the data through an API?

Q46. A large enterprise is implementing attribute-based access control (ABAC) in their AWS environment to manage access to their Amazon S3 data lake. They want to authorize access based on the department attribute of IAM users. Which approach should they use for this ABAC implementation?

Q47. Your organization is building a complex data pipeline that processes large volumes of data. You want to implement a message queue system to decouple the components of the pipeline and ensure reliability. Which AWS service is suitable for implementing this message queue system?

Q48. An organization is setting up a multi-account AWS environment. They need to ensure that certain development teams only have access to specific AWS resources in their respective accounts. What is the most appropriate policy-based authorization method to achieve this?

Q49. A retail organization wants to ingest customer data from an online transaction system into Amazon S3, process the data using AWS Glue, and then load it into Amazon Redshift for analysis. Which AWS service should they use to automate and manage the execution of these steps in sequence?

Q50. In a data catalog, what component of metadata is essential for ensuring compliance with data governance policies and regulations, especially in industries like healthcare and finance?

Q51. A company wants to process data whenever a new file is uploaded to an Amazon S3 bucket. The processing involves transforming the data and then loading it into an Amazon DynamoDB table. Which AWS service combination should be used to implement this event-driven architecture effectively?

Q52. A company needs to run a daily ETL job in AWS Glue that depends on the successful completion of a data import job in Amazon RDS. Which AWS service should they use to orchestrate this pipeline, ensuring that the ETL job runs only after the RDS job completion?

Q54. A company is integrating data from various sources including Amazon RDS, Amazon S3, and on-premises databases for analytics. They want to manage this data centrally to streamline access and analysis. Which AWS service should they use to build and reference a data catalog for this purpose?

Q55. You are tasked with transforming a dataset stored in a relational database using SQL queries. You need to aggregate the data to calculate the total sales revenue for each product category. Which SQL operation should you use to perform this aggregation?

Q56. A data engineer needs to verify and clean a large dataset stored in Amazon S3, which will be queried using Amazon Athena. The dataset contains several duplicate records. What is the most effective way to identify and remove duplicates using Athena?

Q57. A data engineer is using AWS Jupyter Notebooks for analyzing a dataset stored in Amazon S3. The dataset contains several duplicate records and missing values. What should the engineer do within the Jupyter Notebook to effectively clean the data?

Q58. An organization is utilizing AWS PrivateLink to connect to a third-party service. They want to ensure that only designated applications in their AWS environment can access this service. What is the best method to restrict access to the service via PrivateLink?

Q60. A data engineering team is using Amazon RDS for database services and Amazon EC2 for application servers. They want to ensure that the database is only accessible from the application servers. What is the most effective authorization mechanism to achieve this?

Company

Some Useful Links

Our Services

Oh yeah, we're on social media too!