Course name : Azure cosmos DB |Course id 58397
1.Referential Integrity is possible through ___ resource property.
_ts
_rid
All the options
_etag
Answer : _rid
2.What can be considered as system resources?
Resources with fixed schema
Resources inbuilt in Azure
Resources controlled with Azure Subscription
All the options
Answer : All the options
3.Database Resource metadata querying follows __.
Strong Consistency
Sessional Consistency
Bounded Staleness
Configurable Consistency like any other resource
Eventual Consistency
Answer: Strong Consistency
4.Dynamic Azure region priority setting can help in __.
All the options
Application Testing
Database Consistency
Database Throughput
Answer: All the options
5.Distribution of data in physical partitions is defined by _.
Partition key
Partition strategy
Partition distribution
Partition policy
Answer: Partition key
6.What can be considered as a container while using SQL API?
Collection
Table
Document
Graph
Answer: Collection
7.Cosmos DB pricing is mainly dependent on __.
Storage
Throughput
Replication
API Selection
Answer: Throughput
8.Multi-model database differs from normal data in the criteria of _.
Availability and configurable consistency
All the options
Global distribution and replication
Multiple data format support
Answer: All the options
9.In case, if you deleted a Cosmos DB database, it must be recovered within _.
30 days
7 days
Can be configured manually
Depends on Database Size
Answer: 30 days
10.Graph Database is supported in Cosmos DB through _.
Graph API
Cypher API
Mongo API
Gremlin API
Answer: Gremlin API
Course name : Azure cosmos DB |Course id 58397
11.Consider a store catalog, fruits have a fruit_id, and the department has department_id.
Department has different fruit_ids linked to it. When query is done with a fruit_id, we can retrieve _.
Department with the fruit_id
Both Department and Fruit
fruit_with fruit_id
Department or fruit must be specified
Answer: Department with the fruit_id
12.Identify the administrative command for MongoDB API among the following options.
logout
update
drop
delete
Answer: Drop
13.Cosmos DB SQL Query results can be generally limited through the operator _.
TOP
MAXIMUM
LIMIT
COUNT
Answer: Top
14.SQL results are by default _.
Materialized to list
Paginated
Single JSON with all the results
SDK dependant
Answer: Paginated
15.UDFs in SQL API are not recommended for ______.
Processing without prefixed indexing queries
Calling through Queries
All the options
Calling through Triggers
Answer: Processing without prefixed indexing queries
16.Cassandra API currently supports __.
Sharding Configuration
All the options
CQL over Wire
Joins
Answer: CQL over Wire
17.Cassandra Tables are directly stored in ___.
Clusters
Key spaces
Columnar tables
All the options
Answer: Key spaces
18.Grouping of entities in Graph DB is _.
Possible with properties
Not possible
Possible with relationships
Possible with labels
Answer: Possible with labels
19.OLTP Fraud Detection can be enabled in a simple way using _.
Gremlin API
Mongo DB API
Cassandra API
Table API
Answer: Gremlin API
20.Table API Storage is similar to that of _.
None of the options
Redis
Couch DB
MySQL
Answer: Redis
Course name : Azure cosmos DB |Course id 58397
21.Azure Functions and Azure Cosmos DB can be a part of larger big data pipelines with the help of _
Azure HD Insight
Azure Data Factory
Azure DevOps
Azure AI
Answer: Azure DevOps
22.Querying in SQL API is similar to SQL and is based on?
All the options
Properties
Complex objects
Document identifiers
Answer: All the options
23.Which of the following can be considered as a competetor for Azure Cosmos DB __
All the options
IBM Db2
Google Cloud Bigtable
Amazon DynamoDB
Answer: All the options
24.__ is used to generate predictions using Machine Learning models and web services.
Azure Spark
Azure Cognitive services
Azure Functions
Azure Machine Learning
Answer: Azure Spark
25.Cosmos DB uses _ format to return results from Gremlin operations?
All the options
GSON
JSON
GraphSON
Answer: GraphSON
26.Which of the following azure cli command to update default consistency level of the database is correct
az cosmosdb update — name — resourcegroup –dcl Cannot update consistency level az cosmosdb update -- name --resourcegroup consistency-level
az cosmosdb update –name –resourcegroup –default-consistency-level
Answer: az cosmosdb update –name –resourcegroup –default-consistency-level
27.What is the maximum document size that you can insert, read, replace in a collection?
2 KB
Unlimited
2 MB
2 GB
Answer: 2 MB
28.Distribution of data in physical partitions is defined by _
Partition Policy
Partition Strategy
Partition Distribution
Partition key
None of the options
Answer: Partition Key
29.In Graph DB Friends of Friends can be derived from _
Second Degree traversal
Cannot be defined
Third Degree traversal
First degree traversal
Answer: Third Degree traversal
30.In SQL API, cross partition queries can be optimized through tuning __
Prefetching buffer
Sequential buffer
Partition keys
Degree of parallelism
Answer: Partition keys
Course name : Azure cosmos DB |Course id 58397
31.Table API data items can be queried using a combination of __
Sharding Key and Partition Key
Sharding Key and Row Key
Sharding Key and Unique Key
Partition Key and Row Key
Answer: Partition Key and Row Key
32.The throughput billing of cosmos DB is based on
Only Read and write operations
All the options
Number of Requested units
CRUD operations
Answer: All the options
33.Write operation that is performed on all replicas is considered as __ consistency?
Eventual
Bounded Staleness
Strong
Session
Answer: Bounded Staleness
34.UDFs in Cosmos DB can be written in __.
JavaScript
SQL
All the options
PL/SQL
Python
U-SQL
Answer: JavaScript
35.What type of attachment can be stored in Cosmos DB stores _
Any of the options
Metadata and Blob
Blob/Media upto 2GB
Metadatand Media Reference
Answer: Blob/Media upto 2GB
36.What is/are the advanced feature supported by SQL API?
Geospatial data
Change feed
Is not supported
Both change feed and geo spatial data
Answer: Both change feed and geo spatial data
37._ protocol is a standard to query any data using an HTTP endpoint.
Odata
Vdata
Scope of user key
Oproto
TableData
Answer: Odata
38.Edges in Graph DB _____.
Are mandatory
All the options
Require two vertices
Require properties
Answer: Require two vertices
39.In SQL API, Malicious server-side programmability w.r.t stored procedures is avoided through _
Authentication keys
Multi-tenacy
Bounds
All the options
Answer: Bounds
40.Indexing overhead affects __.
Read performance
Storage performance
All the options
None of the options
Write performance
Answer: All the options
You May Follow US On YouTube For Azure Cosmos DB Video Course
Telegram For Azure Cosmos DB PDF File
Our Blogs For New Courses like Azure Cosmos DB
