Flashcards with Image Back

What are the different types of data and their common formats?

  • Text data: .txt, .docx, .pdf, .rtf
  • Numeric data: integers, decimals, percentages
  • Image data: .jpg, .png, .gif, .bmp
  • Audio data: .mp3, .wav, .aac
  • Video data: .mp4, .avi, .mov

What are the main methods for storing data?

  • Local storage: hard drives, SSDs, USB drives
  • Cloud storage: Google Drive, OneDrive, Dropbox
  • Network storage: servers, NAS devices
  • Optical storage: CDs, DVDs, Blu-ray discs
  • Magnetic storage: tape drives for archival

What are best practices for organizing and managing files?

  • Use clear, descriptive file names with dates
  • Create logical folder hierarchies
  • Implement consistent naming conventions
  • Regular cleanup of duplicate and obsolete files
  • Use metadata and tags for easy searching

What are essential data backup and recovery strategies?

  • 3-2-1 rule: 3 copies, 2 different media, 1 offsite
  • Automated backup scheduling
  • Regular testing of backup integrity
  • Version control for important documents
  • Recovery time objectives and procedures

How can you protect and secure your data?

  • Strong passwords and two-factor authentication
  • File encryption for sensitive data
  • Regular software updates and patches
  • Antivirus and anti-malware protection
  • Secure data transmission protocols

What are the key concepts in database management?

  • Tables, records, and fields structure
  • Primary keys and relationships
  • Data normalization principles
  • SQL queries for data retrieval
  • Database integrity and constraints

What are important aspects of data analysis and visualization?

  • Data cleaning and preprocessing
  • Statistical analysis and trends
  • Charts, graphs, and dashboards
  • Data interpretation and insights
  • Tools: Excel, Tableau, Power BI

What are key considerations for data privacy and compliance?

  • Personal data protection regulations
  • Data collection consent and transparency
  • Right to access, modify, and delete data
  • Data retention and disposal policies
  • Privacy by design principles

What are best practices for data migration and integration?

  • Data mapping and transformation
  • ETL processes (Extract, Transform, Load)
  • Data quality validation and testing
  • Rollback procedures and contingency plans
  • API integration and data synchronization

Page 1 of 10

What are the different types of data and their common formats?

  • Text data: .txt, .docx, .pdf, .rtf
  • Numeric data: integers, decimals, percentages
  • Image data: .jpg, .png, .gif, .bmp
  • Audio data: .mp3, .wav, .aac
  • Video data: .mp4, .avi, .mov

What are the main methods for storing data?

  • Local storage: hard drives, SSDs, USB drives
  • Cloud storage: Google Drive, OneDrive, Dropbox
  • Network storage: servers, NAS devices
  • Optical storage: CDs, DVDs, Blu-ray discs
  • Magnetic storage: tape drives for archival

What are best practices for organizing and managing files?

  • Use clear, descriptive file names with dates
  • Create logical folder hierarchies
  • Implement consistent naming conventions
  • Regular cleanup of duplicate and obsolete files
  • Use metadata and tags for easy searching

What are essential data backup and recovery strategies?

  • 3-2-1 rule: 3 copies, 2 different media, 1 offsite
  • Automated backup scheduling
  • Regular testing of backup integrity
  • Version control for important documents
  • Recovery time objectives and procedures

How can you protect and secure your data?

  • Strong passwords and two-factor authentication
  • File encryption for sensitive data
  • Regular software updates and patches
  • Antivirus and anti-malware protection
  • Secure data transmission protocols

What are the key concepts in database management?

  • Tables, records, and fields structure
  • Primary keys and relationships
  • Data normalization principles
  • SQL queries for data retrieval
  • Database integrity and constraints

What are important aspects of data analysis and visualization?

  • Data cleaning and preprocessing
  • Statistical analysis and trends
  • Charts, graphs, and dashboards
  • Data interpretation and insights
  • Tools: Excel, Tableau, Power BI

What are key considerations for data privacy and compliance?

  • Personal data protection regulations
  • Data collection consent and transparency
  • Right to access, modify, and delete data
  • Data retention and disposal policies
  • Privacy by design principles

What are best practices for data migration and integration?

  • Data mapping and transformation
  • ETL processes (Extract, Transform, Load)
  • Data quality validation and testing
  • Rollback procedures and contingency plans
  • API integration and data synchronization