RBC - Online Assessment Technical Skills Assessment Questions and Answers — 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?
- Click the link and enter your credentials as requested to ensure your account remains active.
- Forward the email to your colleagues to see if they received a similar message.
- Delete the email immediately and do not report it.
- Report the email as phishing using the company's designated procedure and do not click the link. (Correct answer)
Correct answer: Report the email as phishing using the company's designated procedure and do not click the link.
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'?
- SELECT * FROM Clients WHERE City = 'Toronto';
- SELECT FirstName, LastName FROM Clients WHERE City = 'Toronto'; (Correct answer)
- SELECT FirstName, LastName FROM Clients;
- GET FirstName, LastName FROM Clients WHERE City IS 'Toronto';
Correct answer: SELECT FirstName, LastName FROM Clients WHERE City = 'Toronto';
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 ```
- 5
- 3
- 2 (Correct answer)
- 15
Correct answer: 2
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?
- Testing (Correct answer)
- Deployment
- Design
- Requirements Gathering
Correct answer: Testing
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?
- Infrastructure as a Service (IaaS)
- Platform as a Service (PaaS)
- Software as a Service (SaaS) (Correct answer)
- Function as a Service (FaaS)
Correct answer: Software as a Service (SaaS)
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.
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?
- VLOOKUP
- SUMIF (Correct answer)
- COUNT
- CONCATENATE
Correct answer: SUMIF
The `SUMIF` function is designed to sum the values in a range that meet a specific criterion. In this case, the criterion is the `Branch_Code` being 'BMO123', and the range to sum is the `Amount` column. `VLOOKUP` is for finding things in a table, `COUNT` is for counting cells with numbers, and `CONCATENATE` is for joining text.
RBC - Online Assessment Technical Skills Assessment Questions and Answers
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?