Exam-Answer

Home / Microsoft / AZ-303 / Question 96

Prev Question
Next Question

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:

Answers



A B C D

Advertisement

Explanation

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

References

Comments

Load more
Prev Question
Next Question