The company operates during normal working hours in

This preview shows page 27 - 30 out of 32 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Systems Analysis and Design in a Changing World
The document you are viewing contains questions related to this textbook.
Chapter 14 / Exercise 1
Systems Analysis and Design in a Changing World
Jackson/Satzinger
Expert Verified
You are developing the data platform for a global retail company. The company operates during normal working hours in each region. The analytical database is used once a week for building sales projections. Each region maintains its own private virtual network. Building the sales projections is very resource intensive are generates upwards of 20 terabytes (TB) of data.
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Systems Analysis and Design in a Changing World
The document you are viewing contains questions related to this textbook.
Chapter 14 / Exercise 1
Systems Analysis and Design in a Changing World
Jackson/Satzinger
Expert Verified
The safer , easier way to help you pass any IT exams.Microsoft Azure SQL Databases must be provisioned. - Database provisioning must maximize performance and minimize cost - The daily sales for each region must be stored in an Azure SQL Database instance - Once a day, the data for all regions must be loaded in an analytical Azure SQL Database instance You need to provision Azure SQL database instances. How should you provision the database instances? To answer, drag the appropriate Azure SQL products to the correct databases. Each Azure SQL product may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:Explanation:Box 1: Azure SQL Database elastic pools SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources at a set price. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database. Box 2: Azure SQL Database Hyperscale A Hyperscale database is an Azure SQL database in the Hyperscale service tier that is backed by the Hyperscale scale-out storage technology. A Hyperscale database supports up to 100 TB of data and provides high throughput and performance, as well as rapid scaling to adapt to the workload requirements. Scaling is transparent to the application connectivity, query processing, and so on, work like any other SQL database.
28/ 31
The safer , easier way to help you pass any IT exams.
29/ 3131.You are the data engineer tor your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. Developers need to access data in the database using an API. You need to determine which API to use for the database model and type. Which two APIs should you use? Each correct answer presents a complete solution. NOTE: Each correct selection s worth one point.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture