placeholder image to represent content

Study Group Database 14.03.2019

Quiz by Robin d.

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
4 questions
Show answers
  • Q1
    You have created a Redshift cluster without encryption, and now your security team wants you to encrypt all the data. How do you achieve this?
    Unload the data from the existing cluster and reload it to a new cluster with encryption on.
    Run the command encrypt cluster from a SQL prompt on a Redshift client.
    It is simple. Just change the settings of the cluster and make it encrypted. All the data will be encrypted.
    Encrypt the application that is loading data in Redshift; that way, all the data will already be encrypted.
    120s
  • Q2
    Your company is generating a huge volume of data sets with billions of rows that must be summarized by columns. You are going to use Tableau on top of this data set to build daily and weekly reports. Which AWS service should you use to meet the requirement?
    Amazon Redshift
    Amazon DynamoDB
    Amazon RDS
    ElastiCache
    120s
  • Q3
    You are running your mission-critical production database using a multi-AZ architecture in Amazon RDS with PIOPS. You are going to add some new functionality; therefore, you need to clone the database and give it to the developers so that they can start working on the new functionality. What can you do to minimize the cost?
    Use a single AZ & Don’t use PIOPS.
    Create a read replica and give the developers the read replica.
    Create a read replica and give the developers the read replica & Don’t use PIOPS.
    Use multiple AZs.
    120s
  • Q4
    You are designing a highly scalable and available web application, and you are using EC2 instances along with Auto Scaling to host the web application. You want to store the session state data in such a way that it should not impact Auto Scaling. What service could you use to store the session state data?
    Amazon DynamoDB & Amazon ElasticCache
    All
    Amazon DynamoDB & Amazon ElasticCache & Amazon EC2
    Amazon DynamoDB & Amazon ElasticCache & Amazon RDS
    120s

Teachers give this quiz to your class