ACTUAL EXAM WITH COMPLETE QUESTIONS AND CORRECT
DETAILED ANSWERS (100% VERIFIED ANSWERS) |ALREADY
GRADED A+| ||PROFESSOR VERIFIED|| ||BRANDNEW!!!||
A systems analyst is reviewing a failing ERP implementation. Which action
should the analyst prioritize FIRST to improve project success?
A. Begin user training sessions
B. Reevaluate business process requirements
C. Upgrade hardware infrastructure
D. Increase project budget
Correct Answer: B
Rationale:
The priority in a failing ERP implementation is to reassess business process
requirements because ERP systems integrate multiple organizational functions and
rely heavily on accurate requirements. If the foundational business needs are
misunderstood or poorly defined, all subsequent steps—such as training or
infrastructure improvements—will fail to address the root cause. The analysis
phase of the System Development Life Cycle emphasizes determining information
requirements as the most critical step. Without this alignment, the system will
continue to underperform regardless of additional resources.
,A company wants to ensure executives can quickly make strategic decisions
using summarized internal and external data. Which system should be
implemented?
A. Transaction Processing System
B. Decision Support System
C. Executive Support System
D. Management Information System
Correct Answer: C
Rationale:
Executive Support Systems are specifically designed to assist senior leadership
with unstructured decision-making by combining internal and external data into
highly summarized formats. These systems allow executives to identify trends and
make strategic decisions quickly. Transaction Processing Systems handle routine
data, Management Information Systems support middle management, and Decision
Support Systems provide analytical tools but are not as focused on executive-level
summaries.
A project manager is reviewing a timeline where delays in one task are
impacting the entire project completion date. Which tool is MOST
appropriate to identify this issue?
A. Gantt Chart
B. PERT Chart
,C. Critical Path Method
D. Dashboard
Correct Answer: C
Rationale:
The Critical Path Method identifies the sequence of dependent tasks that directly
determine the project’s duration. Any delay in these tasks will delay the entire
project. While Gantt charts display timelines and PERT charts show task
relationships, neither emphasizes the longest dependency chain as clearly as the
Critical Path Method. This makes it the best tool for prioritizing time-sensitive
tasks.
A company implements strict access controls so employees only access data
necessary for their roles. Which principle is being applied?
A. Separation of Duties
B. Principle of Least Privilege
C. Data Governance
D. Risk Management
Correct Answer: B
Rationale:
The Principle of Least Privilege ensures that users are granted only the minimum
level of access required to perform their job functions. This reduces the likelihood
of data breaches and limits damage if an account is compromised. Separation of
Duties focuses on dividing responsibilities, while Data Governance and Risk
, Management are broader concepts that include multiple controls beyond access
restriction.
A database administrator detects inconsistent relationships between tables
due to missing matching keys. Which concept is violated?
A. Data Normalization
B. Referential Integrity
C. Data Mining
D. Schema Design
Correct Answer: B
Rationale:
Referential integrity ensures that relationships between tables remain consistent by
requiring foreign keys to match valid primary keys. When this rule is violated, data
becomes unreliable and relationships between tables break down. This
compromises the accuracy of queries and reporting, making referential integrity
essential for relational database reliability.
A manager must choose between analyzing real-time transactions or historical
trends without affecting system performance. Which approach should be
prioritized for decision-making?
A. OLTP for both tasks
B. OLAP for analysis and OLTP for transactions