You are planning to create a new Azure Cosmos DB account for an existing application.
The application runs the following queries:
CREATE KEYSPACE app
WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy', 'datacenter1' : 1 };
CREATE TABLE IF NOT EXISTS app.users (
user_id int PRIMARY KEY,
user_name text,
user_age int,
user_bcity text
);
SELECT user_name, occupation AS user_occupation FROM app.users WHERE user_age > 40;
You need to create the Cosmos DB account for the application.
Choose all that apply:
You can use Cassandra API to store data for applications written for Apache Cassandra. Apache Cassandra uses a SQL-like query language named Cassandra Query Language (CQL). Cassandra stores data in tables, where the data schema is defined. Those tables are grouped in a keyspace that defines options to all the tables, such as the replication strategy to use.
You can use the SQL API to query data that use SQL-like statements like SELECT. However, you cannot use SQL statements like CREATE to create a container.
You cannot use SQL-like statements to query a graph database. You should use the Gremlin query language to query data from a Cosmos DB Gremlin API graph database:
g.V().hasLabel('users').has('user_age', gt(40))
You cannot use SQL-like statements to query from a document database. You should use MongoDB queries to query data from Cosmos DB MongoDB API:
db.users.find({user_age: {$gt: 40}})