PwC Interview Questions, Process, and Tips for Experienced

Deployment of Angular application involves building the application and hosting it on a server.

• Build the Angular application using 'ng build' command

• Copy the generated files from the 'dist' folder to the server

• Configure the server to serve the Angular application

• Use tools like Jenkins or GitLab CI/CD for automated deployment

Jenkins is a popular automation tool used for continuous integration and deployment.

• Jenkins helps automate the deployment process by allowing developers to define pipelines for building, testing, and deploying code.

• It integrates with version control systems like Git to trigger builds automatically when new code is pushed.

• Jenkins can be configured to deploy code to various environments such as development, staging, and ...read more

Bigquery handles various types of jobs including querying, loading, exporting, and copying data.

• Querying data for analysis and reporting

• Loading data into Bigquery for storage and processing

• Exporting data from Bigquery to other systems

• Copying data within Bigquery or to other destinations

To find out errors in a failed BigQuery query, check the query job history and error message details.

• Check the query job history in the BigQuery console for details on the failed query.

• Look for error messages in the job history to identify the specific issue that caused the query to fail.

• Review the query syntax and data being queried to troubleshoot common errors such as syntax errors or data type mismatches.

Best practices for writing queries in Bigquery

• Use standard SQL syntax for better performance and compatibility

• Avoid using SELECT * and instead specify only the columns needed

• Optimize queries by using appropriate functions and operators

• Use query caching to reduce costs and improve performance

• Partition tables and use clustering to improve query performance

Pub-sub mechanism is a messaging pattern where senders (publishers) of messages are decoupled from receivers (subscribers).

• Pub-sub stands for publish-subscribe.

• Publishers send messages to a topic, and subscribers receive messages from that topic.

• Google Cloud Pub/Sub is a fully-managed real-time messaging service that allows you to send and receive messages between independent applications.

• In my project, we used Google ...read more

Indexing in SQL is used to improve the performance of queries by creating indexes on columns in tables.

• Indexes can be created on columns that are frequently used in WHERE, JOIN, and ORDER BY clauses.

• Indexes can speed up query performance by allowing the database to quickly locate rows based on the indexed columns.

• Primary keys automatically create a unique index on the column(s) specified.

• Examples: CREATE INDEX idx_name...read more