Celestial Systems Interview Questions, Process, and Tips

You can boot a system without a HDD by using a live CD/USB or network booting.

• Use a live CD/USB with an operating system to boot the system.

• Set up network booting using PXE (Preboot Execution Environment) to boot the system over the network.

• Utilize a bootable external drive or USB to boot the system.

DNAT stands for Destination Network Address Translation. It is used to change the destination IP address of packets in a network.

• DNAT is commonly used in network address translation (NAT) to redirect incoming packets to a different destination IP address.

• It is often used in scenarios where a public IP address needs to be translated to a private IP address within a network.

• DNAT can be used to forward traffic from a spec...read more

Python data types include integers, floats, strings, lists, tuples, dictionaries, and sets.

• Integers: whole numbers without decimal points (e.g. 5, -10)

• Floats: numbers with decimal points (e.g. 3.14, -0.5)

• Strings: sequences of characters enclosed in quotes (e.g. 'hello', '123')

• Lists: ordered collections of items (e.g. [1, 'apple', True])

• Tuples: ordered, immutable collections of items (e.g. (1, 'banana', False))

• Dictionar...read more

Yes, I have experience working on Google Cloud Platform (GCP).

• Managed GCP resources such as Compute Engine, Cloud Storage, and BigQuery

• Implemented infrastructure as code using Google Cloud Deployment Manager

• Utilized GCP services for data analytics and machine learning projects

Efficient memory management is crucial for handling large amounts of data in a database.

• Use pagination to retrieve data in smaller chunks instead of all at once

• Implement caching mechanisms to reduce the need for frequent database queries

• Optimize database queries and indexes to improve retrieval and storage efficiency

Efficient data modelling techniques like normalization and indexing are crucial for managing large data sets.

• Normalization helps reduce redundancy and improve data integrity by organizing data into separate tables and linking them through relationships.

• Indexing helps improve query performance by creating indexes on columns frequently used in search conditions.

• Partitioning can also be used to divide large data sets into...read more

Employing caching mechanism can significantly improve performance by storing frequently accessed data in memory.

• Caching reduces the need to fetch data from slower storage systems, such as databases, by keeping a copy in memory.

• Common caching mechanisms include in-memory caches like Redis or Memcached.

• Caching can be implemented at different levels, such as application-level caching or server-level caching.

• Cache eviction...read more