Download PrepIQ NWCA Database Processing Ultimate Exam and more Exams Technology in PDF only on Docsity!
Processing Ultimate Exam
Question 1. Which of the following best describes the primary purpose of aligning an information-system strategy with business goals? A) To reduce the number of IT staff needed B) To ensure technology investments directly support organizational objectives C) To comply with government IT regulations D) To increase the complexity of the IT architecture Answer: B Explanation: Aligning IS strategy with business goals guarantees that technology resources are used to achieve the organization’s mission, rather than being an isolated cost center. Question 2. A manager is planning a new computer network to support remote sales staff. Which activity is the manager most directly responsible for? A) Writing SQL stored procedures B) Selecting network topology and bandwidth requirements C) Designing the physical layout of the data center racks D) Configuring database backup schedules Answer: B Explanation: Network planning, including topology and bandwidth, falls under the manager’s role in ensuring the network meets user needs. Question 3. Which function of an information system most directly supports the human-resources department? A) Payroll processing and employee data management B) Real-time inventory tracking C) Customer relationship management D) Supplier order fulfillment Answer: A
Processing Ultimate Exam
Explanation: HR relies on IS for payroll, benefits, performance data, and employee records. Question 4. In the systems development life cycle (SDLC), which phase follows “Requirements Gathering”? A) Implementation B) Design C) Testing D) Maintenance Answer: B Explanation: After collecting requirements, the design phase creates system specifications before coding begins. Question 5. Business Process Management (BPM) primarily aims to: A) Automate every business activity regardless of cost B) Optimize and continuously improve business processes using data C) Replace all human decision-making with AI D) Increase the number of database tables Answer: B Explanation: BPM uses data to streamline, monitor, and improve processes, not merely to automate indiscriminately. Question 6. Which of the following best illustrates “strategic organization of data” for decision-making? A) Storing all logs in a single flat file for easy access B) Creating a data warehouse that integrates sales, finance, and marketing data C) Encrypting every record with a unique key D) Using a NoSQL database for transactional processing
Processing Ultimate Exam
C) Database designer D) End-user Answer: C Explanation: Database designers model entities, relationships, and constraints before implementation. Question 10. Compared with a flat file, a relational database provides: A) No support for data integrity constraints B) Faster sequential file reads only C) Structured relationships, indexing, and query capabilities D) Unlimited storage without any performance impact Answer: C Explanation: Relational databases support keys, indexes, and SQL queries, enabling efficient data retrieval and integrity. Question 11. In an Entity-Relationship diagram, a diamond shape typically represents: A) An attribute B) An entity C) A relationship D) A primary key Answer: C Explanation: Diamonds denote relationships between entities in ER modeling. Question 12. Which of the following is a correct definition of a primary key? A) A column that may contain duplicate values B) A field that uniquely identifies each record in a table
Processing Ultimate Exam
C) A foreign key that references another table D) A column used only for indexing purposes Answer: B Explanation: The primary key must be unique and not null for each row. Question 13. A foreign key is used to: A) Ensure each row has a unique identifier within its own table B) Establish a link between two tables based on a common attribute C) Store large binary objects such as images D) Encrypt data at rest Answer: B Explanation: Foreign keys enforce referential integrity by referencing a primary key in another table. Question 14. Normalization up to the Third Normal Form (3NF) primarily removes: A) All indexes from the database B) Redundant data and transitive dependencies C) Primary keys from tables D) Column data types Answer: B Explanation: 3NF eliminates redundancy and ensures non-key attributes depend only on the primary key. Question 15. Which SQL command is used to retrieve data from one or more tables? A) INSERT
Processing Ultimate Exam
B) Pessimistic locking C) Data warehousing D) Data mining Answer: B Explanation: Pessimistic locking acquires locks before data modification to avoid conflicts. Question 19. A “deadlock” in a multi-user database environment occurs when: A) Two transactions wait indefinitely for each other’s locks to be released B) The database server runs out of disk space C) All users are logged out simultaneously D) The network cable is unplugged Answer: A Explanation: Deadlocks happen when each transaction holds a lock the other needs, causing a cycle. Question 20. Which of the following best describes a data warehouse? A) A transactional system optimized for day-to-day operations B) A read-only repository of historical data optimized for analysis C) A temporary cache for web-page content D) A file system for storing binary objects Answer: B Explanation: Data warehouses store integrated, historical data for analytical queries. Question 21. A data mart differs from a data warehouse primarily in that a data mart:
Processing Ultimate Exam
A) Stores only unstructured data B) Is focused on a specific business line or department C) Uses NoSQL technology exclusively D) Is always located on the cloud Answer: B Explanation: Data marts are subsets of a warehouse tailored to departmental needs. Question 22. Which data-mining technique is most appropriate for discovering frequent itemsets in market-basket analysis? A) Decision trees B) Association rule learning C) Neural networks D) Regression analysis Answer: B Explanation: Association rules identify items that commonly appear together in transactions. Question 23. In a Business Intelligence (BI) context, “ETL” stands for: A) Extract, Transform, Load B) Evaluate, Test, Launch C) Encrypt, Transfer, Log D) Execute, Tabulate, List Answer: A Explanation: ETL processes move data from source systems into a data warehouse after cleansing and transformation.
Processing Ultimate Exam
Explanation: Social media APIs often return JSON, requiring transformation before relational storage. Question 27. Which legal principle protects personal data collected from social-media users in many jurisdictions? A) The First Amendment B) GDPR (General Data Protection Regulation) C. The Sarbanes-Oxley Act D. The Patriot Act Answer: B Explanation: GDPR imposes strict rules on collecting, processing, and storing personal data of EU citizens. Question 28. Which of the following is a key ethical concern when processing large volumes of customer data? A. Maximizing CPU usage B. Ensuring informed consent and privacy protection C. Using the fastest available DBMS vendor D. Storing data on local hard drives only Answer: B Explanation: Ethics demand that customers know how their data is used and that privacy is safeguarded. Question 29. In a cloud-based database solution, scalability is primarily achieved through: A. Adding more physical disks to a single server B. Provisioning additional virtual instances on demand C. Using larger monolithic applications D. Disabling indexing
Processing Ultimate Exam
Answer: B Explanation: Cloud platforms allow dynamic allocation of compute and storage resources. Question 30. Which of the following is a characteristic of an on-premises database deployment? A. Automatic global replication across continents B. Full control over hardware, security policies, and physical access C. No need for internal IT staff D. Unlimited elasticity without cost Answer: B Explanation: On-premises gives the organization direct control over the environment. Question 31. A “CAP theorem” limitation states that a distributed database can simultaneously provide at most two of the following: A. Consistency, Availability, Partition tolerance B. Concurrency, Accuracy, Performance C. Compression, Aggregation, Persistence D. Connectivity, Authentication, Privacy Answer: A Explanation: The CAP theorem defines the trade-off among Consistency, Availability, and Partition tolerance. Question 32. Which of the following is a common method for ensuring data integrity in a relational database? A. Storing passwords in plain text B. Defining foreign-key constraints
Processing Ultimate Exam
B. Incremental backup with transaction log backups C. Weekly differential backup only D. Copy-on-write snapshots without logs Answer: B Explanation: Transaction log backups allow recovery to any point after the last full backup. Question 36. A “data lake” differs from a data warehouse mainly because a data lake: A. Stores only structured data B. Holds raw, unprocessed data in its original format C. Requires a relational schema before loading data D. Is always hosted on-premises Answer: B Explanation: Data lakes accept structured, semi-structured, and unstructured data without upfront modeling. Question 37. Which SQL clause is used to limit the number of rows returned by a query in MySQL? A. LIMIT B. TOP C. FETCH FIRST D. ROWCOUNT Answer: A Explanation: MySQL uses the LIMIT clause to restrict result set size.
Processing Ultimate Exam
Question 38. In Oracle, which feature provides automatic failover for a standby database? A. Data Guard B. RMAN C. Flashback Query D. ASM Answer: A Explanation: Oracle Data Guard maintains a synchronized standby and can automatically switch over. Question 39. Which of the following is NOT a typical responsibility of a Database Designer? A. Defining entity relationships and normalization level B. Installing operating system patches on the server C. Selecting appropriate data types for columns D. Designing indexes to support query performance Answer: B Explanation: OS patching is an admin task, not a design responsibility. Question 40. Which SQL statement would you use to add a new column “email” to an existing table “Employees”? A. ALTER TABLE Employees ADD COLUMN email VARCHAR(255); B. MODIFY Employees ADD email VARCHAR(255); C. UPDATE Employees SET email = '' ; D. INSERT INTO Employees (email) VALUES (NULL); Answer: A
Processing Ultimate Exam
Answer: B Explanation: Sharding distributes rows across nodes, improving scalability and performance. Question 44. In the context of database security, what is “role-based access control (RBAC)”? A. Granting permissions based on the user’s job function or role B. Allowing any user to access any data during off-hours C. Encrypting all database traffic with SSL D. Using biometric authentication for each query Answer: A Explanation: RBAC assigns privileges to roles, simplifying permission management. Question 45. Which SQL function would you use to calculate the total sales amount from a column “sale_amount”? A. TOTAL(sale_amount) B. SUM(sale_amount) C. ADD(sale_amount) D. CALC(sale_amount) Answer: B Explanation: SUM aggregates numeric values across rows. Question 46. A “trigger” in a database is used to: A. Automatically execute a set of SQL statements in response to a specific event (INSERT, UPDATE, DELETE) B. Speed up SELECT queries by creating indexes C. Backup the entire database daily
Processing Ultimate Exam
D. Convert relational data to XML Answer: A Explanation: Triggers fire when defined data-modification events occur. Question 47. Which of the following is a common sign of a poorly designed relational schema? A. Every table has a primary key B. Frequent use of many-to-many relationship tables C. Excessive number of NULL values in many columns D. All columns are indexed Answer: C Explanation: Many NULLs often indicate optional attributes that should be modeled differently. Question 48. In the context of Business Intelligence, a “key performance indicator (KPI)” is: A. A metric used to evaluate the success of an organization’s objectives B. A type of primary key in a data warehouse C. A security token for database connections D. An index type for faster joins Answer: A Explanation: KPIs are measurable values that reflect progress toward strategic goals. Question 49. Which of the following best explains “data provenance” in a data-processing pipeline? A. The process of encrypting data at rest
Processing Ultimate Exam
Question 52. In a multi-tenant SaaS application, which database design pattern is most commonly used to isolate each tenant’s data? A. Separate physical servers for each tenant B. A single shared schema with a tenant identifier column in each table C. Using a NoSQL database for all tenants D. Storing tenant data in XML files Answer: B Explanation: A tenant ID column isolates data while keeping the schema shared, simplifying management. Question 53. Which of the following best describes “data masking”? A. Deleting all records older than one year B. Replacing sensitive data with fictional but realistic values for non-production use C. Encrypting the entire database file D. Compressing data to save storage Answer: B Explanation: Data masking protects privacy by substituting real values with realistic surrogates. Question 54. When a database must meet the Health Insurance Portability and Accountability Act (HIPAA) requirements, which control is essential? A. Storing all data in a public cloud without encryption B. Implementing audit trails and access controls for protected health information (PHI) C. Disabling all user authentication mechanisms D. Using only open-source software Answer: B
Processing Ultimate Exam
Explanation: HIPAA mandates audit logging and strict access controls for PHI. Question 55. Which of the following is the most appropriate use case for a NoSQL document database? A. Complex multi-table joins with strict ACID transactions B. Storing hierarchical JSON documents with flexible schemas C. High-frequency financial transaction processing requiring rollbacks D. Maintaining a static catalog of unchanging data Answer: B Explanation: Document databases excel at storing semi-structured JSON with variable fields. Question 56. Which SQL clause is used to remove duplicate rows from a query result set? A. DISTINCT B. UNIQUE C. GROUP BY D. HAVING Answer: A Explanation: DISTINCT eliminates duplicate rows in the SELECT output. Question 57. In a data-processing workflow, “data cleansing” primarily aims to: A. Increase the size of the dataset B. Identify and correct inaccurate, incomplete, or inconsistent data C. Convert all data to binary format D. Encrypt the data for security
