QUESTION 12 John is runnig his Database application on a single server with 24 G

Question

QUESTION 12

John is runnig his Database application on a single server with 24 Gigabytes of memory and 4 processors. The system is running slow during peak hours and the diagnostic logs indicated that the system is running low on memory. John requested for additional memory of 8 Gigabytes to be added to the server to address the problem. What is the resultant type of scaling that John is expecting?

QUESTION 13

QUESTION 12 0.625 points Save Answer John is runnig his Database application on a single server with 24 Gigabytes of memory and 4 processors. The system is running slow during peak hours and the diagnostic logs indicated that the system is running low on memory. John requested for additional memory of 8 Gigabytes to be added to the server to address the problem. What is the resultant type of scaling that John is expecting? A. Horizontal or Scale Out B. Exponential Scaling C.Veritival or Scale Up D. Liner Scaling QUESTION 13 0.65 points Save Answer You are using a Document Database for your Order Analytics System. The database is organized as Customer Number as the Key and rest of the information related to the orders of the customer as Document. Your Sales Manager requested you to provide the list of Customers who bought the product called "XYZ." You have realized that the attribute "PRODUCT" is in the Document section of the data. Identify the best possible action that you could take to address this requirement. Redesign the data structure so that it becomes PRODUCT centric Create an Index on PRODUCT so that the search for the customers who bought a specific product runs faster Create an index on CUSTOMER NUMBER so that the search for the customers runs faster Scan the complete database to identify the customers who bought the product.

Explanation / Answer

12. Answer: vertical scaling

  Explanation:

Vertical scaling means that you scale by adding more power (CPU, RAM) to an existing machine.Here more GB is added (8GB) to the server to address the problem.So vertical sclaing is the resultant type john is expecting.

13. Answer: create index on PRODUCT so that the search for the customers who bought specific product runs faster

Explanation:

An index is used to speed up the performance of queries. It does this by reducing the number of database data pages that have to be visited/scanned.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.