Lecture 4 Flashcards
Auditing and Monitoring Databases
Database auditing vs monitoring: (!!)
- Auditing: documenting and recording all database activity in detail, like logins or modifications.
- Monitoring: real-time observation of database activity and performance, to detect anomalies as they happen.
Both are used to ensure security and compliance.
Name 3 types of activity monitored in auditing: (!!)
-Logins
-Modifications
-Transactions
What are 4 key metrics to look at in performance monitoring? (!!)
-Query execution time.
-CPU usage.
-Memory usage.
-disk input and output
Name 3 benefits of performance monitoring: (!!)
-Performance optimization.
-Efficiency in resource usage.
-Identifying patterns to make predictions.
What is machine learning and how does it help prevent attacks? (!!)
Machine learning is a form of ai that learns and improves from data over time.
It has an enhanced ability to detect patterns that traditional rule-based systems might miss.
What are 3 benefits of machine learning in auditing? (!!)
-Automated learning.
-Less false positives.
-Real-time threat detection.
What is blockchain technology and how is it used in auditing? (!!)
A system that records data in a chain of permanent, unchangeable blocks, called ledgers.
It helps in recording database activity securely, as blocks are immutable.
What are 3 benefits of using blockchain in auditing? (!!)
-Transparency: Every transaction recorded is visible to authorized parties.
-Decentralization: no central authority that attackers can attack.
-Enhanced cryptographic security.
What is a possible future application of blockchain in auditing?
Integration of blockchain with machine learning, where a secure ledger of data is created using blockchain then be analyzed by machine learning.
What is predictive analytics?
a technique that uses data to identify patterns and prevent problems like bottlenecks.
What’s automated remediation? (!!)
It detects and automatically resolves issues in real-time.
List 3 examples of actions that automated remediation can do: (!!)
-Resource management: automatically allocates resources like memory to avoid exceeding limits.
-Automatic patches and updates.
-Load balancing: dynamically rerouting queries to less loaded servers.
What are 3 benefits of automated remediation? (!!)
-Reducing downtime.
-Cost-effective: can do the work instead of employees.
-Scalability.
What is privacy-preserving auditing and why is it important? (!!)
It’s the practice of auditing while keeping sensitive information private. It is important due to increasing privacy concerns and regulatory requirements.
What are 2 benefits of privacy-preserving auditing? (!!)
-Maintaining confidentiality during audits.
-Compliance.
