Transcript Introductions to Packet Capture and Intrusion Detection Prevention Systems You are a network analyst on the fly-away team for the FBI's cybersecurity sector engagement division. You've been deployed several times to financial institutions to examine their networks after cyberattacks, ranging from intrusions and data exfiltration to distributed denial of services to their network supporting customer transaction websites. A representative from the Financial Services Information Sharing and Analysis Center, FS-ISAC, met with your boss, the chief net defense liaison to the financial services sector, about recent reports of intrusions into the networks of banks and their consortium. He's provided some of the details of the reports in an email. "Millions of files were compromised, and financial officials want to know who entered the networks and what happened to the information. At the same time, the FS-ISAC has seen extensive distributed denial of service disrupting the bank's networks, impacting the customer websites, and blocking millions of dollars of potential transactions," his email reads. You realize that the impact from these attacks could cause the downfall of many banks and ultimately create a strain on the US economy. In the email, your chief asks you to travel to one of the banks and using your suite of network monitoring and intrusion detection tools, produce two documents—a report to the FBI and FS-ISAC that contains the information you observed on the network and a joint network defense bulletin to all the banks in the FS-ISAC consortium, recommending prevention methods and remediation against the types of malicious traffic activity that they may face or are facing. Network traffic analysis and monitoring help distinguish legitimate traffic from malicious traffic. Network administrators must protect networks from intrusions. This can be done using tools and techniques that use past traffic data to determine what should be allowed and what should be blocked. In the face of constantly evolving threats to networks, network administrators must ensure their intrusion detection and prevention systems are able to analyze, monitor, and even prevent these advanced threats. In this project, you will research network intrusion and prevention systems and understand their use in a network environment. You will also use monitoring and analysis technologies in the Workspace to compile a Malicious Network Activity Report for financial institutions and a Joint Network Defense Bulletin for a financial services consortium.

Chapter 12 topics:Discuss key items that should be included in an SLADefine predictive analytics and discuss how an IT manager might use such analyticsDiscuss how an IT manager might use load testing on a siteDefine and discuss vendor lock-in and identify steps a company should take to mitigate this riskWith respect to cloud-based solutions, list and discuss 5 to 10 operations or tasks an IT manager should overseeChapter 13 topics:List and describe common system requirements one should consider before moving an application to the cloudDiscuss why a company should consider using a consultant to oversee a cloud migration and list specific skills you would expect the consultant to haveList and discuss resource utilization characteristics one should monitor for an application prior to moving the application to the cloudList possible training requirements for a SaaS solution integration, a PaaS application migration, and an IaaS application migrationList and describe budget considerations one should evaluate before moving an application to the cloudList and describe IT governance considerations one should evaluate before moving an application to the cloudDefine and describe cloud bursting

Can I get help on SQL query. All the questions and requirements are in the attacked files. I also attached the sample input and output.