Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

Amazon Redshift Assessment Test

Topics Covered

  • Data Warehouse
  • Sort Key
  • Data Migration
  • Custer Query 
  • Query Performance
  • Admin Scripts

Useful for hiring

  • Amazon Redshift Database Developer
  • Amazon Database Services SDE
  • Amazon Redshift
  • Amazon Redshift Software Development Engineer

Start hiring job-fit candidates using this assessment

GET A DEMO

"Interview Mocha has provided UNEECOPS with a veritable assessment platform with a comprehensive test library, online test platform, and intelligent reports. This made it easier for us to map different job openings with job-fit candidates and recruit faster."

Nisha Chandila, UNEECOPS,
Talent Acquisition Manager
Question

You have been given a CSV file that gets updated frequently. You have to move data from this CSV file to Redshift as and when a new entry is encountered. You have created an event in s3 to invoke a Lambda function whenever a PUT operation takes place. This Lambda function runs a Glue job which is responsible for shifting the data. When you put some data in s3, you are not able to see any addition in the Redshift table. Which command can help you to view in redshift to see what did the glue job exactly do?

Answer
    • STL_LOAD_COMMITS

    • STL_COMMIT_STATS

    • STL_CONNECTION_LOG

    • STL_ANALYZE

Question

You have a data warehouse maintained at AWS Redshift. The data volume and velocity both have increased lately. One option is to keep scaling the cluster horizontally at the expanse of a higher cost of course. Which of the following archiving options are available for you to query the entire data as usual (maybe with a compromise in the querying time) but with a low or no additional cost?

Note: There can be multiple correct answers to this question.

Answer
    • Ensure all tables have compression SELECT * FROM svv_table_info;.
      Maximize compression by changing large tables to use ENCODE zstd.
       

    • Ensure all tables have compression SELECT * FROM table_info;.
      Maximize compression by changing large tables to use ENCODE.
       

    • Switch small tables < ~100k rows (depends) to DISTSTYLE ALL (yes this saves space!).
      Switch from SSD based nodes (ds2) to HDD nodes (dc2) which have more 16x storage space.
       

    • Switch small tables < ~50k rows (depends) to DISTSTYLE ALL (yes this saves space!).
      Switch from SSD based nodes (dc2) to HDD nodes (ds2) which have more 8x storage space.
       

Question

Your client wanted you to integrate the cloudwatch with the Amazon Redshift. You told him that currently Cloudwatch is not supported by Redshift. Meanwhile, there is a third party software which can serve the purpose. Which third party software serve this purpose and which API will use to push Redshift matrics?

Answer
    • Software name is Dynatrace cluster, custom metrics API

    • Software name is Zabbix, custom metrics API

    • Software name is Nagios, Default metrics API

    • Software name is Zabbix, Default metrics API

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO