Q1. Which types of indexes are available in CosmosDB?

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

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

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

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

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

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

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

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

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

Q12. Which two characteristics define Amazon Quantum Ledger Database?

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

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

Q15. 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?

Q16. 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?

Q17. 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?

Q18. Which statement is preferred Cypher code for Neo4j?

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

Q20. You need to control your application’s batch updates destination for your Bigtable multinode cluster. Which action do you take?

Q21. 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?

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

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

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

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

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

Q27. SQL databases and NoSQL are which types of scalable?

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

Q29. 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?

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

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

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

Q33. Database availability is measured by which metric?

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

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

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

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

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

reference link:

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

Q40. Which code example completes this statement and creates an index for a MongoDB object named restaurants, sorted ascending by the field name?

var indexCollection = function(db) {return co(function*() {...});};

Q41. Which Cypher code executes the multiquery block?

MATCH (c:Company {name: 'Neo4j'}) RETURN c, MATCH (p:Person) WHERE = 'Jennifer' RETURN p,
MATCH (t:Technology)-[:LIKES]-(a:Person {name: 'Jennifer'}) RETURN t.type;
MATCH (c:Company {name: 'Neo4j'}) RETURN c, MATCH (p:Person) WHERE = 'Jennifer' RETURN p,
MATCH (t:Technology)-[:LIKES]-(a:Person {name: 'Jennifer'}) RETURN t.type
MATCH (c:Company {name: 'Neo4j'}) RETURN c AND MATCH (p:Person) WHERE = 'Jennifer' RETURN p,
AND MATCH (t:Technology)-[:LIKES]-(a:Person {name: 'Jennifer'}) RETURN t.type;
MATCH (c:Company {name: 'Neo4j'}) RETURN c;MATCH (p:Person) WHERE = 'Jennifer' RETURN p;
MATCH (t:Technology)-[:LIKES]-(a:Person {name: 'Jennifer'}) RETURN t.type;

[Explaination:]The correct Cypher code to execute a multiquery block would use commas to separate each query in a single statement. In this case, option B has all the queries separated by commas, making it the correct choice. Option A has the correct queries, but they are separated by “RETURN” which is not correct syntax for multiquery. Option C has an additional “AND” before the second query which is also not correct syntax. Option D has each query separated by semicolons, which would execute them as separate queries, not as a multiquery block.

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

Q43. 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?

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

Q45. 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?

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

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

Q49. Which command gets all documents in a MongoDB datastore where the status equals A or the quantity is less than 30?

store and query JSON

Q50. Benefit of using NoSQL database?

[Explaination:]One of the bendfits of using NoSQL databases is easy schema evolution. NoSQL databases are designed to handle flexible data models, which can be easily modified and updated as the data evolves. This makes it easier to handle changing.

Q51. NoSQL databases are most often referred to as?

[Explaination:]Since this non-relational database design does not require a schema, it offers rapid scalability to manage large and typically unstructured data sets. NoSQL is also type of distributed database, which means that information is copied and stored on various servers, which can be remote or local.