Brainscape's Knowledge GenomeTM

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


See full index

Clarity > Exploring SQL With Epic Tools > Flashcards

Exploring SQL With Epic Tools Flashcards

1
Q

True or False: There is no way to use the metric editor to investigate a query.

A

False, if the data source for a metric definition is a SQL database, it is possible to use the metric editor to investigate the query that returned those values.

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

What are the steps that you would to identify IDN records that use a SQL query from either Clarity or Caboodle?

A
  1. Open the Analytics Catalog.
  2. Search for the reporting workbench template ‘Cogito Metric Glossary’ and create a new report using that template.
  3. Add a search criteria for Collection method equal to SQL Metric-Automatic
  4. Run the Report
    5.Pick any metric in the results and open the metric using the metric editor activity based action.
  5. In the Metric Editor, navigate to the data collection form.
  6. Navigate to the parser form.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How would you go about finding reporting workbench templates that user the cogito SQL search engine?

A
  1. Open the Analytics Catalog
  2. Search for the reporting workbench template ‘Report Template Audit’ and create a new report.
  3. Add a search criteria for search engine type of SQL
  4. Run the report
  5. Pick any template in the results and open the template editor activity based action.
  6. Navigate to the query template form
  7. Navigate to the SQL query form
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

True or False: The Cogito Metric Glossary is a report that you can run to find a list of templates?

A

True

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

True or False: For the cogito metric glossary you can add a criteria of SQL metric?

A

True, you add a search criterion for collection method equal to SQL metric - automatic.

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

True or False: When the report finally runs to search for a SQL metric, the metric editor is easily accessible at the top?

A

True, it is on the top left hand conner.

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

True or False: The parser form displays the SQL query?

A

True

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

True or False: (Video) what database or databases can work bench get its data from?

A

All of the databases. We can run a report to find work bench template that runs via sql.

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

True or False: You can add the SQL type criteria to the report template audit.?

A

True, you would add a search criterion for search engine type of SQL.

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

True or False: You have to use the search option at the top to use the template editor once you have the results of the report template audit.?

A

False, it is on the very top left.

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

True or False: you can use the template editor to create a new template?

A

True, if you are building your own cogito SQL reporting workbench template, you could also search for the template editor to create a new template.

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

True or False: The SQL query form of the template editor does not have a field for the SQL script?

A

False

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

True or False: the SQL query will be run the time the search is run?

A

True

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

What does the parameters window do?

A

The parameters allow for the report runners to make selections at the report settings window> criteria tab that will directly affect the SQL query.

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

True or False: The Cogito Metric Glossary is a report that you can run to find a list of templates?

A

True

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

In a SQL report workbench template, you are able to use the explore tab and its slicer dicer functionality?

A

True

5
Q

True or False: The Cogito Metric Glossary is a report that you can run to find a list of templates?

A

True

5
Q

True or False: You are able to use slicerdicer in a SQL report template?

A

True

5
Q

Results Viewer

A

The results viewer is the picture below. When the report is run, those results can be sorted and further filtered in the results viewer.

5
Q

Explore Tab

A

The explore tad is another tool found in the results viewer. The explore tab allows report consumers to further explore and refine their reporting workbench results using the slicer dicer functionality.

5
Q

Cogito SQL Search Engine

A

The cogito SQL search engine is a criteria that you can add to your workbench reports.

5
Q

PAF record

A

PAF records do not store data. They are only used to format and display data.

5
Q

Caboodle Console

A

The caboodle console can be used to research caboodle tables, schedule ETL executions, or adjust the SSIS packages that are extracting data from a data source into caboodle.

5
Q

Load Package

A

A load package is an SSIS package that loads data from Clarity into Caboodle.

5
Q

Investigate the query of a SQL Metric

A

To investigate an SQL Metric, you can use the SQL metric glossary. After you follow the steps below, you navigate to the parser form. From the parser form you are able to figure out which tables are bring used by the metric.
1. Open the Analytics Catalog.
2. Search for the reporting workbench template ‘Cogito Metric Glossary’ and create a new report using that template.
3. Add a search criterion for Collection method equal to SQL Metric-Automatic
4. Run the Report
5.Pick any metric in the results and open the metric using the metric editor activity based action.
6. In the Metric Editor, navigate to the data collection form.
7. Navigate to the parser form

5
Q

Investigate the query of a Cogito SQL Reporting Workbench Template

A

One way that you can find cogito SQL reporting workbench templates is by using the report template audit report. You would follow the steps below and then click on SQL query to get to the query section of the template. From there you are able to see what tables are use and how the builder joined the tables.
1. Open the Analytics Catalog
2. Search for the reporting workbench template ‘Report Template Audit’ and create a new report.
3. Add a search criterion for search engine type of SQL
4. Run the report
5. Pick any template in the results and open the template editor activity-based action.
6. Navigate to the query template form
7. Navigate to the SQL query form

Clarity (7 decks)

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