Lab 2-8

How is data modified and extracted from datacenters? Select a Choice Below current question choices OptionA By using grid computing OptionB By using Internet protocol version 6 OptionC By using mobile databases OptionD By using pervasive business intelligence

Some companies move their relational database (for instance a reporting database residing in MS SQL server) to Hadoop ecosystem. a. Do some web search and find out why do companies do that? b. What do they gain from that? c. Is it wise to do so? d. What is the upside and what is the downside?

1. Which of the following use cases are suitable for S3? (select all that apply) a. Data analytics and processing b. Distribution of content c. Cloud services and applications d. Managing relational data e. Static web hosting f. Mobile and gaming applications   2. What are benefits of using Amazon Elastic Block Store (Amazon EBS) as a block storage solution? (Select TWO) a. Data warehouse b. Data availability c. Data latency d. Data encryption   3. What is NOT an Amazon Elastic Block Store (Amazon EBS) volume type? a. General purpose HDD b. Provisioned IOPS SSD c. Throughput optimized HDD   4. You are processing a workload that can stop and start without warning, and does not need to run in a specific time frame. Which type of instance would provide the most cost savings for this workload? a. Pay-as-you-go instance b. Reserved Instance c. On-Demand Instance d. Spot Instance   5. Which Amazon Elastic Compute Cloud (Amazon EC2) instance state does NOT allow you to reconnect to that…

1. Which of the following use cases are suitable for S3? (select all that apply) a. Data analytics and processing b. Distribution of content c. Cloud services and applications d. Managing relational data e. Static web hosting f. Mobile and gaming applications   2. When you launch an EC2 instance, the chosen AMI will determine characteristics of the instance, such as: (select all that apply) a. The operating system b. Root device storage c. The architecture d. The uptime and downtime e. Launch permissions   3. Which of the following can be performed within a VPC (select all that apply): a. create security groups b. create VPNs c. manage networks in the VPC d. configure IP address ranges

Read the original whitepaper by Vogels et al. https://www.allthingsdistributed.com/files/amazon-dynamo-sosp2007.pdf  What are the goals? What are the system assumptions? What is an SLA?  Why are they important?  Why design for the 99th percentile instead of the average? Does Dynamo favor Availability or Consistency? How does Dynamo detect membership and recover from lost nodes? What are some lessons learned?

For questions below, use the following nested data structure to answer the questions.  social_network = {'bb_dawg$': ('Barry Bowden', 18, ['New York City NY', 'Langley VA'], ['Elisa Yang', 'Andrew Yamins', 'James Butler']),                  'yo_jimbo2000': ('James Butler', 21, ['Boston MA'], ['Barry Bowden']),                  'e_yan2002': ('Elisa Yan', 20, ['College Park MD', 'Clarksburg MD'], ['Andrew Yamins', 'Barry Bowden']),                  'bmansford1990': ('Benard Mansford', 31, ['San Jose CA', 'College Park MD'], []),                  'derp1234': ('who cares', 99, ['College Park MD'], [])}     Q1) Notice that a removed user ('Andrew Yamins') is still contained in the friends list of a few users. Write a few lines of code to remove him from those friends lists in the social network. Q2) Write a short Python function called find_user_lived that takes a string as input along with the social network data structure; the string should be a city and state and the function should…

Table 1: Past Payment Status History à Credit Points Conversion TablePast Payment Status Credit Points-2 to 0   =           5 points1 to 2    =           4 points3 to 4    =          3 points5 to 6     =         2 points7 and above  =  1 point How do I do an excel formula for a cell that have a score of -2 to 0 with 5 points, or 1 to 2 with 4 points, etc.

Question related to Amazon web service.   Online transaction processing (OLTP) captures, stores, and processes data from transactions in real time. True or False?

In database: Which of the following is not an advantage of cloud computing? Chose: • Elasticity . Security (potential) . Scalability

