Which cloud platform offers services like Google Compute Engine and Google Kubernetes Engine?
- Amazon Web Services (AWS)
- Google Cloud Platform (GCP)
- IBM Cloud
- Microsoft Azure
Google Cloud Platform (GCP) offers services like Google Compute Engine (IaaS) and Google Kubernetes Engine (Container Orchestration). GCP provides a range of cloud services and is known for its data analytics and machine learning capabilities.
Which principle suggests that infrastructure changes should be reversible?
- Consistency
- Idempotency
- Immutability
- Reversibility
The principle of reversibility suggests that infrastructure changes should be reversible. This means that any changes made to the infrastructure can be rolled back, providing a safety net in case of errors or unexpected issues.
_______ logging refers to the practice of correlating log entries from different services or components to trace a request's path through a distributed system.
- Aggregated
- Centralized
- Cross-cutting
- Distributed
Distributed logging refers to the practice of correlating log entries from different services or components to trace a request's path through a distributed system. It is crucial for debugging and understanding the flow of requests in complex, interconnected systems.
A common branching strategy where developers create a new branch for each new feature is called _______.
- Feature Branching
- Hotfix Branching
- Master Branching
- Release Branching
Feature Branching is a common branching strategy where developers create a new branch for each new feature they are working on. This approach helps in isolating changes related to a specific feature and facilitates parallel development.
You're tasked with optimizing a database query that takes a long time to execute. What strategies would you employ to improve its performance?
- Increase database server memory
- Index the relevant columns
- Normalize the database schema
- Utilize caching mechanisms
Indexing the relevant columns is a key strategy for optimizing database queries. It helps speed up data retrieval by creating efficient access paths to the required information, reducing query execution time.
What does OAuth primarily focus on in terms of user authorization?
- Delegated access to resources
- Encryption of user data
- Password hashing
- Two-factor authentication
OAuth primarily focuses on delegated access to resources. It allows one service to perform actions on behalf of a user, without exposing their credentials.
Which SQL command is used to add a new row to a database table?
- ADD
- INSERT
- MODIFY
- UPDATE
The INSERT SQL command is used to add a new row to a database table. It allows you to insert data into a specified table.
What is a common language used for defining infrastructure as code?
- HTML
- JSON
- XML
- YAML
JSON (JavaScript Object Notation) is a common language used for defining infrastructure as code. It is a lightweight and human-readable data interchange format, making it well-suited for configuration files. YAML is another popular choice for its simplicity and readability in configuration management.
In Agile methodology, what is the primary focus of the sprint retrospective?
- Continuous Improvement
- Daily Standup
- Product Backlog Refinement
- Sprint Planning
The primary focus of the sprint retrospective in Agile methodology is continuous improvement. It provides a dedicated time for the team to reflect on the just-concluded sprint, identify what went well, what could be improved, and collaboratively implement changes for the next sprint.
You're tasked with implementing a many-to-many relationship between two tables in a database. How would you achieve this using SQL?
- Create a Junction Table
- Use Foreign Keys and Triggers
- Implement Subqueries
- Utilize Views and Stored Procedures
To implement a many-to-many relationship in a database, creating a Junction Table is a common approach. This involves creating a separate table to represent the relationship between the two entities. The correct option suggests using a Junction Table.