Looker LookML Developer Questions and Answers 2023
with complete solution
True or False: A model file specifies a database connection and the set of Explores that
use that connection. A model file also defines the Explores themselves and their
relationships to other views.
True
True or False: In SQL terms, an Explore is the FROM clause of a query.
True
When creating a LookML project, what option do you use to leave prefixes out of view
names?
Ignore Prefixes
Looker developers use the LookML ________________ parameter to specify in the
model file which connection the model should use
Connection
True or False: When a model is pushed to production for the first time, a model does not
have to be configured
False. When a model is pushed to production for the first time, the model MUST be
configured; otherwise, any queries on that model will fail once the model is in
Production Mode
In Looker, a ______________ is a collection of files that describe the objects,
connections, and user interface elements that will be used to carry out SQL queries for
your Looker users
Project
What are the parts of a Looker project?
Model Files
View Files
Other Files (Dashboard files, Data files, Document files)
What are the three options for creating a new LookML Project?
Generate Model from Database schema
Clone Public Git Repository
Blank Project
Configuring a model is useful for what key reasons?
It specifies that a given model name refers to a particular model in a particular project
It sets the connections the model is allowed to use
True or False: If a view does not contain either the sql_table_name or the derived_table
parameter, Looker assumes that the view is based on a database table, and that the
name of the database table matches the name of the view
True
What database conditions do federated joins require?
Use the same SQL dialect
Reside on the same physical machine
, Are accessible from the same connection in Looker
True or False: The duration type works with a dimension_group and a regular
dimension
False. Duration works only with a dimension_group and will not work with a regular
dimension.
What are the three main parameters of the dimension duration type?
sql_start and sql_end
intervals
datatype (optional - If the dimension group is not based on a datetime you may specify
an epoch, timestamp, date, or yyyymmdd format instead)
For time, timeframe options, what does the "X" do in hourX and minuteX?
Splits each day or hour, respectively, into the specified units of time.
In hourX the X is replaced with 2, 3, 4, 6, 8, or 12
In minuteX the X is replaced with 2, 3, 4, 5, 6, 10, 12, 15, 20, or 30
What are the two key parameters for dimension location type?
sql_latitude:${field_name_1}
sql_longitude:${field_name_2}
What are the two key parameters for dimension distance type?
start_location_field
end_location_field
Note these are predefined location dimensions
What dimension type creates buckets or bins from a numeric dimension?
Tier
True or False: The unquoted dimension type is only with parameter fields
True
What dimension type can be used to plot on a static map visualization?
zipcode
True or False: It is possible to create one dimension or filter field for each individual time
frame you want to include, instead of generating all of them in a single dimension_group
True
True or False: It is not possible to create one dimension for each individual duration
False. It is possible to create one dimension for each individual duration you want to
include, instead of generating all of them in a single dimension_group
A measure can only have one type, and defaults to ___________ if no type is specified
string
What are the measure type categories?
Aggregate measures
Non-aggregate measures
with complete solution
True or False: A model file specifies a database connection and the set of Explores that
use that connection. A model file also defines the Explores themselves and their
relationships to other views.
True
True or False: In SQL terms, an Explore is the FROM clause of a query.
True
When creating a LookML project, what option do you use to leave prefixes out of view
names?
Ignore Prefixes
Looker developers use the LookML ________________ parameter to specify in the
model file which connection the model should use
Connection
True or False: When a model is pushed to production for the first time, a model does not
have to be configured
False. When a model is pushed to production for the first time, the model MUST be
configured; otherwise, any queries on that model will fail once the model is in
Production Mode
In Looker, a ______________ is a collection of files that describe the objects,
connections, and user interface elements that will be used to carry out SQL queries for
your Looker users
Project
What are the parts of a Looker project?
Model Files
View Files
Other Files (Dashboard files, Data files, Document files)
What are the three options for creating a new LookML Project?
Generate Model from Database schema
Clone Public Git Repository
Blank Project
Configuring a model is useful for what key reasons?
It specifies that a given model name refers to a particular model in a particular project
It sets the connections the model is allowed to use
True or False: If a view does not contain either the sql_table_name or the derived_table
parameter, Looker assumes that the view is based on a database table, and that the
name of the database table matches the name of the view
True
What database conditions do federated joins require?
Use the same SQL dialect
Reside on the same physical machine
, Are accessible from the same connection in Looker
True or False: The duration type works with a dimension_group and a regular
dimension
False. Duration works only with a dimension_group and will not work with a regular
dimension.
What are the three main parameters of the dimension duration type?
sql_start and sql_end
intervals
datatype (optional - If the dimension group is not based on a datetime you may specify
an epoch, timestamp, date, or yyyymmdd format instead)
For time, timeframe options, what does the "X" do in hourX and minuteX?
Splits each day or hour, respectively, into the specified units of time.
In hourX the X is replaced with 2, 3, 4, 6, 8, or 12
In minuteX the X is replaced with 2, 3, 4, 5, 6, 10, 12, 15, 20, or 30
What are the two key parameters for dimension location type?
sql_latitude:${field_name_1}
sql_longitude:${field_name_2}
What are the two key parameters for dimension distance type?
start_location_field
end_location_field
Note these are predefined location dimensions
What dimension type creates buckets or bins from a numeric dimension?
Tier
True or False: The unquoted dimension type is only with parameter fields
True
What dimension type can be used to plot on a static map visualization?
zipcode
True or False: It is possible to create one dimension or filter field for each individual time
frame you want to include, instead of generating all of them in a single dimension_group
True
True or False: It is not possible to create one dimension for each individual duration
False. It is possible to create one dimension for each individual duration you want to
include, instead of generating all of them in a single dimension_group
A measure can only have one type, and defaults to ___________ if no type is specified
string
What are the measure type categories?
Aggregate measures
Non-aggregate measures
