NoSQL - Skill Assignment Quiz

Q1. Which types of indexes are available in CosmosDB?

  •  range and spatial
  •  secondary and primary key
  •  secondary and spatial
  •  range and primary key

Q2. You want to connect a DynamoDB stream to AWS Lambda function. Which one of these object do you create?

  •  DynamoDB table
  •  DynamoDB trigger
  •  DynamoDB item
  •  DynamoDB index

Q3. To index a field that holds an array value in MongoDB, which index type do you create?

  •  partial
  •  sparse
  •  compound
  •  multikey

Q4. You want to test HBASE on your laptop using the fewest number of steps. What do you do?

  •  Set up Hadoop in pseudo-distributed mode.
  •  Set up HBASE in local mode.
  •  Set up HBASE in pseudo-distributed mode.
  •  Set up Hadoop in local mode.

Q5. You need to create a document database that supports database triggers. Which NoSQL database should you use?

  •  DynamoDB
  •  BigTable
  •  Redis
  •  MongoDB

Q6. What is recommended size for Redis keys?

  •  medium
  •  short
  •  single bit
  •  long

Q7. What does Redis use to sort the elements of a sorted set?

  •  Scores
  •  Ids
  •  Values
  •  Keys

Q8. You need to change the shard key of an existing MongoDB collection. What do you do?

  •  Dump the collection data, drop the collection, create a new collection and shard key, import the data.
  •  Add second shard key and drop the first shard key.
  •  Dump the collection data, drop the collection, presplit the data, create a new collection and shard key, import the data.
  •  Drop and recreate the shard key.

Q9. Polyglot storage means using multiple types of what in the same application?

  •  Security systems
  •  Database systems
  •  Storage systems
  •  Query systems

Q10. You need to implement the simplest possible scalable, in-memory cache for your AWS application. Which service do you select?

  •  Elasticache using Memcached.
  •  DynamoDB.
  •  DynamoDB Accelerator (DAX).
  •  Elasticache using Redis.

Q11. You are doing data modelling for Google BigTable. Which statement expresses if and when you should split entities across multiple rows?

  •  Keep all information for an entity in a single row. Store related entities in adjacent rows.
  •  Keep all information for an entity in a single row.
  •  Split entities across multiple rows if the entity data is over thousands of MBs, or if it does not need atomic updates and reads.
  •  Split entities across multiple rows if the entity data is over hundreds of MBs, or if it does not need atomic updates and reads.

Q12. Which two characteristics define Amazon Quantum Ledger Database?

  •  Key-value data model; transactionally consistent with ACID semantics.
  •  Document data model; transactionally consistent with ACID semantics.
  •  Key-value data model; transactions with tunable consistency.
  •  Document data model; transactions with tunable consistency.

Q13. Which of these data types should you avoid in designing a Google Bigtable row key?

  •  multi-valued identifiers
  •  string identifiers
  •  timestamps
  •  frequently updated identifiers

Q14. Your startup is building a prototype that has an evolving schema. Your data will be eventually consistent. Your application is hosted in AWS. Which database do you choose?

  •  Neptune
  •  DocumentDB
  •  DynamoDB
  •  Amazon Aurora

Q15. You need to create a scalable database that allows you to share documents across authorized mobile clients in real time. What Google NoSQL database should you use?

  •  Memorystore
  •  Datastore
  •  Firebase
  •  Bigtable

Q16. You need to design security for DynamoDB to allow users read-only access to certain items and attributes in a table. What do you do?

  •  Use IAM roles.
  •  Use IAM policy conditions.
  •  Use a VPC endpoint.
  •  Use IAM policies.

Q17. Which statement is preferred Cypher code for Neo4j?

  •  MATCH (:Person)-->(:Card)-->(:Company) RETURN count(vehicle)
  •  Match (:Person)-->(:Car):(vehicle:Car)-->(:Company) RETURN count(vehicle)
  •  MATCH (:Person)-->(vehicle:Car)-->(:Company) RETURN count(vehicle)
  •  MATCH (:Person)-->(:Card), (vehicle:Car)-->(:Company) RETURN count(vehicle)

