Looker LookML Developer Practice Test

These questions are part of the practice quiz. Start practicing

• In SQL terms, what does an Explore represent in Looker?
• Does the always_filter parameter override a default_value filter setting?
• In LookML, what is the purpose of the sql_trigger parameter?
• Using which feature can you create a query from an Explore and then merge queries from other Explores into one table?
• What happens to the datagroup when the sql_trigger parameter returns a different value than the previous result?
• A Looker project typically contains one or more ______________files that contain parameters defining a model and its Explores and joins.
• What does the 'view' file in LookML primarily define?
• What are the three options for creating a new LookML Project?
• Which file is used to import LookML files from a different project and specify the current project's name and external project location?
• True or False: You can use the group_label to change the default organization of the Explore menu.
• Which of the following is an example of a derived table in Looker?
• Can you convert a measure back into a dimension in SQL Runner?
• What defines a field's description dynamically in different queries?
• When creating an Explore, what must be included in its definition?
• To extend a LookML object, which parameter must be added to indicate the new object's relationship?
• What is the correct syntax to reference one derived table in the definition of another?
• Which of the following is NOT a part of a Looker project?
• Why is it important to use the always_join parameter correctly?
• Which option should you choose to create multiple Explores from the same view while referencing fields uniformly?
• What field configures the maximum number of persistent tables that can be built in parallel for the connection?
• To reference an interval value in a dimension_group of type: duration, what syntax is required?
• If multiple accounts are set up in a LookML project, whose Git account performs Git operations?
• What join parameter allows you to write the raw SQL that will join a view to an Explore?
• What are the two key parameters for dimension location type?
• How can you apply a datagroup's caching policy?
• Use which keyword under the explore parameter to specify a datagroup caching policy to use for that specific Explore?
• What will happen if user-specific settings conflict with group settings in Looker?
• When might you want to use the "-" syntax in an Explore?
• Persistence should not be added to derived tables that will be what?
• What function does the always_join parameter serve in Looker?
• What happens if there are conflicts between a new object and the object it is extending?
• True or False: Business logic should be applied within joins whenever possible.
• What are the two key parameters for dimension distance type?
• Which best describes the function of a sql_trigger value?
• For content validation, if you group by Folder or by Content, the buttons apply to _________________ occurrence of the error in a single Look or tile.
• Is it true or false that a development version of a PDT will always persist for a maximum of 24 hours?
• Which of the following is NOT typically a reason to define a datagroup in LookML?
• What parameter sets the maximum amount of time that a persistent derived table may be used before it is regenerated?
• What parameter enables the definition of default filters that users can override when they apply a filter from a second list?
• True or False: If you are using the sql_trigger_value parameter to trigger your PDT rebuilds, you can't use the ${derived_table_or_view_name.SQL_TABLE_NAME} syntax with sql_trigger_value.
• When can a developer use the advanced deploy mode feature in Looker?
• What permission level allows users to override persistence setting and rebuild PDTs for the latest data?
• What is the result of using the 'persist_with' keyword in an Explore?
• Which parameter is crucial when referencing a SQL column in sql_always_where from a joined view?
• In which context can you use a datagroup's caching policy?
• What is the default time period after which Looker invalidates cached results?
• What is the purpose of the sql_always_having parameter in Looker?
• Do you need to configure a generic Git user account with read access for Looker to pull the production version of files in a project with multiple accounts?
• What does the Content Validator NOT show errors for?
• In the timeframe options, what does the "X" signify in hourX and minuteX?
• True or False: If your Looker admin has enabled the SQL Runner Vis Labs feature, you cannot create visualizations directly in SQL Runner.
• True or False: If you import a project, you will need to create a folder.
• What does a LookML view typically represent?
• When creating a measure, if no aggregation type is specified, what is implied?
• Which parameter lets you specify the datagroup for caching policy in a derived table?
• True or False: You cannot add results from SQL Runner to a project.
• True or False: After enabling advanced deploy mode, Looker will still utilize the default deployment methods.
• True or False: The persistence of a PDT affects its availability in different Looker environments.
• Can a user remove all filters when conditionally_filter is employed?
• What parameter should be used to force users to use a specific set of filters while allowing them to change the default value?
• True or False: When advanced deploy mode is enabled, developers can still use the deploy to production button.
• Can database connections be configured to use user attributes from the Connections page in the Admin section of Looker?
• True or False: You cannot use the Content Validator to remove fields from custom filters, custom fields, nor table calculations.
• What are the three main parameters of the dimension duration type?
• In Looker, how does a user add a field to a set?
• What parameter specifies a default value for filter and parameter fields?
• What character is used to exclude a field from a set in LookML?
• A user attribute configured to be editable by users can still be used for what purpose?
• True or False: The unquoted dimension type is only with parameter fields.
• True or False: With the default Looker Git integration, developers deploy their latest commit to the production branch.
• True or False: The SQL expression for type: yesno dimensions can include aggregations.
• Does Looker share PDTs between users?
• What does the parameter label do in Looker?
• What is the primary function of a model file in Looker?
• True or False: The duration type works with a dimension_group and a regular dimension.
• What does the percent_of_total feature calculate?
• What is defined as a collection of files describing the objects, connections, and user interface elements in Looker?
• What is the difference between sql_trigger and sql_trigger_value?
• True or False: By default, weeks in Looker start on Monday.
• True or False: The foreign_key must reference a dimension name, not a column name.
• The _____________ parameter provides alternative names for a field that might appear in the URL for a query.
• Use datagroup to assign a caching policy to which components?
• For content validation, if you group by Error, the buttons apply to ___________________ occurrences of that error in all Looks and tiles on your Looker instance.
• True or False: When using include, LookML is not case sensitive.
• True or False: If you use datagroup_trigger for your derived table, you don't need to use the sql_trigger_value or persist_for parameters.
• What is the purpose of intervals in the dimension duration type?
• How are cached results of Explores affected when a datagroup transitions to a triggered state?
• True or False: LookML separates structure from content, so the query structure is independent of the query content.
• Which of the following best describes the use of latitude and longitude in Looker?
• How can you identify conflicts in object extensions effectively?
• True or False: The fields parameter in a join can use the ALL_FIELDS set.
• If you are using Git for project version control, one what constitutes a single Git repository?
• What is the purpose of a project manifest file in Looker?
• When dimension types are grouped, what characteristic is unique about the tier type?
• Can dimensions be converted to measures in SQL Runner results?
• True or False: An NDT can have undefined sources if parameters are not set correctly.
• What does the sql_always_where parameter do in Looker?
• Where can users view field descriptions in Looker?
• Which of the following is a feature of Looker’s Git integration?
• To add dimensions to a bar chart color, what should you do to the dimension?
• True or False: When using the percentile measure, Looker rounds the calculated value up to identify the data value returned.
• What is the role of the Looker IDE?
• What is the key reason for configuring a model in Looker?
• In Looker, what type of measure is typically used to compute median values?
• True or False: The ${derived_table_or_view_name.SQL_TABLE_NAME} syntax is not supported with a datagroup's sql_trigger parameter.
• Which measure type requires an aggregation method to be explicitly stated?
• How can a user differentiate a set name from a dimension or measure name?
• What does the term “fully scoped” refer to in Looker?
• What is the default type for a measure if none is specified?
• What defines the fields that can be used in the Explore's UI?
• What function does the symmetric_aggregates feature provide in Looker?
• Which parameter is more powerful for defining local caching policies in Looker?
• True or False: You can use a project manifest file either for project import or for localization, but not for both functions.
• What does the Content Validator do when run against Looks and dashboards?
• What SQL requirement must be met for federated joins?
• LookML is a type of language that is classified as what?
• What does the view_label parameter accomplish in LookML?
• True or False: To have measures come through joins, primary keys must be defined in all views involved in the join.
• True or False: SQL Runner interprets numeric fields as measures and non-numeric fields as dimensions automatically.
• Is it mandatory to configure a model when it is pushed to production for the first time?
• Is it true that SQL Runner allows writing and execution of SQL queries against a LookML model?
• What is true about the use of filters within sets in LookML?
• For an Explore, which parameter enables you to modify the amount of time that cached query results are used?
• What measure type creates a list of the distinct values in a given field?
• True or False: Looker matches data to create merged results with each added query to any other query.
• When adding fields from a dimension_group to a set, how often do you need to add each time frame dimension?
• In an Explore, what does the fields parameter allow you to specify?
• A new Git branch makes sense in which situation?
• Is it true that PDTs persisted through the persist_for parameter are built in parallel?
• How are liquid variables used in the description parameter?
• How can you create a custom duration field for a created dimension group of type: time?
• For a duration, the sql_start and sql_end fields can be which of the following?
• What is the purpose of the group_label parameter in LookML?
• Which parameter is used in a LookML model file to specify the connection that the model should use?
• Which parameter is not typically associated with the dimension duration type?
• What parameter is used with measure types that perform aggregations on non-repeated values?
• A datagroup is defined in which type of file?
• What parameter triggers a state change in the datagroup if its value differs from prior results?
• Which parameter can be used to specify the caching policy for cached results in Looker?
• What happens if the 'persist_for' parameter is not set in a persistent derived table?
• If the field within conditionally_filter is time-based and part of a dimension group, how does Looker treat other dimensions in that group?
• When deploying to production, what is the preferred method in Looker's advanced deploy mode?
• Which option allows you to create filters that cannot be changed by the user?
• What type of results does content validation provide in Looker?
• Which dimension type creates buckets or bins from a numeric dimension?
• True or False: The max_cache_age parameter causes PDTs to rebuild.
• True or False: You can't reference a set of fields when specifying fields to bring from a join.
• Which measure type is typically used for calculation based on summed values?
• What constitutes a role in Looker?
• Which of the following is NOT a function of the Content Validator?
• What functionality does the "percent_of_total" measure provide in Looker?
• What is the purpose of the "$" symbol in Looker?
• What dimension type can be used to plot on a static map visualization?
• Does the Content Validator show errors for all content regardless of permissions?
• True or False: To reference a type: yesno field in another field, you should treat the type: yesno field as a boolean.
• Can user attributes impact connection settings in Looker?
• When working with custom fields in Looker, which of the following is correct?
• If you query a PDT in Development Mode without changes, which version of the PDT will Looker query?
• Which parameter is used to create a set of time-based or duration-based dimensions all at once?
• What is the purpose of the Content Validator in Looker?
• What is the state of a datagroup once a PDT rebuilding process is complete?
• What should be used instead of unless when using conditionally_filter?
• Which of the following statements about using SQL Runner is true?
• What feature does Looker use to calculate aggregations correctly even when joins result in a fanout?
• Which of the following describes the LookML syntax?
• What type of access does an Access Filter typically regulate?
• Which command is used to create a new LookML project in Looker?
• Using tier in conjunction with what can result in unexpected tier buckets?
• In LookML, the 'datagroup_trigger' is primarily used for what purpose?
• Once a developer creates a __________, other developers can review and approve it from the Git provider's web interface.
• True or False: An Explore can be used to create a query, then get the SQL command for that query for use in SQL Runner.
• If a view lacks both sql_table_name and derived_table parameters, what does Looker assume?
• What is the relationship between the extending object and the object being extended if conflicts arise?
• Which of the following is NOT a measure type category?
• Which parameter can be used to specify which fields are brought from a join into an Explore?
• Is it true that the access_filter parameter is specific to a single Explore?
• True or False: When using the percentile measure, Looker returns an average of the data value at that position if the calculated value is an integer.
• What parameter allows a view to be joined multiple times?
• 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.
• Which option is NOT a method for creating persistence in PDTs?
• What level of security do Access Filters provide?
• Can the sql_always_having parameter be written in pure SQL using database table and column names?
• True or False: With the Content Validator for views, Explores, or models, you can change their names, and you can remove their name entirely.
• After rebuilding a PDT is complete, what happens to the cached results of any Explores using that datagroup?
• What do the standards suggest about the organization of fields in the Explore menu?
• What mode allows Looker developers to specify the exact commit for the production version of their Looker instance?
• What outcome does the sql_always_where parameter help achieve?
• What does a model file specify in Looker?
• Which syntax is used to exclude specific sets of fields in an Explore?
• What is the persistence method in regards to PSTs?
• Does an NDT with bind_all_filters: yes need to be joined into the same Explore specified in its explore_source parameter?
• Which statement is true about sets in LookML?
• Which option allows you to leave prefixes out of view names when creating a LookML project?
• Is it true or false that there is a derived_table parameter?
• The access_filter parameter requires which type of field names?
• What explore option should you use if you want to create multiple Explores from the same view and also want to reference fields differently for each Explore?
• Does adding always_filter to an existing explore definition affect previously saved Looks and dashboard tiles?
• What are the key parameters for dimension groups of type: time?
• What happens if a datagroup is triggered?
• What type of information can you get from hovering over a column name in a table visualization?
• Which parameter would you typically use to define a persistent derived table?
• What type of settings can you specify in a project manifest file?
• True or False: It is not possible to create one dimension for each individual duration.
• What database conditions do federated joins require?
• Which of the following is a true statement about dimension fields in Looker?
• Which parameter would you use to define a custom SQL join in Looker?
• What is the implication of a set being able to contain other sets?
• How does drill behavior differ for dimensions and measures?