Free Technical Skills Test

Candidate Name

Position Applied For

Date

1. Which of the following SQL queries retrieves all columns from the "employees" table for employees hired after January 1, 2020?

• a.) SELECT * FROM employees WHERE hire_date > '2020-01-01';

• b.) SELECT all FROM employees WHERE hire_date > '2020-01-01';

• c.) SELECT hire_date, * FROM employees;

• d.) SELECT employees FROM * WHERE hire_date > '2020-01-01';

2. What is the output of the following Python code "def add_numbers(x, y): return x + y result = add_numbers(3, 7) print(result)"

• a.) 37

• b.) 10

• c.) 3 7

3. Which firewall configuration rule will allow only HTTPS (port 443) traffic while blocking all other incoming connections?

• a.) Allow port 80 and 443

• b.) Block port 80, allow port 443

• c.) Allow port 443, block all others

• d.) Allow all traffic, except port 443

4. Which of the following actions would ensure an AWS S3 bucket is private, only allowing access to authorized users?

• a.) Enable public access settings in the S3 bucket

• b.) Use an IAM policy to restrict access to specific users or groups

• c.) Set the S3 bucket to "public-read"

• d.) Disable IAM roles for S3 bucket access

5. Which of the following algorithms has a time complexity of O(n) for finding the maximum value in an unsorted list of integers?

• a.) Sorting the list and returning the last element

• b.) Using a brute force approach to compare all elements

• c.) Scanning the list once and updating the maximum value

• d.) Using a binary search approach