Godaddy Interview Questions (4+ Questions)

We have a question with the files under TMP app directory that are above one megabyte and we'll need to split those files to make them below one megabyte in the chunks. We'll run find command to see files about one megabyte. We can split into original file and the file name part with split command. Split is built in command and find function lets us to perform exec to execute split command after finding the file name. We'll create a loop. IFS read R lets us read the input. Split will split the file that is beyond one megabyte. We'll need to add hyphen print zero. We need to use this because it will send everything to the bash script without new lines. Because with the new lines, the split command will think that we're sending two or three files. However, hyphen print zero adds specific delimiter that is processed properly by split.

We have a repository interview repo that contains a submodule vendor details and submodule lets us nesting repositories. When submodule is used, it uses the specific commit. We need to update a submodule to the latest commit on its default branch. Run git submodule to see our submodule status. Next, run git fetch and then log to see commits in our submodule. We need to pull latest changes. Go to the parent and check status again. Those changes are not committed yet. We run git add and then git commit. Submodule is updated to the latest version.

Build an S3 ingestion pipeline with KMS encryption enforcement, EventBridge-driven validation, quarantine handling, SNS alerting, and CloudWatch logging.

We are given products table with the name of the product, its ID, and the price. Our main goal is to create and calculate neighbor product column. For each product, we take the price of previous product and the price of next product, and then we multiply them together. A CTE is a temporary result set in SQL that you can reference within a single query. It doesn't get saved anywhere. It only exists while that query is running. Window function performs a calculation across multiple rows and keeps every single row in the result. The reason why we can't use group by here is that group by clause collapses all rows into one single row. We use lag, which reaches back to the previous row and grabs its value. The only difference is that we'll use lead instead of lag. Lead will reach forward to the next row and grab its value. COALESCE function takes a list of values and returns the first one that is not null. Since null values can't be used in the calculations, COALESCE function will replace them with zeros.