Home / Microsoft / AZ-303 / Question 96

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:

• A. Create a Cosmos DB account with SQL API.

• B. Create a Cosmos DB account with Gremlin API.

• C. Create a Cosmos DB account with Cassandra API.

• D. Create a Cosmos DB account with MongoDB API.

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}})

Introduction to the Azure Cosmos DB Cassandra API

Quickstart: Build a Cassandra app with .NET Core and Azure Cosmos DB

Tutorial: Create a Cassandra API account in Azure Cosmos DB by using a Java application to store key/value data

Tutorial: Query data from a Cassandra API account in Azure Cosmos DB

Data Definition