|Cosmos DB is structured in a hierarchy, starting with the overall account, which can include one or more databases, which contain containers or collections (think entities such as customers or products), which include the individual items (think documents or rows in tables). Certain features and configurations are set at the account level and other are set at the database and/or container levels. Which of the following statements are true? The Cosmos DB API must be set at the account level. If you want to run Cosmos DB under a different API, you need a separate account. Logical partitions, which impact performance, are set at the container level. Autoscale throughput to provide optimal performance is set at the account level. The default data consistency setting is set at the account level.
You are partnering on a technical project with an individual at another company. Even though they do not have access to the Azure portal or your subscription, your director of security has cleared you to give them temporary read-write access to Azure Cosmos DB. By what means can they gain access? Azure Data Studio with a temporary password SQL Server Management Studio (SSMS) with a temporary password Data Explorer on the Azure portal with a temporary key Azure Cosmos Explorer with temporary read-write access.
You have an existing MongoDB database that you want to migrate to Azure Cosmos DB. Which tool is best suited to this task? Cosmos DB Data Migration tool Data Explorer on the Azure portal Azure CLI Azure Storage Explorer mongoexport.
Below are data formats paired with a Cosmos DB API. Select each option where the data format is paired with the correct API. Note: it does not need to be the optimal API, just one that is correct. Key-Value: Table API Key-value: Core/SQL API Wide-Column: Gremlin API Relational data : Core/SQL API JSON documents: Core/SQL API.
Cosmos DB offers multiple APIs (application programming interfaces). Below are scenarios paired with an API. Select the options where the most appropriate API is paired with the given scenario. A new application that collects key-value data in micro-batches from remote sensors: Core/SQL API A new social media application with complex entity-to-entity relationships: Graph/Gremlin API Migration of wide-column (column-family) format data to support an existing application: Cassandra API A new application that's well suited for a document database: MongoDB API The migration of a MySQL database that supports an existing web application: Core/SQL API.
There are many good reasons to migrate existing Azure Table storage data to Cosmos DB using the Table API. For new applications of key-value data, it is better to start on Cosmos DB instead of Azure Table. Which of the following features or benefits are key differentiators of Cosmos DB over Azure Table storage? Manual and automatic failovers to a backup source in case of issues with the primary storage source are supported. Each row in a table can have a different number of columns or different types of columns. Multi-master replication, where every region supports both write and reads, is supported across multiple regions. Query performance takes advantage of indexing on all properties, not just the primary key. The key-value data is organized by logical partitions determined by the data architect.
Which of the following is NOT a Cosmos DB API? Table API MongoDB API Graph API Cassandra Wide-Column (Column-Family) PostgreSQL API.
Which of these statements are true about document databases? Even when a document is regarding the same entity, such as a customer, each document can have different data elements. JSON, XML and Excel are examples of documents one might find in a document database. Relationships between documents are enforced similar to relationships between tables in a relational database. Each document in the database contains all the data related to a single entity, such as a customer.
You are designing a database to back a social media platform for board game enthusiasts. Your database must store metadata about your players, such as age and location, as well as complex relationships such as games they like to play, venues where they go to play, other players they team up with or frequently challenge, their favorite game-related web sites, and so on. Which type of data store best supports this application? Wide-Column Key-Value Graph Document Relational.