RBC Technical Skills Assessment 4 — Questions and Answers
Question 1: A project manager notices tasks are consistently starting late because predecessors finish late. The sequence of tasks that determines the minimum project duration is called the:
- Work breakdown structure
- Critical path (Correct answer)
- Gantt chart
- Risk register
Correct answer: Critical path
The critical path is the longest sequence of dependent tasks; any delay on it directly delays the project end date.
Question 2: Which SQL JOIN type returns all rows from the left table and matching rows from the right table, with NULLs for non-matching right-table rows?
- INNER JOIN
- RIGHT JOIN
- LEFT JOIN (Correct answer)
- CROSS JOIN
Correct answer: LEFT JOIN
A LEFT JOIN returns all records from the left table and matched records from the right table; unmatched right-side fields are NULL.
Question 3: In Python, what does the len() function return when called on the string 'RBC'?
- 2
- 3 (Correct answer)
- 4
- 0
Correct answer: 3
len('RBC') returns 3 because the string contains three characters: R, B, and C.
Question 4: A financial analyst exports data to CSV. Which statement about CSV files is correct?
- CSV files support multiple worksheets like Excel
- CSV files preserve cell formatting and formulas
- CSV files store data as plain text with delimiters (Correct answer)
- CSV files require proprietary software to open
Correct answer: CSV files store data as plain text with delimiters
CSV (Comma-Separated Values) files store tabular data as plain text, with fields separated by commas or other delimiters.
Question 5: Which type of software testing verifies that individual units or components of code work correctly in isolation?
- Integration testing
- User acceptance testing
- Unit testing (Correct answer)
- Regression testing
Correct answer: Unit testing
Unit testing validates the smallest testable parts of an application independently from other components.
Question 6: A server's SSD is nearly full. Which action most directly frees disk space without affecting live data?
- Increase RAM
- Delete log files and temporary data (Correct answer)
- Restart the web server
- Upgrade the CPU
Correct answer: Delete log files and temporary data
Removing log files and temporary files reclaims disk space without modifying production data.
Question 7: In the context of APIs, what does REST stand for?
- Remote Execution and State Transfer
- Representational State Transfer (Correct answer)
- Relational Endpoint Service Technology
- Resource Encoding and Streaming Technology
Correct answer: Representational State Transfer
REST stands for Representational State Transfer, an architectural style for designing networked web services.
RBC Technical Skills Assessment 4
A project manager notices tasks are consistently starting late because predecessors finish late.
The sequence of tasks that determines the minimum project duration is called the: