1. What is a popular, open-source key-value store database?
Answer
Correct Answer:
Redis
Note: This Question is unanswered, help us to find answer for this one
2. In DynamoDB, the partition key and sort key are also known as which type of attributes?
Answer
Correct Answer:
Hash, range
Note: This Question is unanswered, help us to find answer for this one
3. 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?
Answer
Correct Answer:
Redis
Note: This Question is unanswered, help us to find answer for this one
4. You need to select a NoSQL database for heavy aggregate query workloads. Which type do you choose?
Answer
Correct Answer:
Columnstore
Note: This Question is unanswered, help us to find answer for this one
5. 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?
Answer
Correct Answer:
MongoDB
Note: This Question is unanswered, help us to find answer for this one
6. You need to create a scalable database that supports immutable writes. What do you use?
Answer
Correct Answer:
A ledger database
Note: This Question is unanswered, help us to find answer for this one
7. Which command do you use to add a value to a Redis stream named mystream?
Answer
Correct Answer:
XADD mystream * sensor-id 1234 temperature 9.8 1518951480106-0
Note: This Question is unanswered, help us to find answer for this one
8. Which statement accurately describes global secondary indexes in DynamoDB?
Answer
Correct Answer:
The global secondary indexes in DynamoDB are eventually consistent, and are not guaranteed to return correct results.
Note: This Question is unanswered, help us to find answer for this one
9. Which method shows you whether MongoDB uses any indexes when running a query, and how the indexes are used?
Answer
Correct Answer:
Explain()
Note: This Question is unanswered, help us to find answer for this one
10. You want to return a list of all elements in two Redis sets. Which keyword do you use?
Answer
Correct Answer:
Smembers
Note: This Question is unanswered, help us to find answer for this one
11. You need to generate a unique, sequential identifier for each value stored in a Redis cluster. What do you do?
Answer
Correct Answer:
Use the INCR keyword to generate a value
Note: This Question is unanswered, help us to find answer for this one
12. You need to encrypt data at rest in DynamoDB. Which action do you take?
Answer
Correct Answer:
None. Data is encrypted by default.
Note: This Question is unanswered, help us to find answer for this one
13. Database availability is measured by which metric?
Answer
Correct Answer:
The number of nines
Note: This Question is unanswered, help us to find answer for this one
14. Which statement retrieves an item from the MusicCollection table in DynamoDB?
Note: This Question is unanswered, help us to find answer for this one
15. You need to store an unordered collection of name-value pairs with differing data types in DynamoDB. Which data type should you choose?
Answer
Correct Answer:
Map
Note: This Question is unanswered, help us to find answer for this one
16. What is the recommended size for Redis keys?
Answer
Correct Answer:
A single bit
Note: This Question is unanswered, help us to find answer for this one
17. You need to execute a command for MongoDB that does NOT load values from the .mongorc.js file. What do you do ?
Answer
Correct Answer:
Use the mongo shell to create a command with --nodedefault option.
Note: This Question is unanswered, help us to find answer for this one
18. 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?
Answer
Correct Answer:
Tables become labels: rows become nodes.
Note: This Question is unanswered, help us to find answer for this one
19. You need to create a scalable database that allows you to query data nodes and edges efficiently. What do you use?
Answer
Correct Answer:
A graph database
Note: This Question is unanswered, help us to find answer for this one
20. SQL databses and NoSQL are which types of scalable?
Answer
Correct Answer:
Vertically, horizontally
Note: This Question is unanswered, help us to find answer for this one
21. Which two types of indexes are available in Cosmos DB?
Answer
Correct Answer:
Secondery and primary key
Note: This Question is unanswered, help us to find answer for this one
22. You want to connect a DynamoDb stream to an AWS lamdba function. Which one of these object do you create.
Answer
Correct Answer:
DynamoDB trigger
Note: This Question is unanswered, help us to find answer for this one
23. You need to create a pub/sub server. Which databse do you use?
Answer
Correct Answer:
Redis
Note: This Question is unanswered, help us to find answer for this one
24. To bulk load data into Amazon Neputn, what do you do?
Answer
Correct Answer:
Upload data to S3 VPC endpoint, Use the Neptun loader to load from s3 into your Neptune instance
Note: This Question is unanswered, help us to find answer for this one
25. For your mobile application, you need to select a Google cloud databse that can support compound, filtered document queries. Which do you choose?
Answer
Correct Answer:
Cloud Firestore
Note: This Question is unanswered, help us to find answer for this one
26. What is the aggregation operator for a join concept in MongoDB?
Answer
Correct Answer:
$lookup
Note: This Question is unanswered, help us to find answer for this one
27. You are designing a MongoDB schema to support queries that will include lookups. What should you do?
Answer
Correct Answer:
Create a multicolumn index on the key value used as the foreign key and the most unique column in the document.
Note: This Question is unanswered, help us to find answer for this one
28. 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?
Answer
Correct Answer:
The queried key value does not exist.
Note: This Question is unanswered, help us to find answer for this one
29. Polyglot storage mean using multiple types of what in the same application?
Answer
Correct Answer:
Storage systems
Note: This Question is unanswered, help us to find answer for this one
30. Ou need to control your application's batch updates destination for your Bigtable multinode cluster. Which action do you take?
Answer
Correct Answer:
Update the default app profile to route the natch update from that client.
Note: This Question is unanswered, help us to find answer for this one
31. You need multi-item ACID transactions with snapshot isolation within a partition for your cloud-based application. Which NoSQL databse do you choose?
Answer
Correct Answer:
Cosmos DB
Note: This Question is unanswered, help us to find answer for this one
32. Which statement is preferred Cypher code for Neo4j?
Answer
Correct Answer:
MATCH (:Person)-->(vehicle:Car)-->(:Company) RETURN count(vehicle)
Note: This Question is unanswered, help us to find answer for this one
33. You need to design security for DynamoDB to allow users read-obly access to certain items and attriutes in a table. What do you do?
Answer
Correct Answer:
Use IAM plicy conditions.
Note: This Question is unanswered, help us to find answer for this one
34. You need to create a scalable databse that allows you to share documents across authorized mobile clients in real time. What Google NoSQL database should you use?
Answer
Correct Answer:
Firebase
Note: This Question is unanswered, help us to find answer for this one
35. Your startup is building a prototype that has an evolving schema. Your data will be eventually consistent. Your application is hosted in AWS. Which databse do you choose?
Answer
Correct Answer:
DynamoDB
Note: This Question is unanswered, help us to find answer for this one
36. Which of these data types should you avoid in designing a Google Bigtable row key?
Answer
Correct Answer:
Frequently updated identifiers
Note: This Question is unanswered, help us to find answer for this one
37. You need to design the primary key for DynamoDB based on three attributes. What do you do?
Answer
Correct Answer:
Concatenate all three fields into one new field, then designate that new field as the primary key.
Note: This Question is unanswered, help us to find answer for this one
38. Which two characteristics define Amazon Quantum Ledger Database?
Answer
Correct Answer:
Document data model; transactionally consistent with ACID semantics.
Note: This Question is unanswered, help us to find answer for this one
39. You are doing data modelling for Google BigTable. Which statement expresses if and when you should split entities across multiple rows?
Answer
Correct Answer:
Split entities across multiple rows if the entity data is over thousands of MBs, or if it does not need atomic updates and reads.
Note: This Question is unanswered, help us to find answer for this one
40. You need to implement the simplest possible scalable, in-memory cache for your AWS application. Which service do you select?
Answer
Correct Answer:
Elasticache using Redis.
Note: This Question is unanswered, help us to find answer for this one
41. Polyglot storage means using multiple types of what in the same application?
Answer
Correct Answer:
Query systems.
Note: This Question is unanswered, help us to find answer for this one
42. You need to change the shard key of an existing MongoDB collection. What do you do?
Answer
Correct Answer:
Dump the collection data, drop the collection, presplit the data, create a new collection and shard key, import the data.
Note: This Question is unanswered, help us to find answer for this one
43. What does redis use to sort the elements of a sorted set?
Answer
Correct Answer:
Keys.
Note: This Question is unanswered, help us to find answer for this one
44. What is recommended size for Redis keys?
Answer
Correct Answer:
Short
Note: This Question is unanswered, help us to find answer for this one
45. You need to create a document database that supports database triggers. Which NoSQL database should you use?
Answer
Correct Answer:
DynamoDB
Note: This Question is unanswered, help us to find answer for this one
46. You want to test HBASE on your laptop using the fewest number of steps. What do you do?
Answer
Correct Answer:
Set up HBASE in pseudo-distributed mode.
Note: This Question is unanswered, help us to find answer for this one
47. To index a field that holds an array value in MongoDB, which index type do you create?
Answer
Correct Answer:
Multikey
Note: This Question is unanswered, help us to find answer for this one
48. You want to connect a DynamoDB stream to AWS Lambda function?
Answer
Correct Answer:
DynamoDB trigger
Note: This Question is unanswered, help us to find answer for this one
49. Which types of indexes are available in CosmosDB?
Answer
Correct Answer:
Range and spatial
Note: This Question is unanswered, help us to find answer for this one
