Exam 2 Flashcards
(20 cards)
What is the primary function of an Operating System (OS)?
To store user files permanently
To direct the computer hardware what to do
To provide internet connectivity
To run specific application software only
To direct the computer hardware what to do
Which SQL clause is used to filter rows based on specified conditions?
FROM
ORDER BY
SELECT
WHERE
WHERE
Which type of AI focuses on using large quantities of data to train models to produce content?
Artificial General Intelligence (AGI)
Machine Learning (ML)
Generative AI (GenAI)
Expert Systems
Generative AI (GenAI)
What is the purpose of the JOIN clause in SQL?
To filter rows based on a condition
To combine rows from two or more tables based on a related column
To sort the results
To delete data from a table
To combine rows from two or more tables based on a related column
Which management area focuses on determining potential areas of high risk and developing strategies to reduce them?
Scope Management
Quality Management
Time Management
Risk Management
Risk Management
Which question best describes the focus of Predictive Analytics?
What happened in the past?
Why did it happen?
What is likely to happen in the future?
What should we do about it?
What is likely to happen in the future?
A startup company is launching a new web application and anticipates rapid user growth, but has limited upfront capital. Which IT infrastructure model would likely be most advantageous due to its scalability and pay-as-you-go nature?
Traditional On-premise servers
Cloud Computing (Public Cloud)
Private Data Center
Mainframe Computing
Cloud Computing (Public Cloud)
Which analytics category uses techniques like optimization and simulation to recommend specific actions?
Descriptive Analytics
Predictive Analytics
Prescriptive Analytics
Diagnostic Analytics
Prescriptive Analytics
What is a significant limitation or risk associated with Large Language Models (LLMs) highlighted in the slides?
Low prediction accuracy
Inability to process text data
Hallucinations (making up false content)
Requirement for small datasets
Hallucinations (making up false content)
A company wants its employees to securely access the internal company network and resources while working remotely from home or traveling. Which technology is specifically designed for this purpose?
Local Area Network (LAN)
Wide Area Network (WAN)
Virtual Private Network (VPN)
Domain Name System (DNS)
Virtual Private Network (VPN)
What does DNS (Domain Name System) primarily do?
Encrypts network traffic
Assigns IP addresses to devices
Converts human-readable domain names into IP addresses
Manages the physical connection medium
Converts human-readable domain names into IP addresses
What technology allows running multiple operating systems (like Windows or Linux) on a single physical machine?
Network Interface Card (NIC)
Virtual Machines (VMs)
Solid State Drive (SSD)
Router
Virtual Machines (VMs)
What is the core idea behind “Data Storytelling”?
Focusing solely on statistical significance
Using complex statistical formulas exclusively
Communicating insights effectively using narrative and visuals
Using only text-based reports
Communicating insights effectively using narrative and visuals
In project management, what does the “Critical Path” represent?
The list of all project stakeholders
The tasks with the most available slack time
The sequence of tasks that determines the shortest possible project duration
The project’s communication plan
The sequence of tasks that determines the shortest possible project duration
What is the purpose of normalization in database design?
To enforce data types strictly
To streamline data groupings and minimize redundant data elements
To improve physical storage speed
To define user access permissions
To streamline data groupings and minimize redundant data elements
Which computer component is considered volatile memory?
Solid State Drive (SSD)
Hard Disk Drive (HDD)
RAM (Random Access Memory)
Thumb Drive
RAM (Random Access Memory)
In the CREATE TABLE statement, what does the REFERENCES keyword typically indicate?
A primary key constraint
A data type definition
A foreign key relationship to another table
A command to delete the table
A foreign key relationship to another table
Which SQL command would return only unique values from a specific column?
SELECT UNIQUE col_name FROM table_name;
SELECT DIFFERENT col_name FROM table_name;
SELECT DISTINCT col_name FROM table_name;
SELECT ALL col_name FROM table_name;
SELECT DISTINCT col_name FROM table_name;
After analyzing past sales data, the retail manager wants to forecast sales for the next quarter based on current trends and planned marketing campaigns. Which type of analytics is needed for this?
Descriptive Analytics
Predictive Analytics
Prescriptive Analytics
Diagnostic Analytics
Predictive Analytics
An online store wants to analyze which products are frequently purchased together (like the ‘beer and diapers’ example). Which database concept/technique is fundamental to enabling this type of market basket analysis?
Deleting customer purchase history regularly
Using only fact tables
Proper use of primary and foreign keys to link customer orders and products
Using only descriptive analytics
Proper use of primary and foreign keys to link customer orders and products
