Download PrepIQ T Level Technical Qualification in Digital Software Development Level 3 Ultimate E and more Exams Technology in PDF only on Docsity!
Qualification in Digital Software
Development Level 3 Ultimate
Exam
Question 115. Which of the following best describes a “deadlock” in concurrent programming? A) A program that runs forever without terminating B) Two or more threads each waiting for a resource held by the other, causing a stand-still C) A memory leak that exhausts available RAM D) A syntax error that prevents compilation Answer: B Explanation: A deadlock occurs when each thread holds a lock the other needs, so none can proceed. Question 116. In a relational database, the command that removes duplicate rows from a result set is: A) DELETE DISTINCT B) SELECT UNIQUE C) SELECT DISTINCT D) REMOVE DUPLICATES Answer: C Explanation: SELECT DISTINCT returns only unique rows, eliminating duplicates in the output. Question 117. Which of the following is a primary benefit of using a “message queue” in a distributed system? A) Guarantees zero latency communication B) Enables asynchronous processing and decouples producer and consumer services C) Stores data permanently on disk without backup D) Eliminates the need for any security controls
Qualification in Digital Software
Development Level 3 Ultimate
Exam
Answer: B Explanation: Message queues allow components to operate independently and handle messages at their own pace. Question 118. The term “idempotent” in the context of HTTP methods means: A) The method can be called multiple times with the same effect as a single call B) The method must always be called with a request body C) The method always changes server state D) The method is only usable over HTTPS Answer: A Explanation: Idempotent methods (e.g., GET, PUT, DELETE) produce the same result no matter how many times they are repeated. Question 119. Which of the following is an example of a “soft skill” that improves teamwork in a software project? A) Mastery of a programming language B) Ability to write complex SQL queries C) Active listening and empathy D) Knowledge of cloud deployment scripts Answer: C Explanation: Active listening fosters clear communication and collaboration among team members. Question 120. In the context of software licensing, “copyleft” refers to: A) A clause that prohibits any modification of the software B) A licensing condition that requires derivative works to be released under the same license C) A restriction that the software can only be used in commercial settings
Qualification in Digital Software
Development Level 3 Ultimate
Exam
B) Escaping all characters manually C) Employing prepared statements with parameterised queries D) Disabling the database firewall Answer: C Explanation: Parameterised queries separate code from data, eliminating the injection vector. Question 124. In Agile Scrum, the time-boxed meeting where the team reflects on how to become more effective is called: A) Sprint planning B) Daily stand-up C) Sprint review D) Sprint retrospective Answer: D Explanation: The retrospective focuses on process improvement after each sprint. Question 125. Which of the following best defines “technical debt” in software development? A) Money owed to a vendor for hardware purchases B) The cost of licensing third-party libraries C) The future work required to fix shortcuts or sub-optimal code introduced earlier D) The interest accrued on project loans Answer: C Explanation: Technical debt represents the implied cost of reworking quick solutions later.
Qualification in Digital Software
Development Level 3 Ultimate
Exam
Question 126. The primary purpose of a “service level agreement” (SLA) between a cloud provider and a client is to: A) Define the programming language to be used for development B) Specify measurable performance and availability targets and penalties for non-compliance C) List all hardware components in the data centre D) Outline the user interface design guidelines Answer: B Explanation: SLAs set expectations for service quality and remedies if they are not met. Question 127. Which of the following is an example of a “non-functional requirement”? A) The system shall allow users to reset their password B) The application shall respond to user input within 200 ms under normal load C) The software shall generate a monthly sales report D) The database shall store customer records Answer: B Explanation: Non-functional requirements describe quality attributes such as performance. Question 128. In a microservice architecture, the pattern that enables services to discover each other at runtime without hard-coded endpoints is: A) Service registry and discovery B) Monolithic deployment C) Direct socket communication D) Shared file system Answer: A
Qualification in Digital Software
Development Level 3 Ultimate
Exam
D. Network latency spikes during file transfers Answer: B Explanation: Fragmentation causes the heap to become inefficient, leading to memory exhaustion over time. Question 132. In the context of data protection, “pseudonymisation” differs from “anonymisation” because: A) Pseudonymised data can be re-identified with additional information, whereas anonymised data cannot B) Pseudonymisation encrypts data, anonymisation does not C) Anonymisation is illegal under GDPR, pseudonymisation is not D) Pseudonymisation removes all personal identifiers permanently Answer: A Explanation: Pseudonymisation replaces identifiers but retains a link that can be restored, while anonymisation removes any link. Question 133. Which of the following best describes a “state machine” in software design? A) A system that never changes its configuration B) A model that defines a set of states and transitions triggered by events or conditions C) A database schema for storing user sessions D) A hardware component that controls power supply Answer: B Explanation: State machines represent behaviour as discrete states with defined transitions. Question 134. The “principle of “open-closed”” states that software entities should be:
Qualification in Digital Software
Development Level 3 Ultimate
Exam
A) Open for modification and closed for extension B. Open for extension but closed for modification C) Open to all users without authentication D) Closed to any form of testing Answer: B Explanation: Modules should be extendable without altering existing, stable code. Question 135. Which of the following is a typical use case for “graph databases”? A. Storing large binary files such as videos B. Representing and querying highly interconnected data like social networks C. Performing high-throughput transaction processing for banking D. Running batch analytics on flat CSV files Answer: B Explanation: Graph databases excel at traversing relationships between entities. Question 136. In the context of AI, “overfitting” refers to: A. A model that performs exceptionally well on unseen data B. A model that memorises training data and fails to generalise to new data C. A model that uses too few parameters D. A model that runs too quickly on a GPU Answer: B Explanation: Overfitted models capture noise instead of underlying patterns, leading to poor generalisation.
Qualification in Digital Software
Development Level 3 Ultimate
Exam
Explanation: TCP establishes a connection and guarantees ordered, error-checked delivery. Question 140. Which of the following is a primary advantage of using “Infrastructure as Code” (IaC)? A. Manual configuration of servers is faster B. Infrastructure can be version-controlled, reproduced, and audited automatically C. It eliminates the need for any security testing D. It requires no knowledge of scripting languages Answer: B Explanation: IaC treats infrastructure definitions as code, enabling repeatable, auditable deployments. Question 141. The term “latency” in a computer system most commonly refers to: A. The amount of data that can be transferred per second B. The delay between a request being sent and the first byte of the response being received C. The total number of users connected simultaneously D. The size of the hard-disk storage pool Answer: B Explanation: Latency measures time delay in communication or processing. Question 142. Which of the following best describes “refactoring”? A. Adding new features without any testing B. Re-structuring existing code to improve readability and maintainability without changing its external behaviour C. Converting code from one programming language to another automatically
Qualification in Digital Software
Development Level 3 Ultimate
Exam
D. Deleting all comments from source files Answer: B Explanation: Refactoring improves internal code quality while preserving functionality. Question 143. In the context of secure software development, “threat modelling” is performed to: A. Generate random test data B. Identify, prioritise, and mitigate potential security threats early in the design phase C. Write documentation for end users D. Optimize database indexes for performance Answer: B Explanation: Threat modelling anticipates attacks and defines mitigations before implementation. Question 144. Which of the following is a characteristic of a “stateless” web service? A. It stores user session data on the server between requests B. Each request contains all information needed to process it, with no reliance on prior interactions C. It requires a persistent TCP connection for the entire session D. It can only be accessed via a web browser Answer: B Explanation: Stateless services do not retain client context between calls. Question 145. Which of the following best defines “data provenance”? A. The process of encrypting data at rest
Qualification in Digital Software
Development Level 3 Ultimate
Exam
Question 148. The “principle of “defense in depth”” recommends: A. Relying solely on a firewall for security B. Deploying multiple, layered security controls to protect assets from different angles C. Using only encryption and nothing else D. Allowing unrestricted access to internal networks Answer: B Explanation: Multiple layers reduce the chance that a single vulnerability compromises the whole system. Question 149. Which of the following is an example of a “soft real-time” system? A. Air-traffic control system B. Online video streaming service that can tolerate occasional buffering C. Pacemaker medical device D. Industrial robot controller requiring deterministic response times Answer: B Explanation: Soft real-time systems can handle occasional delays without catastrophic failure. Question 150. In software testing, “mutation testing” is used to: A. Generate random input data for fuzz testing B. Introduce small changes (mutations) to source code to evaluate the effectiveness of test suites C. Measure code coverage percentages only D. Automate UI testing using screenshots Answer: B Explanation: Mutation testing checks whether tests detect intentional faults, indicating test quality.
Qualification in Digital Software
Development Level 3 Ultimate
Exam
Question 151. Which of the following best describes a “digital twin”? A. A physical replica of a server rack B. A virtual model that mirrors a real-world object or process, enabling simulation and analysis C. A backup copy of a database stored on tape D. An encrypted version of a software binary Answer: B Explanation: Digital twins provide real-time insights by replicating physical assets in software. Question 152. The “principle of “YAGNI” (You Aren’t Gonna Need It)” advises developers to: A. Build every possible feature pre-emptively B. Implement only what is required now, avoiding speculative features C. Optimize code for performance before it works correctly D. Write documentation after the project is finished Answer: B Explanation: YAGNI discourages unnecessary complexity and premature development. Question 153. Which of the following is a common use of “web sockets”? A. Sending static HTML pages only B. Enabling real-time, bidirectional communication between client and server over a single persistent connection C. Encrypting email messages end-to-end D. Performing background file uploads via FTP Answer: B
Qualification in Digital Software
Development Level 3 Ultimate
Exam
D. Defer error handling to the operating system Answer: B Explanation: Early failure simplifies debugging and prevents error propagation. Question 157. Which of the following is a typical characteristic of a “serverless” function (e.g., AWS Lambda)? A. It runs on a dedicated virtual machine that never stops B. It is executed in response to events and billed only for the actual compute time used C. It requires manual scaling of underlying servers D. It cannot access external APIs Answer: B Explanation: Serverless functions are event-driven and cost-effective because you pay only for execution time. Question 158. In the context of data visualisation, a “box-and-whisker plot” is primarily used to display: A. Geographic locations on a map B. Distribution of a dataset, showing median, quartiles, and outliers C. Time-series trends over months D. Hierarchical relationships between entities Answer: B Explanation: Box plots summarise statistical dispersion and central tendency. Question 159. Which of the following best describes “continuous integration” (CI)? A. Merging code changes into a shared repository frequently and automatically building and testing them
Qualification in Digital Software
Development Level 3 Ultimate
Exam
B. Deploying code directly to production without testing C. Writing documentation after every sprint D. Manually copying files between developers’ machines Answer: A Explanation: CI encourages early detection of integration issues through automated builds and tests. Question 160. The “principle of “single source of truth”” in software configuration management means: A. Storing configuration data in multiple places for redundancy B. Maintaining one authoritative location for configuration values that all services reference C. Encrypting all configuration files with different keys D. Allowing each developer to keep their own copy of the config file Answer: B Explanation: A single source prevents inconsistencies and drift across environments. Question 161. Which of the following is a typical symptom of a “race condition” in concurrent programs? A. Deterministic output regardless of execution order B. Intermittent, unpredictable failures depending on thread scheduling C. Immediate compilation error D. Static code analysis warnings only Answer: B Explanation: Race conditions arise when the program’s behaviour depends on the non-deterministic timing of threads.
Qualification in Digital Software
Development Level 3 Ultimate
Exam
Question 165. Which of the following is a key advantage of using “type hinting” in Python? A. It forces the interpreter to run faster B. It provides optional static type information that can be checked by linters and IDEs, improving readability and error detection C. It removes the need for unit tests D. It encrypts the source code automatically Answer: B Explanation: Type hints aid developers and tools in understanding expected data types without affecting runtime. Question 166. The “principle of “separation of concerns”” is most closely associated with which software design pattern? A. Singleton B. Model-View-Controller (MVC) C. Factory D. Adapter Answer: B Explanation: MVC separates data (model), UI (view), and user input handling (controller). Question 167. Which of the following best describes a “side-channel attack”? A. Exploiting a software bug in the main application logic B. Gaining information from indirect emissions such as timing, power consumption, or electromagnetic leaks C. Using a phishing email to steal credentials D. Installing ransomware on a server Answer: B
Qualification in Digital Software
Development Level 3 Ultimate
Exam
Explanation: Side-channel attacks derive secrets from physical or implementation characteristics. Question 168. In the context of cloud security, “IAM” stands for: A. Integrated Application Management B. Identity and Access Management C. Internal Audit Mechanism D. Internet Access Module Answer: B Explanation: IAM controls who can access which resources and what actions they can perform. Question 169. Which of the following is a typical characteristic of a “stateless” RESTful API endpoint? A. It stores user session data on the server between calls B. Each request contains all required authentication and data to be processed independently C. It requires a persistent TCP connection for the duration of a user session D. It only supports the POST method Answer: B Explanation: Stateless endpoints do not rely on server-side session state. Question 170. The “principle of “open-closed”” encourages developers to: A. Keep code open to anyone for modification B. Design modules that can be extended without modifying existing source code C. Close all source files after compilation D. Open all ports on a firewall for easy access Answer: B
