← Back to exam page

SAA-C03 – AWS Certified Solutions Architect - Associate (SAA-C03)

Loading demo links...

Showing 7–9 of 20 questions

Question 7 (Exam Pool C)

A company hosts a three-tier web application that includes a PostgreSQL database The database stores the metadata from documents The company searches the metadata for key terms to retrieve documents that the company reviews in a report each month The documents are stored in Amazon S3 The documents are usually written only once, but they are updated frequency The reporting process takes a few hours with the use of relational queries The reporting process must not affect any document modifications or the addition of new documents.

What are the MOST operationally efficient solutions that meet these requirements? (Select TWO )

Select all that apply, then click Submit answer.

  • ○

    Set up a new Amazon DocumentDB (with MongoDB compatibility) cluster that includes a read replica Scale the read replica to generate the reports.
  • ○

    Set up a new Amazon RDS for PostgreSQL Reserved Instance and an On-Demand read replica Scale the read replica to generate the reports
  • ○

    Set up a new Amazon Aurora PostgreSQL DB cluster that includes a Reserved Instance and an Aurora Replica issue queries to the Aurora Replica to generate the reports.
  • ○

    Set up a new Amazon RDS for PostgreSQL Multi-AZ Reserved Instance Configure the reporting module to query the secondary RDS node so that the reporting module does not affect the primary node
  • ○

    Set up a new Amazon DynamoDB table to store the documents Use a fixed write capacity to support new document entries Automatically scale the read capacity to support the reports
Question 8 (Exam Pool C)

A solutions architect is implementing a document review application using an Amazon S3 bucket for storage. The solution must prevent accidental deletion of the documents and ensure that all versions of the documents are available. Users must be able to download, modify, and upload documents.

Which combination of actions should be taken to meet these requirements? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Enable a read-only bucket ACL.
  • ○

    Enable versioning on the bucket.
  • ○

    Attach an IAM policy to the bucket.
  • ○

    Enable MFA Delete on the bucket.
  • ○

    Encrypt the bucket using AWS KMS.
Question 9 (Exam Pool B)

A company wants to measure the effectiveness of its recent marketing campaigns. The company performs batch processing on csv files of sales data and stores the results «i an Amazon S3 bucket once every hour. The S3 bi petabytes of objects. The company runs one-time queries in Amazon Athena to determine which products are most popular on a particular date for a particular region Queries sometimes fail or take longer than expected to finish.

Which actions should a solutions architect take to improve the query performance and reliability? (Select TWO.)

Select all that apply, then click Submit answer.

  • ○

    Reduce the S3 object sizes to less than 126 MB
  • ○

    Partition the data by date and region n Amazon S3
  • ○

    Store the files as large, single objects in Amazon S3.
  • ○

    Use Amazon Kinosis Data Analytics to run the Queries as pan of the batch processing operation
  • ○

    Use an AWS duo extract, transform, and load (ETL) process to convert the csv files into Apache Parquet format.