Information Systems
What is an information system?
A data source compiled of multiple forms of technologies to collect, store, process & distribute information.
Name any two Cloud Computing providers
MS Azure, AWS, Google Cloud, Oracle Cloud, VMWare + ,more are valid answers
What is project management?
Project management is the process of leading or managing the work of a team to achieve project goals including managing resources, scope, budget & stakeholder facilitation as well.
What is DevOps short for?
Development Operations
What is data engineering?
Essentially, transforming unstructured data into consumable data layers
What is Business Intelligence?
BI is the process of developing data sources for ingestion into other sources, such as a data warehouse, that will be used to form curated data layers in which insights can be derived from data analysis, data visualizations & general reporting.
What are some of the advantages of Cloud Computing?
Cost reduction in the longer term, through elimination of maintaining on-premise servers, better data storage management through higher-performance through powerful server capabilities
Describe cost benefit analysis
Simply, the benefits from the project with the associated risks and cost
What is Agile?
Agile is a theory and mindset for delivering high build quality product iteratively & incrementally with receiving periodic feedback from the stakeholders and/or customer to maximize value in the shortest time.
Name a tool used for data engineering
SQL, Databricks, ADF, Python libraries, Apache Spark, Kafta, SnowFlake, Amazon Athena..... to name a few
What's the difference between streaming & batch job processing?
Batch jobs are ran periodically & stream jobs are ran practically live
What are some of the main simple differences between on-premise & cloud?
On-premise databases & servers that run applications & systems are just that... On-premise, typically an organization needs to maintain the hardware in a room or warehouse to sustain the technologies.
With cloud, the services or resources are centralized by the cloud provider, therefore, only internet is needed to access resources. Cloud typically has subscriptions to pay for the resources being used.
Whats the difference between project & product management?
Project manager is responsible for ownership over the project, such as budgets, resources, forecasting etc...
Product manager is the owner of the product vision, delivering the roadmap for the vision & producing the product, whether it be physical or digital
You can have DevOps without Agile, but you cannot have Agile without DevOps. True or False
False, DevOps is a integral part of the continuous testing, exploration, integration & delivery cycle of Agile theory. You can practice Agile without implementation of DevOps, but cannot necessarily exercise DevOps without Agile, because DevOps is derived from Agile theory
What is data integrity?
Pertains to data quality which affects accuracy of reporting, business intelligence development & thus insights for decision making.
What's the difference between OLAP & OLTP systems?
OLAP is online analytical processing & OLTP is online transactional processing
Name any of the main differences between public & private or even hybrid cloud environments
Public cloud uses shared infrastructure, while private cloud uses some of the organization's infrastructure. Public cloud, the IT organization bears more responsibility over resources, in private cloud the resources are centralized from the cloud provider.
What's the difference between a PM & SCRUM practitioner?
PM handles project budget, resources, stakeholder management & processes. SCRUM practitioner handles instituting the Agile maturity of a cross-functional team with SCRUM framework. Sometimes a PM can also be the SCRUM master in some environments, but in official SCRUM there is no PM
What's the difference between SCRUM & SAFe?
SCRUM is a framework for developing products within a smaller (<10) cross-functional team environment, user SCRUM events (sprints, planning, stand-up, review, retrospective), roles (PO, SM, Dev's) & artifacts (backlogs, increment)
SAFe is essentially identical in many ways to SCRUM, but is literally 'Scaled Agile Framework' used for larger teams within the context of an organization & has additionally complexities, such as an Agile Release Train.
What does ETL signify?
The extraction of a data source, the transformation of the data then loading into a target layer for consumption
What is the main basis through which relational databases are created, or even which languages?
Through a data model (such as a star-schema), then tables are linked with foreign, primary, surrogate keys.
Language for relational databases is mainly: SQL
What's the main difference between SaaS & PaaS
Simply put, SaaS is Software As A Service & PaaS is Platform as a Service.
PaaS is a cloud computing model that delivers the tools for developing various applications, SaaS is a service model for cloud computing services.What is a critical path or dependency? Describe it in your own words
The critical path is essentially a sequence of dependent tasks which can provide higher efficiency as to the best timeline for a project increment completion.
A functional or technical dependency is an item or element that depends on another for a sequence of events to occur succesfully.
Describe any aspects of DevOps that make it a sound method for producing high build quality?
DevOps uses continuous exploration, integration & delivery to keep it Agile & increase build quality.
Continuous integration operates from the principles of source control, to ensure aspects of code are thoroughly tested before integrated.
What is Data Modeling or name something about data models.
Data models are a way to organize, standardize & make use of unstructured data into a schema for querying or transactional systems.
Or
"Data modeling is the method of documenting complex software design as a diagram so that anyone can easily understand. It is a conceptual representation of data objects that are associated between various data objects and the rules."