Aws Data Engineer Test 8 – SynergisticIT

Which services would satisfy the company‘s requirements (SELECT TWO)?

Select 2 option(s):

Which option would you suggest for the MOST cost-effective solution for storing the raw data?

Select 1 option(s):

Which of the following statements are true regarding views in this context (SELECT TWO)?

Select 2 option(s):

Select 1 option(s):

Which solution will meet these requirements with the LEAST operational overhead?

Select 1 option(s):

Which of the following services would provide the best solution to capture the clickstream events from the source and also provide a feed of the data stream to the downstream applications?

Select 1 option(s):

Which AWS service supports creating checks on datasets?

Select 1 option(s):

As a Certified Data Engineer, what steps would you suggest to the engineering team (SELECT THREE)?

Select 3 option(s):

Select 1 option(s):

Which Athena feature allows for the use of Apache Spark?

Select 1 option(s):

Which of the following statements would best satisfy the company‘s needs?

Select 1 option(s):

As a Certified Data Engineer, what would be the most cost-efficient way to structure the Glue ETL job?

Select 1 option(s):

Which of the following solutions would best meet the requirements?

Select 1 option(s):

Select 1 option(s):

Which of the following statements is INCORRECT regarding file formats?

Select 1 option(s):

Select 1 option(s):

Which AWS service will help the company monetize their data with the LEAST operational overhead?

Select 1 option(s):

Which of the following solutions aligns best with the described requirements?

Select 1 option(s):

As a Certified Data Engineer, can you instruct the company what feature AWS Lake Formation does NOT support?

Select 1 option(s):

Select 1 option(s):

Which of the following monitoring view should the data engineer look into for solving the task?

Select 1 option(s):

Select 2 option(s):

Select 1 option(s):

Given these requirements, which AWS Lambda data storage option is most suitable for this scenario?

Select 1 option(s):

Which is the most cost-effective way of storing the videos for the given use case?

Select 1 option(s):

What type of crawler is NOT supported by AWS Glue?

Select 1 option(s):

Which of the following architectures should the investment firm adopt to ingest the data with the LEAST development time and cost?

Select 1 option(s):

Which steps should be taken to guarantee the dashboard data is always up-to-date while still maintaining low query times with the LEAST operational overhead?

Select 1 option(s):

How can the data analyst meet this requirement with the LEAST development time?

Select 1 option(s):

Which of the following options will NOT help fix the issue (SELECT TWO)?

Select 2 option(s):

Which AWS service should the company consider for meeting these requirements?

Select 1 option(s):

Which of the following encryption mechanism is most suitable for these requirements, allowing the company to achieve their goal with the LEAST operational overhead?

Select 1 option(s):

How can the developer ease the maintenance of the Lambda functions following best practices with the LEAST operational overhead?

Select 1 option(s):

What is the correct approach for configuring the Amazon S3 location path?

Select 1 option(s):

What is the most efficient method for storing this data on S3 to achieve optimal performance when processing millions of data points on a daily basis?

Select 1 option(s):

Which services should the engineer use for storage and processing for the LEAST costs and operational overhead (SELECT TWO)?

Select 2 option(s):

Which of the following statements regarding Amazon Macie are true (SELECT THREE)?

Select 3 option(s):

{
“movie_id“: 147,
“title“: “Forrest Gump“,
“directory“: “Robert Zemeckis“,
“genre“: “Drama“
}
Which of the following AWS Glue DataBrew recipes is the most suitable for the described conversion?

Select 1 option(s):

Which combination of steps should the engineer take to achieve their goal with the LEAST costs?

Select 1 option(s):

As a Certified Data Engineer, which of the following are antipatterns for AWS Glue (SELECT TWO)? 

Select 2 option(s):

Which of the following services would allow orchestrating the ETL workflow with the LEAST operational overhead and costs?

Select 1 option(s):

Which of the following statements are considered best practice when working with DynamoDB?

Select 2 option(s):

As an AWS Certified Data Engineer, which of the following solutions do you recommend to achieve this task with the LEAST operational overhead?

Select 1 option(s):

How should the engineer update the schema of the Data Catalog table with the LEAST operational overhead?

Select 1 option(s):

{
“Version“: “2012-10-17“,
“Statement“: [
{
“Sid“:“Sid0“,
“Action“: [
“redshift:*“
],
“Effect“: “Allow“,
“Resource“: “arn:aws:redshift:us-west-2:*“
},
{
“Sid“:“Sid1“,
“Action“: [
“redshift:Delete*“
],
“Effect“: “Deny“,
“Resource“: “arn:aws:redshift:us-west-2:*“
}
]
}

Select 1 option(s):

Which state should they use for such a step in the workflow graph?

Select 1 option(s):

How many RCU should the engineer provision for the table?

Select 1 option(s):

As a Certified Data Engineer, which of the following statements are INCORRECT regarding DataBrew (SELECT TWO)?

Select 2 option(s):

Which of the following settings is a requirement to implement the requested tracking?

Select 1 option(s):

As a Certified Data Engineer, can you instruct the company on what AWS service does NOT have a VPC Interface Endpoint available?

Select 1 option(s):

Select 3 option(s):

s3://my-bucket/dt=2009-04-12/
The engineer queries the newly created table with the following query:
SELECT dt,impressionid FROM impressions WHERE dt > ‘2009-04-12‘
However, the query does not seem to be returning the correct results.
What should the engineer do to resolve their issue?

Select 1 option(s):

Which of the following queries should the engineer run using Athena to achieve their requirements?

Select 1 option(s):

Which of the following options are NOT ideally suited for Redshift (SELECT THREE)?

Select 3 option(s):

Select 2 option(s):

As a Certified Data Engineer, which of the following services is NOT supported by AWS Backup?

Select 1 option(s):

As a Certified Data Engineer, what service would you recommend to the company?

Select 1 option(s):

Which of the following options should first be attempted to resolve their issue?

Select 1 option(s):

Which of the following services can best help the company achieve their requirements?

Select 1 option(s):

Select 2 option(s):