MCQs on Data Preparation and Management | Amazon QuickSight MCQ Questions

Amazon QuickSight is a powerful business intelligence tool enabling organizations to visualize and analyze data effectively. Chapter 2 explores essential topics such as importing and connecting data sources, utilizing data sets and the SPICE engine, and preparing data through cleaning, transforming, and managing data types. Test your knowledge with these Amazon QuickSight MCQ questions and answers.

MCQs: Importing and Connecting Data Sources

1. What types of data sources can Amazon QuickSight connect to?
   a) Only AWS services
   b) Relational databases, files, and APIs
   c) Cloud services only
   d) On-premises servers only
2. Which protocol is commonly used for securely connecting to on-premises data sources in Amazon QuickSight?
   a) HTTPS
   b) ODBC
   c) SSH
   d) JDBC
3. What is a requirement for QuickSight to connect to AWS-hosted databases?
   a) Public IP address
   b) Database credentials
   c) SPICE dataset setup
   d) VPN access
4. What is the primary role of a QuickSight data connector?
   a) Cleaning data
   b) Automating analytics
   c) Establishing a connection to a data source
   d) Performing visualizations
5. When connecting to an S3 bucket as a data source, what format must the data file be in?
   a) Only CSV
   b) CSV, JSON, or Excel
   c) Only Excel
   d) Any format
6. Which QuickSight feature supports querying external datasets without loading them into SPICE?
   a) Direct Query
   b) Data Pipeline
   c) Data Flow
   d) Auto Analysis
7. What must you configure when connecting to a database behind a firewall in QuickSight?
   a) Database password
   b) Security groups and VPC settings
   c) Data transfer limit
   d) Data encoding format
8. How does QuickSight identify data source authentication?
   a) API keys only
   b) IAM roles, credentials, and access keys
   c) IP whitelisting
   d) Static passwords
9. Which of these is NOT a valid data source for QuickSight?
   a) Redshift
   b) Tableau Server
   c) Salesforce
   d) RDS
10. What is required for on-premises data integration in QuickSight?
    a) An IAM role
    b) A QuickSight Enterprise Edition account
    c) A QuickSight data gateway
    d) S3 backup

MCQs: Data Sets and SPICE Engine

11. What does SPICE stand for in Amazon QuickSight?
    a) Super Performance Integrated Cache Engine
    b) Self-Service Performance Integrated Calculation Engine
    c) Superfast Parallel In-Memory Calculation Engine
    d) Scalable Parallel In-Memory Computation Engine
12. What is the maximum row size supported by SPICE?
    a) 10 million rows
    b) 100 million rows
    c) 1 billion rows
    d) Unlimited rows
13. What is a SPICE dataset?
    a) A dataset that resides in Redshift
    b) A dataset loaded into memory for faster querying
    c) A static dataset for visualization
    d) A dataset stored in S3
14. What is the primary advantage of using SPICE?
    a) Real-time analytics
    b) Cost-effectiveness
    c) Faster query performance
    d) Built-in data cleansing
15. How can datasets be shared across QuickSight users?
    a) By exporting them to CSV files
    b) Through SPICE dataset permissions
    c) By enabling IAM access
    d) Through S3 versioning
16. Which of these is NOT true about SPICE?
    a) It can handle large datasets.
    b) SPICE is automatically enabled for all datasets.
    c) SPICE is used to enhance performance.
    d) SPICE has a storage limit based on your QuickSight edition.
17. What is the default data refresh schedule for SPICE datasets?
    a) Every 15 minutes
    b) Every 1 hour
    c) Once daily
    d) Weekly
18. How do you refresh data in SPICE?
    a) Manually export and re-import data
    b) Use the “Refresh Now” option or schedule updates
    c) Create a new dataset
    d) Update database credentials
19. Which of these allows combining multiple datasets in QuickSight?
    a) Data Flow
    b) Data Join
    c) Dataset Union
    d) SPICE Engine
20. What happens when SPICE storage is full?
    a) Data updates are queued.
    b) New data cannot be uploaded.
    c) Old datasets are deleted.
    d) The engine automatically scales.

MCQs: Data Preparation: Cleaning, Transforming, and Data Types

21. Which feature in QuickSight is used to clean data?
    a) Visual Editor
    b) Data Preparation Editor
    c) Data Wrangling Tool
    d) Analysis Editor
22. How can you transform columns in QuickSight datasets?
    a) By writing SQL queries
    b) Using calculated fields and functions
    c) Manually editing each row
    d) Through visualization options
23. What is the primary purpose of data cleaning?
    a) Adding metadata
    b) Improving dataset size
    c) Removing errors and inconsistencies
    d) Creating charts
24. Which option helps convert a string column to a numeric column?
    a) Data Formatting Tool
    b) Data Type Conversion
    c) Calculated Fields
    d) Data Filters
25. What type of data does QuickSight NOT support?
    a) Text
    b) Audio files
    c) Numerical
    d) Date and time
26. How does QuickSight handle missing data during analysis?
    a) Removes the entire dataset
    b) Allows null values
    c) Stops the visualization process
    d) Automatically imputes data
27. What is used to group similar data into categories in QuickSight?
    a) Filters
    b) Hierarchies
    c) Groups
    d) Bins
28. Which feature can split a column into multiple columns?
    a) Text Parsing
    b) Split Function
    c) Pivot Columns
    d) Calculated Fields
29. What type of operation is “merging datasets”?
    a) A visualization operation
    b) A data preparation task
    c) A SPICE function
    d) A QuickSight analysis
30. Which data type is recommended for numerical IDs that will not be used in calculations?
    a) String
    b) Decimal
    c) Integer
    d) Boolean

Answers Table