The following are the necessary tables for a Bank Database   customer table: | customer_id | customer_name | customer_street | customer_city |+-------------+---------------+-----------------+---------------+| C-101       | Jones         | Main            | Harrison      || C-201       | Smith         | North           | Rye           || C-211       | Hayes         | Main            | Harrison      || C-212       | Curry         | North           | Rye           || C-215       | Lindsay       | Park            | Pittsfield    || C-220       | Turner        | Putnam          | Stamford      || C-222       | Williams      | Nassau          | Princeton     || C-225       | Adams         | Spring          | Pittsfield    || C-226       | Johnson       | Alma            | Palo Alto     || C-233       | Glenn         | Sand Hill       | Woodside      || C-234       | Brooks        | Senator         | Brooklyn      || C-255       | Green         | Walnut          | Stamford…

Value from big data can be….. Select one: a. Scalable infrastructures b. Profits c. Technical ability d. Veracity   which one is the answer ?

1. Question 1   The worksheet contains the following data: What will be the result of the formula =CONCAT(B2:D2)?   1 point     HSBC,Shanghai,China     #VALUE!     HSBC, Shanghai, China

MySQL help needed please! 1. What is the Average, Minimum, and Maximum of borrowings (Gross Approval) in each state (BorrState)?   2. How much was borrowed (Gross Approval) per capita (Population in 2015) in each state (Borr State)?   3. How much was borrowed (Gross Approval) in each state (BorrState)?   SQL link: https://drive.google.com/file/d/1-vNu2wxEJZ-VxLysB1ojSzHgQvNlCfsk/view?usp=sharing.

This is  I'm uploading second time. Kindly give me minimum 300 words. Three characteristics of Geospatial data? Note: Give me briefly answer(minimum 300 words) don't copy from Google

Which function of the S&P Capital IQ Excel plug-in allows users to extract company data directly from CapIQ’s database and calculate the desired financial metrics using the CapIQ formulas?

Think of one example where big data can make an impact.  (Search on the https://data.gov.ph/ ) Describe the example in the following way. A. What industry sector is it? B. What is the business problem? C. How do you think big data can help?. D. What is the business value of such a big data solution? E. What kind of data source will be used?

What are the benefits, drawbacks, and potential future advances of storing data on the cloud? Give some instances of companies that operate on the cloud and offer a variety of solutions.

which responsibility still applies to all organizations using a cloud service provider, nomatter the jurisdiction?A. Maintenance of database schemasB. Encryption of data at restC. Patching and maintenance of systemsD. Governance of the data

A database system uses an Apache web server, WebLogic Application server and an Oracle database. Draw a 3-tier architecture for this system. Use Internet to identify the latest versions of the above-mentioned software to use in your architecture diagram.Note: For an upvote, plz do not copy paste answers from online sources

You will be proving IT service recommendation for GoldStar Bank. The bank is helping companies to transaction for the customers who holds their credit card ( GoldStar Bank Credit Card). Please consider the following parameters: The Bank’s has one Data Center where it keeps all customer data transactions. GoldStar Bank Data Center in a building in NYC, There are five floors. GoldStar Bank has only one building in NYC where all employee computers are connected to each other and the main database via INTRANET. GoldStar Bank Data center has the computing power to process 5000,000 customers a day. Customer accounts are based on Client- Server Process within the GoldStar Bank. All users (the employees of GoldStar Bank) will be connected the Customer Accounts database via secure INTRANET. All company computers are client commuters, and they will be connected to the Database ( the server) via secure INTRANET.   The Bank’s database can be accessed remotely by the companies. Currently, there…

For this simple analysis, the sample set is provided for you. You just need to answer the questions below.   To develop a strategy for reducing urban footprints, we need to know where to focus our efforts. Use the sample set of cities in this study (https://www.footprintnetwork.org/2017/02/18/city-footprints-data-action/) to answer the following questions:   1. For cities with the smallest overall footprints, was the transportation footprint usually smaller as well?   2. For cities with the smallest overall footprints, was the food footprint consistently smaller?   3. For cities with the smallest footprints, was the "goods" category (non-food consumption) generally smaller?   4. This question involves a rarely-noticed metric: government. Did the footprint of governments correlate with the overall footprints of these cities? In other words, if the overall footprint was less, was the government footprint correspondingly less?   5. Based on these data, in what category would you propose…