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

Click the link and enter your credentials as requested to ensure your account remains active.

Answer

Forward the email to your colleagues to see if they received a similar message.

Answer

Delete the email immediately and do not report it.

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

SELECT * FROM Clients WHERE City = 'Toronto';

Answer

SELECT FirstName, LastName FROM Clients;

Answer

GET FirstName, LastName FROM Clients WHERE City IS 'Toronto';

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

5

Answer

3

Answer

15

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

Deployment

Answer

Design

Answer

Requirements Gathering

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

Infrastructure as a Service (IaaS)

Answer

Platform as a Service (PaaS)

Answer

Function as a Service (FaaS)

Question 6

An analyst has a spreadsheet with thousands of rows of transaction data. Each row includes a `Transaction_ID`, `Amount`, and `Branch_Code`. The analyst needs to find the total transaction amount specifically for the 'BMO123' branch. Which Excel function is most suitable for this task?

Accepted Answer

SUMIF

Answer

VLOOKUP

Answer

COUNT

Answer

CONCATENATE