MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

Overall MCQs for Reference

What is the primary purpose of LookML?
a. To define database schemas
b. To create machine learning models directly
c. To model data for analytics in Looker
d. To design web interfaces
Answer: c. To model data for analytics in Lookermultisoftsystems
In LookML, what is a “view”?
a. An SQL query
b. A visualization type
c. A model for a database table or logical source
d. An end-user dashboard
Answer: c. A model for a database table or logical sourcecloudskillsboost+1
Which parameter specifies the underlying table of a view in LookML?
a. sql_table_name
b. source_table
c. db_table
d. table_reference
Answer: a. sql_table_namecloudskillsboost+1
How do you reference a field in LookML?
a. {field}
b. ${field}
c. @field
d. #field
Answer: b. ${field}cloudskillsboost+1
Which element is optional in a LookML project structure?
a. Model file
b. View file
c. Manifest file
d. Explore file
Answer: c. Manifest filemultisoftsystems
What is an “explore” in LookML?
a. A method for querying external APIs
b. The definition of a set of related views
c. The developer’s workspace
d. A UI customization element
Answer: b. The definition of a set of related viewscloudskillsboost+1
In LookML, which object defines join relationships?
a. Dashboard
b. Explore
c. Manifest file
d. View
Answer: b. Explorecloudskillsboost+1
Which join type is NOT supported in LookML?
a. inner
b. left_outer
c. right_outer
d. full_outer
Answer: d. full_outermultisoftsystems
What is LookML’s main advantage for machine learning workflows?
a. In-built model training
b. SQL abstraction and dynamic data modeling
c. Python integration only
d. Limited database connections
Answer: b. SQL abstraction and dynamic data modelingyoutubemultisoftsystems
Which of these can LookML integrate with for machine learning deployment?
a. Only Python scripts
b. BigQuery ML, Amazon SageMaker, DataRobot
c. Only R libraries
d. Custom HTML dashboards
Answer: b. BigQuery ML, Amazon SageMaker, DataRobotyoutubemultisoftsystems
What is the role of the dimension parameter?
a. To create joins
b. To define a field for analysis or grouping
c. To filter SQL results
d. To style dashboards
Answer: b. To define a field for analysis or groupingmultisoftsystems
Which LookML object would you update to add new calculated fields?
a. Model file
b. Explore file
c. View file
d. Manifest file
Answer: c. View filecloudskillsboost+1
How can LookML support ML model results visualization?
a. Uploads raw model
b. Imports model weights
c. Connects model outputs to dashboards via SQL
d. Only manual CSV upload
Answer: c. Connects model outputs to dashboards via SQLyoutube
What is a derived table in LookML?
a. Temporary storage structure
b. Table formed from a SQL query in the view
c. A permanent database table
d. An external file import
Answer: b. Table formed from a SQL query in the viewmultisoftsystems
Which field type is used for metrics like sums, counts, averages?
a. Dimension
b. Measure
c. Filter
d. Parameter
Answer: b. Measuremultisoftsystems
In LookML, the “persist_for” parameter in a derived table means:
a. Table will never refresh
b. Controls caching duration
c. Disables joins
d. Sets user permissions
Answer: b. Controls caching durationmultisoftsystems
What is the purpose of the “sql_always_where” parameter?
a. Force a SQL condition on every query
b. Create dynamic filters
c. Control caching
d. Set visualization type
Answer: a. Force a SQL condition on every querymultisoftsystems
Parameter fields in LookML allow:
a. Input from users for dynamic filtering
b. Defining measures
c. Setting join keys
d. Changing SQL dialect
Answer: a. Input from users for dynamic filteringmultisoftsystems
The LookML model file primarily controls:
a. Visualization themes
b. Database connections and explores
c. Source table definitions
d. View field definitions
Answer: b. Database connections and explorescloudskillsboost+1
Which of the following is NOT true about LookML’s version control?
a. Version control is optional
b. Built on Git integration
c. Required for deployment to production
d. Only supports one developer at a time
Answer: d. Only supports one developer at a timemultisoftsystems
Which type of join increases query speed but may return incomplete results?
a. Full outer join
b. Left join
c. Cross join
d. Inner join
Answer: d. Inner joinmultisoftsystems
What is the LookML “extension” parameter used for?
a. Redefine or inherit view fields
b. Create user access controls
c. Change join types
d. Manage caching
Answer: a. Redefine or inherit view fieldsmultisoftsystems
To secure sensitive data in LookML, which practice is recommended?
a. Encrypt all measures
b. Use access_filter parameters to restrict access
c. Only use dimensions
d. Avoid persistent derived tables
Answer: b. Use access_filter parameters to restrict accessmultisoftsystems
Which LookML feature helps non-technical users self-serve data analysis?
a. SQL snippets
b. Explores and dashboards
c. Raw database access
d. Manifest definition
Answer: b. Explores and dashboardsmultisoftsystems
What is LookML’s approach for reusable code and DRY principle?
a. Copying code between projects
b. Using includes and extensions
c. Defining manual functions
d. Exporting CSV files
Answer: b. Using includes and extensionsmultisoftsystems
Which statement correctly describes a measure in LookML?
a. Is used only for filtering
b. Defines aggregations like SUM, COUNT
c. Is never used in visualization
d. Cannot be customized
Answer: b. Defines aggregations like SUM, COUNTmultisoftsystems
Which object cannot be joined directly in LookML?
a. Explore to explore
b. Explore to view
c. Explore to dashboard
d. Explore to derived table
Answer: a. Explore to explorecloudskillsboost+1
What type of data source can Looker Studio (with LookML) connect to?
a. Only email servers
b. Only text files
c. Databases, Google Marketing Platform, cloud apps
d. Only manual uploads
Answer: c. Databases, Google Marketing Platform, cloud appswayground
What is the main use of the manifest file in LookML?
a. Store passwords
b. Define project-level settings and extensions
c. Create database schemas
d. Build dashboards
Answer: b. Define project-level settings and extensionsmultisoftsystems
When using Looker with BQML, what does LookML provide?
a. Data quality checks
b. Model training management, access to BQML predictions
c. Only visualization
d. Schema migration tools
Answer: b. Model training management, access to BQML predictionsyoutube
LookML’s “required_fields” parameter means:
a. These fields must be selected in queries
b. They’re hidden by default
c. Only available to admins
d. Disabled for joins
Answer: a. These fields must be selected in queriesmultisoftsystems
Which describes a LookML “set”?
a. A group of fields for filter or display
b. A group of users
c. A SQL statement
d. A display template
Answer: a. A group of fields for filter or displaymultisoftsystems
In LookML, what does “sql: ${TABLE}.field_name ;” do?
a. Runs a Python query
b. References a field from the base table
c. Imports external data
d. Creates a new explore
Answer: b. References a field from the base tablecloudskillsboost+1
What is a LookML Persistent Derived Table (PDT)?
a. A cached result of a SQL query in Looker
b. An ephemeral table that disappears after query
c. A visualization template
d. User session data
Answer: a. A cached result of a SQL query in Lookermultisoftsystems
How can LookML handle slowly changing dimensions in data warehouses?
a. It does not support this feature
b. By using derived tables with date filtering
c. Through access_filter only
d. Disabling all joins
Answer: b. By using derived tables with date filteringmultisoftsystems
What happens if you reference a field not defined in the view’s SQL table?
a. Query fails with error
b. Returns null values
c. Uses default value
d. Automates schema mapping
Answer: a. Query fails with errorcloudskillsboost+1
The LookML parameter “hidden: yes” is used to:
a. Prevent field from being shown to users
b. Hide the table in the database
c. Delete field permanently
d. Make fields read-only
Answer: a. Prevent field from being shown to usersmultisoftsystems
If a LookML view describes a database table, which parameter must be present?
a. source_table
b. sql_table_name
c. view_reference
d. data_import
Answer: b. sql_table_namecloudskillsboost+1
Which process improves Looker dashboard load time?
a. Disable all joins
b. Use persistent derived tables (PDTs)
c. Create large visualizations
d. Only use dimensions
Answer: b. Use persistent derived tables (PDTs)multisoftsystems
What triggers PDT regeneration in Looker?
a. User login
b. Set schedule or data update
c. Viewing a dashboard
d. Manual CSV import
Answer: b. Set schedule or data updatemultisoftsystems
To add business logic to field calculations in LookML, use:
a. Static tables
b. SQL functions within field definitions
c. Only Python scripts
d. External database triggers
Answer: b. SQL functions within field definitionsmultisoftsystems
Which describes “access_grant” in LookML?
a. Controls data access based on user attributes
b. Assigns developer permissions
c. Sets visualization colors
d. Schedules table refresh
Answer: a. Controls data access based on user attributesmultisoftsystems
What is the LookML “project”?
a. A database schema file
b. A collection of LookML files
c. A code snippet repository
d. A machine learning library
Answer: b. A collection of LookML filesmultisoftsystems
In LookML’s workflow, Git integration mainly enables:
a. Collaboration and version control in development
b. Only single-user editing
c. Undo button for queries
d. App marketplace usage
Answer: a. Collaboration and version control in developmentmultisoftsystems
How does LookML support “agile analytics”?
a. By making data transformation static
b. By enabling fast, modular changes to data modeling and dashboards
c. By blocking all data edits
d. By disabling dashboard sharing
Answer: b. By enabling fast, modular changes to data modeling and dashboardsmultisoftsystems
What is a benefit of separating LookML views and models?
a. Reduces SQL errors
b. Decouples data source logic from business logic
c. Enables advanced visualization
d. Only allows static modeling
Answer: b. Decouples data source logic from business logicmultisoftsystems
In LookML, what does “always_filter” do?
a. Forces a specified filter in every explore query
b. Adds filter to dashboards only
c. Disables filter completely
d. Controls view access
Answer: a. Forces a specified filter in every explore querymultisoftsystems
Which is a best practice for LookML model organization?
a. Put all logic in one view
b. Use separate files for views, explores, and dashboards
c. Avoid field naming conventions
d. Update only production files directly
Answer: b. Use separate files for views, explores, and dashboardsmultisoftsystems
What is the function of the “description” parameter in LookML objects?
a. Defines the field calculation
b. Documents purpose for users/developers
c. Schedules data updates
d. Joins field with another field
Answer: b. Documents purpose for users/developersexams4sure+1
How do LookML data modeling skills contribute to machine learning projects?
a. Only allow visualization
b. Enable robust, scalable data preparation and integration with ML tools
c. Automate model hyperparameter tuning
d. Restrict database connections
Answer: b. Enable robust, scalable data preparation and integration with ML toolsyoutubemultisoftsystems

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info