stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
3300 - Exam 1 - 24S - Prep/Review Flashcards | StudBud
Explore
/
3300 - Exam 1 - 24S - Prep/Review
3300 - Exam 1 - 24S - Prep/Review
26 terms
·
StudBud Administration
·
274 plays
A quiz to help students prepare for Exam 1, the multiple choice section of Exam 1
Flashcards
26 cards
F
Practice quiz
P
Host live
L
Questions
26
Answers
1
The automatic backup system on your computer is an example of what type of software?
Application software
Utility
Operating system
System software
2
What technology platform is dramatically changing the Enterprise Systems market?
Cloud Computing
Facebook
Artificial Intelligence
Public Databases
3
An ITSM report shows metrics for the month of January. What are likely metrics that would be included?
Average duration of the incidents
Number of incidents
Availability by system
All of the above
4
Under SDLC, the artifact from the requirements phase for functional requirements is the
Governance artifacts
BRD - Business Requirements Document
TRD - Technical Requirements Document
Functional Test Scripts
5
A field in DB table A that is also the primary key in DB table B would be a ______ in table A.
Foreign record
Foreign column
Foreign field
Foreign key
6
For an enterprise, a business process model (BPM)
provides key knowledge for decision making
provides the basis for development of enterprise systems
all of the above
visually links the business to the IT organization
7
The primary way that DevOps is different from Agile is
Agile provides faster delivery of benefits than DevOps
DevOps includes the operations function while Agile does not
There is almost no difference in the 2 methodologies
DevOps includes the implementation plan while Agile does not
8
Using SQL what is the best way to count the number of records in the Fare_Code_Table?
It cannot be determined
select * from fare_code_table;
count * from fare_code_table;
select count(fare_code) from fare_code_table;
9
What is the correct sequence of 5 common statements in SQL?
Select, From, Where, Order, Group
Select, From, Where, Group, Order
Select, From, Order, Group, Where
Select, From, Join, Group, Where
10
When a system is not providing its intended service, it is known as a what?
Problem
Service failure
ITIL
Auto failover
11
Functional requirements focus on
Defining the business constraints of the system
Defining the technical constraints of the system
Meeting the needs of the business
Meeting the needs of management
12
What is the technology component that is the key to enterprise systems?
Multiple business functions
Shared database
Business process reengineering
Overcomes organization siloes
13
SDLC, Agile, and DevOps are all
business processes
system development methodologies
governance methodologies
tools for aligning business and IT
14
Advantages of open source software are
Superior technical support
Lower cost due to no license fees
Greater innovation
Lower security risk
15
What is the most common obstacle to a successful IT project?
The duration of the project
Amount of change required of the business
The cost of the project
Lack of requirements
16
Which of these is management's preferred choice for new IT systems?
Custom-built systems
COTS - Commercial Off The Shelf systems
Outsourced systems
Open-source systems
17
What are the components in the Theory of Triple Constraints for an IT project?
None of the above
Quality (reqts), Skilled Workers, Governance
Economic (financial), Legal, Ethical
Quality (reqts), Cost, Time
18
What are advantages of COTS software? (Commercial Off The Shelf)
No license fee.
The source code cannot be changed except by the vendor.
Vendor provides supports.
Cost is reduced through economies of scale.
19
Technical (non-functional) requirements focus on
Meeting the needs of the IT organization
Defining the technical constraints of the system
Meeting the needs of management
Defining the business constraints of the system
20
To manage data with a large number of records, for example 100K or more, often the best tool is
an enterprise system
a business process model
a spreadsheet
a database
21
In the ERD of the database table shown below, how many records are in the table?
5
It cannot be determined
1
Greater than 100,000
22
What are benefits of the agile development methodology over SDLC?
Faster delivery of business benefit ($)
Includes the IT operations organization
Able to adapt to change
Provides lowest cost solution
23
Your smart watch is capable of detecting and storing your heart rate. What type of device is your smart watch?
Output device
Input device
Functional device
Smart wearable
24
What are components of a business process?
Pool, swim lanes, actors, tasks
Start, actors, databases, systems, end
All of the above
Inputs, tasks, output
25
In the marketing dept, the inputs, tasks, and output required to initiate a social media campaign define a _________.
business process
waterfall
business process methodology
business process model
26
What is an attribute of a data center?
All of the above
Located on a hill
Resilient to severe weather
Located in or near a desert