Q18. Your query to verify that your Redis key is configured to support expiring user information on a defined interval returns -2, What does this value indicate?

  •  The queried key value expired in the last two seconds.
  •  The queried key value exists, but has no associated expire value.
  •  The queried key value does not exist.
  •  There are two expired keys with this value.

Q19. What is the aggregation operator for a join concept in MongoDB?

  •  $group
  •  $match
  •  $lookup
  •  $project

Q20. For your mobile application, you need to select a Google cloud database that can support compound, filtered document queries. Which do you choose?

  •  Cloud SQL
  •  Cloud Spanner
  •  Cloud Firestore
  •  Cloud Firebase

Q21. To bulk load data into Amazon Neptune, what do you do?

  •  Upload data to S3 VPC endpoint, Use the Neptune loader to load from s3 into your Neptune instance
  •  Ad data to a Kinesis stream, and use the Neptune loader to load from S# into your Neptune instance.
  •  Add data to a Kinesis stream, and create a Kinesis stream VPC endpoint. Use the Neptune loader to load from S3 into your Neptune instance.
  •  Upload data to S Use the Neptune loader to load from S3 into your Neptune instance.

Q22. You need to create a pub/sub server. Which database do you use?

  •  Neo4j
  •  Cassandra
  •  Redis
  •  MyS#### QL

Q23. You need to create a scalable database that allows you to query data nodes and edges efficiently. What do you use?

  •  a relational database
  •  a columnstore database
  •  a document database
  •  a graph database

Q24. You are developing a model for a graph database. Your data will be moved from a relational database into Neo4j. Which of these transformations apply?

  •  Rows become labels: bales become nodes.
  •  Tables become labels: rows become nodes.
  •  Tables become collections: rows become items.
  •  Rows become collections: tables become items.

Q25. Which statement retrieves an item from the MusicCollection table in DynamoDB?

  •  Rows become labels: bales become nodes.
  •  Tables become labels: rows become nodes.
  •  Tables become collections: rows become items.
  •  Rows become collections: tables become items.

Q26. Database availability is measured by which metric?

  •  the amount of service calls
  •  the number of minutes
  •  the amount of service costs
  •  the number of nines

Q27. You need to encrypt data at rest in DynamoDB. Which action do you take?

  •  You assign a default AWS encryption key to your table to encrypt data.
  •  You create an AWS encryption key and assign it to your table to encrypt data.
  •  None. Data is encrypted by default.
  •  You create an AWS encryption key and assign it to your database to encrypt data.

Q28. You need to encrypt data at rest in DynamoDB. Which action do you take?

  •  Implement a SortedSet object to generate a value.
  •  Use the GUID keyword to generate a value.
  •  Implement a List object to generate a value.
  •  Use the INCR keyword to generate a value

Q28. You need to encrypt data at rest in DynamoDB. Which action do you take?

  •  Implement a SortedSet object to generate a value.
  •  Use the GUID keyword to generate a value.
  •  Implement a List object to generate a value.
  •  Use the INCR keyword to generate a value

Q29. You need to create a data store for the catalog for your new ecommerce application. Your company is a startup, so the catalog schema may evolve. Which do you choose?

  •   Implement a SortedSet object to generate a value.
  •  Use the GUID keyword to generate a value.
  •  Implement a List object to generate a value.
  •  Use the INCR keyword to generate a value

Q30. You need to select a columnstore database that enforce built-in data types. You want to add indexes to improve performance for known workloads. Which do you choose?

  •  Cassandra
  •  Bigtable
  •  Redis
  •  HBase

Q31. In DynamoDB, the partition key and sort key are also known as which type of attributes?

  •  range, hash
  •  primary, range
  •  hash, range
  •  range, secondary

Q32. What is a popular, open-source key-value store database?

  •  MongoDB
  •  Redis
  •  MySQL
  •  Cassandra

Q33. You need to create a scalable database to store and query JSON data. What do you use?

  •  a relational database
  •  a document database
  •  a graph database
  •  a ledger database

READY TO GET STARTED?

Are you ready

Let’s Make Something Amazing Together

Get Started

Need help? Contact our experts
Tell us about your project