Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Looker LookML Developer Certification > Looker > Flashcards

Looker Flashcards

1
Q

What parameter would you use to limit access to specific Explores, joins, views, or fields.

A

access_grant

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The access_grant parameter takes two parameters. What are they?

A

user_attribute, and allowed_values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

To apply a defined access grant within a dimension, what parameter do you need to use?

A

requiered_access_grants

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

True or False. Access grants can be applied at the dimension and view level.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

For row level access controls, which LookML parameter should you use?

A

access_filter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The access_filter parameter takes two parameters. What are they?

A

field, user_attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

True or False. The access_filter parameter is applied for a specific Explore?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Where are user attributes defined?

A

Admin > Users > User Attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

True or False. When using access_filter, Admins can access all the data without having to set a user attribute.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

To allow Admins to access all values of a string field controlled by the access_filter parameter, what user attribute type and value should be set?

A

type: String Filter (advanced)
value: %, NULL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

To allow Admins to access all values of a number field controlled by the access_filter parameter, what user attribute type and value should be set?

A

type: Number FIlter (advanced)
value: <0, >=0, NULL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

True or False. The hidden parameter should be used for field control access.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

True or False. A user can use a field with the hidden: yes parameter by using the field in the URL?

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Name the three types of access available in Looker.

A

Data Access
Content Access
Feature Access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What two things do you need to create a user role?

A

Permission Set

Model Set

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is wrong in the following LookML code?

measure: total_impressions {
type: sum
sql: SUM(${TABLE}.impressions) ;;
}

A

The SUM() function is not necessary as Looker will automatically sum the field when running a query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

True or False. Using the Content Validator applies changes only to the mode you are in (Production or Development)?

A

False. Content Validator applies changes at a global level. However, changes made in development mode will need to be deployed for them to be reflected in Production.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What is a Looker Model file?

A

A Model file specifies the database connection and the set of Explores that use that connection. It also defined the Explores themselves and their relationships to other views.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is an Explore?

A

AN Explore is what the users use to query data from the database. They are defined in the Model file. An Explore is the equivalent of the FROM clause in a SQL query.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

The name of an Explore is usually the name of the view that forms the base of the Explore. If the Explore name is different, what parameter must be given in the Explore?

A

The from parameter needs to be given along with the base view name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is a View?

A

A View represents a single table in a database or a single derived table.

22
Q

What does a View file contain?

A

A View file primarily contains the definitions of dimension and measure to include from the database table.

23
Q

What is a measure field?

A

A measure field is one that uses a SQL aggregation such as COUNT, SUM, AVG, MIN, MAX

24
Q

In what file would you import files form other projects?

A

Project manifest file

25
Q

To include a view from another project imported in the project manifest file, what parameter do you need to use at the beginning of the model file?

A

The include parameter must be used with the view file defined as…

//project_name/path_to_file

26
Q

Where are joins defined?

A

In an Explore

27
Q

What are the types of joins you can use when declaring a join with the type parameter?

A

left_outer
inner
full_outer
cross

28
Q

What are the available relationship types when using the relationship parameter in a join declaration?

A

one_to_many
one_to_one
many_to_many
many_to_one

29
Q

What is the sql_on parameter of a join declaration?

A

The sql_on parameter is equivalent to the ON clause of a join in SQL

30
Q

True or False. When declaring a join, all fields from the joining table will always be included.

A

False. Specific fields from a view can be brought into an Explore using the fields parameter.

31
Q

What is the LookML syntax for defining a set of fields in a view?

A

set: set_name {
fields: [field_1, field_2]
}

32
Q

How can you bring a set of fields from a view into an Explore during a join declaration?

A

join: view_name {
type: …
sql_on: … ;;
relationship: …
fields: [set_name*]
}

An asterisk is added to the set name so looker knows it is a set.

33
Q

What are symmetric aggregates in Looker?

A

Symmetric aggregates are a feature of Looker that ensures that aggregations are calculated correctly. Even in cases where joins cause fanout

34
Q

What must be included in all view files of an Explore so that symmetric aggregates are calculated correctly?

A

A primary key must be defined for a dimension using the primary_key: yes parameter. If a single dimension is not the primary key, a new dimension can be defined that concatenates the fields that make up the primary key.

35
Q

The log page shows how many of the most recent log messages?

A

500

36
Q

Where can you find information about system activity?

A

System Activity dashboard

System Activity Explore

37
Q

What are the 5 types of fields that can be used in a view?

A 
Dimensions
Measures
Dimension Groups
Filters
Parameters
38
Q

How would you use the duration field type? And what is it used for?

A

The duration field type must be used in conjunction with a Dimension Group field.
It is used to calculate a set of interval-based duration dimensions

39
Q

For a dimension group of type: duration, what are the 4 LookML parameter that need to be included?

A

type: group
sql_start: SQL expression ;;
sql_end: SQL expression ;;
intervals: [interval_1, interval_2, …]

40
Q

If created was a dimension of type: duration, how would you access the hour field?

A

${hours_created}

41
Q

Time dimensions can be created using the duration_group with type: time. How would you reference the month field of a dimension called created?

A

${created_month}

42
Q

What dimension type would you use to plot a static map?

A

type: zipcode

43
Q

In order to define a measure based on another measure, what should the measure type be?

A

type: number

44
Q

True or False. To create a running total, first it is necessary create a measure of type sum and reference that measure in the sql parameter of the new running total measure.

A

True. The new measure might look something like this…

measure: cumulative_impressions {
type: running_total
sql: ${total_impressions}
}

45
Q

What parameter can you use to display to the user a description of the field in the Explore UI?

A

The optional description parameter is used when defining a dimension or measure

46
Q

Without changing the name of a dimension, measure, or filter, what parameter can you use to change the name the user sees in the Explore UI?

A

The label parameter allows you to change how a dimension, measure, or filter is displayed in the Explore UI

47
Q

What parameter can you use to change the display format of values?

A

value_format_name can be used for predefined formats

value_format accepts excel style number formating

48
Q

What is a derived table in Looker?

A

A derived table is a query whose results are used as if it were an actual table.
A derived table is essentially a temporary table in BigQuery

49
Q

Inside the derived_table parameter, what are two ways to define the query for a derived table?

A

For a native derived table, you use a LookML based query.

For a SQL-based derived table, you write a SQL query

50
Q

True or False. Both native derived tables and SQL-based derived tables are not persisted (written to the database).

A

True. If the derived SQL query has been run before (combination of fields, filters, joins) and the results are still valid, then Looker will use the cached results, however, if this is not the case, Looker will run a new query.

51
Q

What is a persistent derived table?

A

A persistent derived table (PDT) is a derived table that is written to a scratch schema in the database and is regenerated based on a specified regeneration strategy.

52
Q

Why might you use a PDT over a temporary derived table?

A

When a user requests data from the table, the table will have already generated the results, reducing query time and database load. This is especially helpful for queries that require lots of processing such as aggregations.

Looker LookML Developer Certification (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions