NoSQL MCQ Questions Answers

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

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

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?

4. You need to select a NoSQL database for heavy aggregate query workloads. Which type do you choose?

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?

6. You need to create a scalable database that supports immutable writes. What do you use?

7. Which command do you use to add a value to a Redis stream named mystream?

8. Which statement accurately describes global secondary indexes in DynamoDB?

9. Which method shows you whether MongoDB uses any indexes when running a query, and how the indexes are used?

10. You want to return a list of all elements in two Redis sets. Which keyword do you use?

11. You need to generate a unique, sequential identifier for each value stored in a Redis cluster. What do you do?

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

13. Database availability is measured by which metric?

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

15. You need to store an unordered collection of name-value pairs with differing data types in DynamoDB. Which data type should you choose?

16. What is the recommended size for Redis keys?

17. You need to execute a command for MongoDB that does NOT load values from the .mongorc.js file. What do you do ?

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?

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

20. SQL databses and NoSQL are which types of scalable?

21. Which two types of indexes are available in Cosmos DB?

22. You want to connect a DynamoDb stream to an AWS lamdba function. Which one of these object do you create.

23. You need to create a pub/sub server. Which databse do you use?

24. To bulk load data into Amazon Neputn, what do you do?

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

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

27. You are designing a MongoDB schema to support queries that will include lookups. What should you do?

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?

29. Polyglot storage mean using multiple types of what in the same application?

30. Ou need to control your application's batch updates destination for your Bigtable multinode cluster. Which action do you take?

31. You need multi-item ACID transactions with snapshot isolation within a partition for your cloud-based application. Which NoSQL databse do you choose?

32. Which statement is preferred Cypher code for Neo4j?

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?

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?

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?

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

37. You need to design the primary key for DynamoDB based on three attributes. What do you do?

38. Which two characteristics define Amazon Quantum Ledger Database?

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

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

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

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

43. What does redis use to sort the elements of a sorted set?

44. What is recommended size for Redis keys?

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

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

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

48. You want to connect a DynamoDB stream to AWS Lambda function?

49. Which types of indexes are available in CosmosDB?