Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

(b) Using IF function, write a formula in cell range D24 to display your recommendation. DaaS should be recommended after you input the formula

Thanks

A
с
D
E
F
1 To ensure employee productivity and security, the organization has decided to implement desktop virtualization for all remote employees.
2 There are two popular solutions. VDI (Virtual desktop infrastructure) and Daas (Desktop as a Service). Citrix and Amazon Workspaces are examples of VDI and DaaS,
8
9
10
11
12
13
→
14
15
16
B
3
4 It would help if you compared VDI and DaaS and recommend a better solution to the management.
5 Table 1 has VDI and DaaS's ratings on the various parameter; the rating is on a scale of 1 to 4, where 1 is least preferred, and 4 is most preferred.
6 Cell range C12:C20 has the weights for the assessment criteria. Range D12:D20 and E12:E20 have the ratings for VDI and DaaS, respectively.
7
(a) Using SUMPRODUCT Function, write a formula in cell range D22 to compute the weighted score of VDI. Copy the formula to cell E22 to calculate Daas' weighted
(b) Using IF function, write a formula in cell range D24 to display your recommendation. Hint: IF the Weighted Score of VDI is more than DaaS, then VDI should be
recommended, else DaaS should be recommended.
17
18
19
20
21
22
23
24
25
VDI is managed by the company itself, hosted and managed on-site or at a colocation facility, while Daas is a managed infrastructure service delivered by a provider
and hosted in their data centers.
Assessment Criteria
Platform Maintenance
Initial Cost
Ongoing Cost
Control
Time to setup
Modification
Dedicated IT Staff
Total Cost of Ownership
Technology Maturity
Weight
Weighted Score
15%
15%
15%
5%
5%
10%
15%
10%
10%
Your Recommendation
Table 1
VDI
1
1
4
4
1
3
1
3
4
2.3
DaaS
4
4
1
2
4
1
4
3
2
2.85
G
Weighted Score
Your Recommendation
H
Sample Answer
DaaS
2.3
J
K
L
M
2.85
N
0
expand button
Transcribed Image Text:A с D E F 1 To ensure employee productivity and security, the organization has decided to implement desktop virtualization for all remote employees. 2 There are two popular solutions. VDI (Virtual desktop infrastructure) and Daas (Desktop as a Service). Citrix and Amazon Workspaces are examples of VDI and DaaS, 8 9 10 11 12 13 → 14 15 16 B 3 4 It would help if you compared VDI and DaaS and recommend a better solution to the management. 5 Table 1 has VDI and DaaS's ratings on the various parameter; the rating is on a scale of 1 to 4, where 1 is least preferred, and 4 is most preferred. 6 Cell range C12:C20 has the weights for the assessment criteria. Range D12:D20 and E12:E20 have the ratings for VDI and DaaS, respectively. 7 (a) Using SUMPRODUCT Function, write a formula in cell range D22 to compute the weighted score of VDI. Copy the formula to cell E22 to calculate Daas' weighted (b) Using IF function, write a formula in cell range D24 to display your recommendation. Hint: IF the Weighted Score of VDI is more than DaaS, then VDI should be recommended, else DaaS should be recommended. 17 18 19 20 21 22 23 24 25 VDI is managed by the company itself, hosted and managed on-site or at a colocation facility, while Daas is a managed infrastructure service delivered by a provider and hosted in their data centers. Assessment Criteria Platform Maintenance Initial Cost Ongoing Cost Control Time to setup Modification Dedicated IT Staff Total Cost of Ownership Technology Maturity Weight Weighted Score 15% 15% 15% 5% 5% 10% 15% 10% 10% Your Recommendation Table 1 VDI 1 1 4 4 1 3 1 3 4 2.3 DaaS 4 4 1 2 4 1 4 3 2 2.85 G Weighted Score Your Recommendation H Sample Answer DaaS 2.3 J K L M 2.85 N 0
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education