Download Cloud Data Engineer Python For - China/India/Philippines Exam and more Exams Technology in PDF only on Docsity!
China/India/Philippines Exam
Question 1. Which Python data structure is most suitable for ensuring unique elements in a collection? A) List B) Tuple C) Set D) Dictionary Answer: C Explanation: Sets in Python automatically enforce uniqueness among their elements, making them ideal for storing collections of unique items. Question 2. What is the primary purpose of the 'with' statement in Python file handling? A) To open a file for writing only
China/India/Philippines Exam
B) To automatically manage resource cleanup after file operations C) To handle exceptions during file operations D) To read files faster Answer: B Explanation: The 'with' statement ensures that resources like files are properly closed after their suite finishes execution, even if errors occur. Question 3. Which Python feature allows code reuse through inheritance? A) Functions B) Modules C) Classes D) Decorators
China/India/Philippines Exam
Question 5. Which command is used to create a virtual environment in Python? A) pip install venv B) python - m venv env C) conda create env D) virtualenv activate Answer: B Explanation: 'python - m venv env' creates an isolated virtual environment, which helps manage project dependencies separately. Question 6. In pandas, which method is used to combine two DataFrames based on common columns? A) merge()
China/India/Philippines Exam
B) concat() C) join() D) combine() Answer: A Explanation: pandas.merge() performs database-style joins, combining DataFrames based on common keys or columns. Question 7. Which NumPy function is used to create an array filled with zeros? A) numpy.ones() B) numpy.zeros() C) numpy.empty() D) numpy.full()
China/India/Philippines Exam
Question 9. Which cloud SDK is used to interact with Google Cloud Storage in Python? A) boto B) google-cloud-storage C) azure-storage-blob D) cloud-sdk-python Answer: B Explanation: google-cloud-storage is the official Python client library for Google Cloud Storage, enabling programmatic data management. Question 10. In Spark, which Python API is used for large-scale data processing? A) PyData
China/India/Philippines Exam
B) PySpark C) Dask D) Pandas-on-Spark Answer: B Explanation: PySpark provides the Python interface to Apache Spark, enabling distributed data processing at scale. Question 11. Which Python package is most suitable for connecting to Amazon Redshift? A) psycopg B) pyodbc C) mysql-connector-python D) redis-py
China/India/Philippines Exam
Question 13. Which of the following is a key benefit of using virtual environments in Python? A) Faster code execution B) Isolated dependency management C) Automatic code optimization D) Built-in code version control Answer: B Explanation: Virtual environments isolate project dependencies, preventing conflicts between packages across projects. Question 14. In pandas, which method is used to handle missing data by filling with a specified value?
China/India/Philippines Exam
A) dropna() B) fillna() C) replace() D) interpolate() Answer: B Explanation: fillna() replaces missing values with a specified constant or computed value, aiding in data cleaning. Question 15. Which NumPy function performs element-wise addition of two arrays? A) numpy.dot() B) numpy.add() C) numpy.multiply()
China/India/Philippines Exam
Explanation: The json module provides functions to parse JSON strings and convert Python objects to JSON format. Question 17. Which method in pandas is used to reshape data via pivot tables? A) melt() B) pivot() C) stack() D) transpose() Answer: B Explanation: pivot() reshapes data based on unique values of specified columns, useful for creating pivot tables.
China/India/Philippines Exam
Question 18. Which cloud platform provides BigQuery as a managed data warehouse service? A) AWS B) Google Cloud C) Azure D) IBM Cloud Answer: B Explanation: Google BigQuery is a serverless, fully-managed cloud data warehouse service on Google Cloud Platform. Question 19. Which Python package is primarily used for interacting with Snowflake databases? A) snowflake-connector-python
China/India/Philippines Exam
Answer: B Explanation: Apache Spark enables scalable, distributed data processing, and PySpark provides Python bindings for Spark. Question 21. Which Python library is used to perform data transformation and cleaning? A) NumPy B) pandas C) Matplotlib D) scikit-learn Answer: B Explanation: pandas offers extensive data manipulation and cleaning capabilities, making it essential for data transformation.
China/India/Philippines Exam
Question 22. Which method in pandas allows merging DataFrames based on index? A) merge() B) join() C) concat() D) combine() Answer: B Explanation: DataFrame.join() merges DataFrames based on index or key columns, facilitating relational data operations. Question 23. In NumPy, what does the function 'numpy.linalg.inv()' compute? A) Eigenvalues
China/India/Philippines Exam
Answer: B Explanation: scikit-learn provides simple and efficient tools for predictive data analysis and machine learning. Question 25. Which cloud storage service uses the Python SDK 'boto3'? A) Google Cloud Storage B) Azure Blob Storage C) Amazon S D) IBM Cloud Object Storage Answer: C Explanation: boto3 is the Amazon Web Services SDK for Python, primarily used for interacting with S3.
China/India/Philippines Exam
Question 26. What is a key characteristic of serverless data pipelines? A) They require dedicated servers B) They are event-driven and automatically scale C) They need manual resource provisioning D) They only work with on-premises infrastructure Answer: B Explanation: Serverless pipelines are event-driven, automatically scalable, and do not require managing underlying servers. Question 27. Which pandas function is used to combine multiple DataFrames along rows? A) merge() B) concat()
