RBC - Online Assessment Technical Skills Assessment Questions and Answers

Question 1

You receive an email with the subject 'Urgent: Your Account Requires Immediate Validation' from a sender address that looks slightly different from the official internal IT department's address. The email contains a link and asks you to enter your network credentials. What is the most appropriate action to take?

Accepted Answer

Report the email as phishing using the company's designated procedure and do not click the link.

Answer

This is a classic example of a phishing attempt. The unusual sender address, sense of urgency, and request for sensitive information are major red flags. Clicking the link could compromise your credentials and company data. The correct protocol is always to report suspicious emails to the appropriate security team without interacting with the content.

Question 2

A database table named `Clients` contains columns `ClientID`, `FirstName`, `LastName`, and `City`. Which of the following SQL queries would correctly retrieve only the first and last names of clients who live in 'Toronto'?

Accepted Answer

SELECT FirstName, LastName FROM Clients WHERE City = 'Toronto';

Answer

The `SELECT` statement specifies which columns to retrieve (`FirstName`, `LastName`). The `FROM` clause indicates the table (`Clients`). The `WHERE` clause filters the rows to include only those where the `City` column has the value 'Toronto'. Option A retrieves all columns, not just the names. Option C retrieves all names but doesn't filter by city. Option D uses incorrect SQL syntax.

Question 3

Review the following pseudo-code. What will be the final value of the variable `count` after the code is executed?

```
SET count = 0
SET numbers =
FOR EACH number IN numbers
  IF number > 10 THEN
    SET count = count + 1
  END IF
END FOR
```

Accepted Answer

2

Answer

The code initializes `count` to 0. It then iterates through the list of numbers: [3, 5, 8, 12, 15]. The `IF` condition checks if a number is greater than 10. This is true for 12 and 15. For each of these two numbers, `count` is incremented by 1. Therefore, the final value of `count` will be 2.

Question 4

In a typical Software Development Life Cycle (SDLC), which of the following phases is primarily focused on identifying and fixing defects before the software is released to users?

Accepted Answer

Testing

Answer

The Testing phase is dedicated to quality assurance. It involves executing the software to find bugs, errors, or any problems that might negatively affect the user experience. Requirements Gathering is about defining what the software should do, Design is about planning how it will be built, and Deployment is the process of releasing the software for use.

Question 5

A company decides to use a third-party application for its email and collaboration needs (like Microsoft 365 or Google Workspace). They pay a subscription fee and access the software over the internet without managing the underlying infrastructure or platform. Which cloud service model does this represent?

Accepted Answer

Software as a Service (SaaS)

Answer

Software as a Service (SaaS) is a cloud computing model where software applications are delivered over the internet on a subscription basis. The provider manages the hardware, middleware, application software, and security. IaaS provides virtualized computing resources, and PaaS provides a platform for customers to develop and manage their own applications.

RBC - Online Assessment Practice Test

RBC - Online Assessment Practice Test

RBC - Online Assessment Technical Skills Assessment Questions and Answers