Overview:
skillcertlabs is an online training provider. They also provide a yearly gaming competition for their students. The competition is held every month in different locations.
Current Environment:
The company currently has the following environment in place:
- The racing cars for the competition send their telemetry data to a MongoDB database. The telemetry data has around 100 attributes.
- A custom application is then used to transfer the data from the MongoDB database to a SQL Server 2017 database. The attribute names are changed when they are sent to the SQL Server database.
- Another application named “skillcertlab workflow” is then used to perform analytics on the telemetry data to look for improvements on the racing cars.
- The SQL Server 2017 database has a table named “cardata” which has around 1 TB of data. “skillcertlab workflow” performs the required analytics on the data in this table. Large aggregations are performed on a column of the table.
Proposed Environment:
The company now wants to move the environment to Azure. Below are the key requirements
- The racing car data will now be moved to Azure Cosmos DB and Azure SQL database. The data must be written to the closest Azure data center and must converge in the least amount of time.
- The query performance for data in the Azure SQL database must be stable without the need of administrative overhead
- The data for analytics will be moved to an Azure SQL Data warehouse
- Transparent data encryption must be enabled for all data stores wherever possible
- An Azure Data Factory pipeline will be used to move data from the Cosmos DB database to the Azure SQL database. If there is a delay of more than 15 minutes for the data transfer, then configuration changes need to be made to the pipeline workflow.
- The telemetry data must be monitored for any sort of performance issues.
- The Request Units for Cosmos DB must be adjusted to maintain the demand while also minimizing costs.
- The data in the Azure SQL Server database must be protected via the following requirements
- Only the last four digits of the values in the column carID must be shown
- A zero value must be shown for all values in the column carWeight
Which of the following should be used as the API for the Cosmos DB account?
Select 1 option(s):