Question: 298
You have data in a tabular format as shown in the following table.
Of which type of data is this an example?
You need to recommend a data store service that meets the following requirements:
Native SQL API access
Configurable indexes
What should you recommend?
Azure Cosmos DB comes with native Core (SQL) API support.
In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy can be overridden with your own custom indexing policy.
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-indexing-policy
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization.
You have a SQL query that combines customer data and order dat
a. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query. What should you create?
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
https://docs.microsoft.com/en-us/sql/relational-databases/views/views
