PwC Interview Questions, Process, and Tips

Q1. Explain all types of joins
Ans. 
Different types of joins in SQL are inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns rows when there is a match in either table
Answered by AI
Add your answer
Q2. Difference between having and where
Ans. 
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.
• HAVING is used with GROUP BY to filter groups based on aggregate functions results

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROU...read more
Answered by AI
Add your answer

Q1. Working Experienace in current project
Add your answer
Q2. If i have large dataset to load which will not fit into the memory, How will you load the file?
Add your answer
Q3. What is Apache spark?
Ans. 
Apache Spark is an open-source distributed computing system that provides an interface for programming entire clusters with implicit data parallelism and fault tolerance.
• Apache Spark is designed for speed and ease of use in processing large amounts of data.

• It can run programs up to 100x faster than Hadoop MapReduce in memory, or 10x faster on disk.

• Spark provides high-level APIs in Java, Scala, Python, and R, and an opt...read more
Answered by AI
Add your answer
Q4. What are core components of spark?
Ans. 
Core components of Spark include Spark Core, Spark SQL, Spark Streaming, MLlib, and GraphX.
• Spark Core: foundation of the Spark platform, provides basic functionality for distributed data processing

• Spark SQL: module for working with structured data using SQL and DataFrame API

• Spark Streaming: extension of the core Spark API that enables scalable, high-throughput, fault-tolerant stream processing of live data streams

• MLlib...read more
Answered by AI
Add your answer
Q5. If we have streaming data coming from kafka and spark , how will you handle fault tolerance?
Ans. 
Implement fault tolerance by using checkpointing, replication, and monitoring mechanisms.
• Enable checkpointing in Spark Streaming to save the state of the computation periodically to a reliable storage like HDFS or S3.

• Use replication in Kafka to ensure that data is not lost in case of node failures.

• Monitor the health of the Kafka and Spark clusters using tools like Prometheus and Grafana to detect and address issues pro
Answered by AI
Add your answer
Q6. What is hive Architecture?
Ans. 
Hive Architecture is a data warehousing infrastructure built on top of Hadoop for querying and analyzing large datasets.
• Hive uses a language called HiveQL which is similar to SQL for querying data stored in Hadoop.

• It organizes data into tables, partitions, and buckets to optimize queries and improve performance.

• Hive metastore stores metadata about tables, columns, partitions, and their locations.

• Hive queries are conver...read more
Answered by AI
Add your answer
Q7. What is vectorization in ?
Ans. 
Vectorization is the process of converting data into a format that can be easily processed by a computer's CPU or GPU.
• Vectorization allows for parallel processing of data, improving computational efficiency.

• It involves performing operations on entire arrays or matrices at once, rather than on individual elements.

• Examples include using libraries like NumPy in Python to perform vectorized operations on arrays.

• Vectorizati...read more
Answered by AI
Add your answer
Q8. We have to do Vectorization?
Add your answer
Q9. What is partition in hive?
Ans. 
Partition in Hive is a way to organize data in a table into multiple directories based on the values of one or more columns.
• Partitions help in improving query performance by allowing Hive to only read the relevant data directories.

• Partitions are defined when creating a table in Hive using the PARTITIONED BY clause.

• Example: CREATE TABLE table_name (column1 INT, column2 STRING) PARTITIONED BY (column3 STRING);
Answered by AI
Add your answer
Q10. What are functions in SQL?
Ans. 
Functions in SQL are built-in operations that can be used to manipulate data or perform calculations within a database.
• Functions in SQL can be used to perform operations on data, such as mathematical calculations, string manipulation, date/time functions, and more.

• Examples of SQL functions include SUM(), AVG(), CONCAT(), UPPER(), LOWER(), DATE_FORMAT(), and many others.

• Functions can be used in SELECT statements, WHERE ...read more
Answered by AI
Add your answer
Q11. Explain Rank, Dense_rank , row_number
Ans. 
Rank, Dense_rank, and row_number are window functions used in SQL to assign a rank to each row based on a specified order.
• Rank function assigns a unique rank to each row based on the specified order.

• Dense_rank function assigns a unique rank to each row without any gaps based on the specified order.

• Row_number function assigns a unique sequential integer to each row based on the specified order.
Answered by AI
Add your answer

Q1. Do not apply in PwC
Add your answer
Q2. Save yourself from PwC
Add your answer

Its good and better the exam

Q1. Hh enj ekns nmsh skn
Add your answer
Q2. Wnje ejb ekg skha kv ans
Add your answer

Q1. Difference between findElements and findElement?
Ans. 
findElements returns a list of web elements matching the locator, while findElement returns the first web element matching the locator.
• findElements returns a list of web elements, findElement returns the first element

• findElements returns an empty list if no elements are found, findElement throws NoSuchElementException

• findElements is useful for finding multiple elements, findElement is useful for finding a single elemen
Answered by AI
Add your answer
Q2. Coding: take your name as input. Print them letter by letter and print if vowels repeat in your name.
Ans. 
The code takes a name as input, prints each letter, and checks if any vowels repeat in the name.
• Create a function that takes a string input for the name

• Iterate through each letter in the name and print them individually

• Check for vowel repetition by keeping track of vowels encountered
Answered by AI
Add your answer
Q3. What is Fluent wait?
Ans. 
Fluent wait is a dynamic wait mechanism in Selenium WebDriver that waits for a condition to be true before proceeding.
• Fluent wait is used to handle dynamic web elements that may load at different times.

• It can define the maximum amount of time to wait for a condition, as well as the frequency of checking.

• Example: WebDriverWait wait = new WebDriverWait(driver, 10); wait.until(ExpectedConditions.visibilityOfElementLocated
Answered by AI
Add your answer
Q4. Some others selenium questions.
Add your answer
Q5. Tell me about yourself. Role and responsibilities from your previous project.
Ans. 
I am an Automation Engineer with experience in designing and implementing automated test scripts for web applications.
• Designed and implemented automated test scripts using Selenium WebDriver for regression testing

• Collaborated with developers to integrate automated tests into continuous integration pipeline

• Performed manual testing to identify bugs and validate automated test results
Answered by AI
Add your answer