Font size
WorksheetsCollibra Data Steward Certification
Total questions: 94
Worksheet time: 1hrs 3mins
In what domain type can Lines of Business assets be created in?
Data Asset Domain
Business Dimensions
Policy Domain
Technology Asset Domain
Business Asset Domain
What is / are the top-level community(ies) in the organization image below?
ZZ Customer Success
Data Quality Rule Book
ZZ IT Operations
Validation Rules
ZZ Enterprise Community
What is / are the sub-communities contained within the top-level community?
ZZ Manufacturing
ZZ IT Operations
ZZ Customer Success
Data Quality Rule Book
Validation Rules
What is / are the domains contained within the top-level community?
ZZ Customer Success
Data Quality Rule Book
Customer Glossary
Policy Domain
ZZ IT Operations
After adding a synonym relation from Client to the Business Term, Party, we must go to the Business Term, Party, and add that it is also a synonym to Client.
True
False
Which is a better description of a Data Element, as opposed to a Column?
An atomic unit of data that can be stored in a database table.
A unit of data that is defined for processing. It usually documents an aspect of something abstract.
Which of the following is / are a benefit of the 'round-trip' concept?
The user can identify gaps between Collibra characteristics and spreadsheet columns
Auto-mapping is seamless due to generated column headers within the spreadsheet
The user gets a template to guide their import
The user can easily elect for their template to include columns needed for reimport
Which are true in regards to auto mapping when importing assets?
Auto-mapping is not required for importing assets
Auto-mapping only occurs if a view was created previously
Auto-mapping only occurs if the column names in the spreadsheet match the Collibra Platform's expected names
If the following Validation Rule is assigned to Business Terms, what would cause for a Business Term to be invalid?
Business Term is missing a definition
Business Term is invalid due to its articulation score
Business Term does not have a "has code" relation
Based on the articulation score conditions below, what would be the score of a Business Term that has a Definition and an Under Review status?
60
80
0
50
10
Which of the following is a benefit of editing a diagram view configuration?
The ability to orient relations in whichever direction you please (as long as they exist)
Configured diagrams update when relations that are configured to be displayed are added to the diagram view
You may reuse the diagram configuration when looking at any asset
Which of the following refers to an incoming relation for a Code Value?
Code Value is part of Code Set
Code Value contains Code Set
Code Set is part of Code Value
Code Set contains Code Value
Which of the following refers to an outgoing relation for a Code Value?
Code Set is part of Code Value
Code Value is part of Code Set
Code Set contains Code Value
Code Value contains Code Set
What is the most appropriate Issue Category to use if a Standard is not being met?
Policy Is Missing
Data Quality Issue
Policy Non-Compliance Issue
Accuracy Issue
Sub-communities and domains inherit responsibilities assigned at the community level.
True
False
Which core application of the Collibra Platform allows you to easily view who has been assigned a resource role to determine accountability?
Catalog
Stewardship
Business Glossary
Settings
Daat Helpdesk
The Business Glossary will display all business terms to all users regardless of View Permissions.
True
False
All workflows can be started from the Steward Dashboard.
False
True
Global workflows, when configured to do so, can be initiated from which tab in Global Create?Recent
Recent
Assets
Organization
Suggested
Actions
Where can an item-based workflow be initiated from?
A community's Assets page
A domain's Assets page
The Global Create button
A traceability diagram displaying the asset
An asset's Overview page
In order to show a relation within an asset table as an expandable/collapsable row, you first must configure:
A hierarchy referencing the relation
Display options
A basic filter
An advanced filter
Where in Catalog, can you view the Table, Column, Data Entity, and Data Attribute assets that you have access to?
Data Sources
Technology Assets
Data Dictionary
Reports
Data Sets
What asset types can be added to your Data Basket?
Reports
Data Elements
Data Sets
KPIs
Assets of what types are created when registering a new data source within Catalog?
Data Attribute
Column
Data Entity
Schema
Table
When requesting access to a Data Set, the Request Data Sets Access workflow automatically knows who to send the approval task to. True or False?
True
False
What best describes a Data Set?
Connected Data Sources
Collections of Tables
Snapshot of a Data Lake
Collection of Data Assets
Which workflow assists the user in the process of linking the physical data layer to the business conceptual layer?
Voting sub-process
Data Classification
Guided Stewardship
Post Data Ingestion Workflow
What types of assets are NOT created when registering a Tableau server into the Catalog?
Governance Assets
Business Assets
Data Assets
Technology Assets
A Technology Asset in Collibra must have the exact same name as the Tableau Data Source for stitching to occur
False
True
With a configured workflow, a Report Certification process can automatically check for what types of criteria?
Roles and responsibilities have been assigned
The Report has relations with necessary assets
The Report has an Accepted status
The Report has a certain rating
What types of assets are created during ingestion into Catalog when establishing a JDBC connection with a database?
System
Schema
Database
Column
Table
True or False: The Global permission 'Technical Lineage' gives a user the ability to view harvested lineage in Collibra?
True
False
Scanning for personal information (PI) will help you:
Confirm you’re not storing PI which is not critical to your business process
Ensure the PI has sufficient level of security
Archive privacy by design
Execute data subject requests
Critical data assets and attributes that are required for reports include:
Various system of records
Ownership of data
Data quality
Decentralized structures
Using traceability, the Report Business Data Lineage provides the following the information
Business process and owner
Privacy dependencies
Critical data element or report attributes
KPIs or business terms
Which of the following is not one of the six dimensions of data quality
Completeness: Represents the extent to which data is not missing
Accountability: Represents the monitoring required of cleansed attributes
Validity: Provides the information on the extent to which data conforms to a predefined standard or format
Integrity: Represents the extent to which data is not missing the key relationship linkages
When editing dashboard settings, changing an asset type icons requires that you:
Modify the asset type widget
Alter the Data Governance Center Settings
Alter the dashboard's settings
Request a specific instance of the DGC from Collibra
The definition of data quality includes the following:
Completeness of data
Data Validity
Data analytics
Data accuracy
When working to discover personal information, the data governance team will
Categorize the sensitivity of the PI data
Mark individual tables or columns containing PI
Determine what data categories are considered PI
Map the data classification PI policies to the data layer
When designing a dashboard, adding the same widget a second time will cause the dashboard to
Prevent you from adding the second instance of that widget
Remove the first instance of that widget
Remove both the first and second instance of that widget
Add a second instance of that widget
To add a relationship between data quality rule and a data quality dimension, follow the next steps:
Connect the relationship by choosing Classifies
Add a new relationship between the data quality rule and classified by data quality dimension
Create a rule book to store all the data quality rules applicable for the select community
Go to Settings > characteristics, to reivew the attributes and type of attribute
Complete the following steps to create the configuration of data quality rules for a business term, for a table and for a column:
Access the data quality rulebook
Add characteristics for each of the data quality rules
Create a relationship between that data quality rule and between the asset type
Link the data quality rule to the asset type
Data quality dashboards provide access to the following:
Accountability to the business owner and the data owner
Reviewing the current state of the data quality for a business term accumulated from different columns that are present in different tables and schema
A method for business owners to look at their business terms and review the quality and how it has evolved over time
Reviewing the current state of the data quality for a business term in a single column only
Which of the following statements are true?
Validity: The extent of which distinct data instances provide non-conflicting information about the same underlying data object.
Data quality rule: Represents the specification that describe the actions to be performed to measure the quality of data.
Aggregation paths: Consist of a chain of relations that is to be followed from the asset to which the data quality rule is assigned to the asset containing actual values.
Data quality metric: An asset that stores the data quality results after application of data quality rules on data assets. It is usually imported in Collibra from an external data quality software product.
Data quality dashboards can enable representation of the following:
Types of data assets
Data ecosystem metadata
The data quality rules applied to an asset
Quality scores for each of the applied data quality rules
What are the benefits of data quality dashboards in Collibra?
Insight to the current and past states of the data quality
Accountability of the data owner and stakeholders to make sure all data is compliant
Assistance in monitoring cleansed attributes
Increased trust in the accuracy of data
Which of the following is not one of the six dimensions of data quality?
Accountability: Represents the monitoring required of cleansed attributes
Completeness: Represents the extent to which data is not missing
Integrity: Represents the extent to which data is not missing the key relationship linkages
Validity: Provides the information on the extent to which data conforms to a predefined standard or format
The definition of data quality includes the following:
Data accuracy
Data analytics
Completeness of data
Data validity
Which of the following statements are true?
Data quality rule: Represents the specification that describe the actions to be performed to measure the quality of data.
Data quality metric: An asset that stores the data quality results after application of data quality rules on data assets. It is usually imported in Collibra from an external data quality software product.
Validity: The extent of which distinct data instances provide non-conflicting information about the same underlying data object.
Aggregation paths: Consist of a chain of relations that is to be followed from the asset to which the data quality rule is assigned to the asset containing actual values.
When working to discover personal information, the data governance team will:
Categorize the sensitivity of the PI data
Map the data classification PI policies to the data layer
Mark individual tables or columns containing PI
Determine what data categories are considered PI
Examples of PI include:
Account credentials
Email addresses
IP addresses
Financial details
Scanning for personal information (PI) will help you:
Execute data subject requests
Achieve privacy by design
Confirm you're not storing PI which is not critical to your business process
Ensures the PI has sufficient levels of security
When scanning for PI, the biggest privacy risks come from:
Unstructured data
Structured data
Hidden data
Lost data
When working to discover personal information, the privacy team will:
Establish data classification policies around PI
Categorize the sensitivity of the PI data
Determine what data categories are considered PI
Mark individual tables or columns containing PI
Collibra Lineage demonstrates the following:
Automatically maps relationships between data points to show how data moves from system to system and how data sets are built, aggregated and sourced
Data flows from the originating data source to the end consumption point
Overlays can be applied to demonstrate details such as data quality and domains
Views for transformation, staging tables, and lookups
When creating a data set, apply the following sequence of steps:
Select create new data set. Existing data sets cannot be modified
Select Data Sources in Catalog
Choose from multiple different schemas, different columns, different data sources to create the data set
Choose if you add to an existing data set or create a new dataset
Lineage diagram configurations include:
Profile sampling
Edit name and description
Change the node of properties to show relationships
Change the node of properties to show relationshipsInclude overlay labels to indicate data quality or domain
Attributes for data sets include the following:
Data elements
Business context
Certified status
Business dimensions settings
The Data Catalog provides access to the following:
Find and understand data by creating metadata based on profiling and sampling capabilities
Helps business users consume their data with direct integrations with BI tools, such as Tableau
Provides statistics on the rows and columns of data, giving meaning by linking it with business-friendly terminology
Profile large datasets by taking a random sample of the data
The data dictionary supports the following outcomes:
Creates new codes and code sets with appropriate controls
Document your metadata and its use
Definitions of your data, column names and table names
Define critical data elements and relationships with other assets
Select the following true statements:
A logical data attribute is a mapping to a logical representation of the physical data
Reference data is used to map data elements and data structures to support data transformations
Logical data models are a layer of abstraction that allows business to understand the data and to realize value
A data model contains one or more data entities. Each data entity contains one or more data attributes
Registering a data source results in the following:
Results in imported data into the Collibra Platform
Creation of a domain of the physical data dictionary containing assets of the schema, table and column types
The process of reading metadata from sources that are not yet governed
Results in metadata from that source available in the Collibra Platform
Reference data allows you to operationalize your data, which includes the following outcomes:
Creates new codes and code sets with appropriate controls
Eliminate barriers for data use by enabling more accurate data mapping
Provides definitions of critical data elements
Reconciles data across operational systems for accurate reporting and analysis
The technical steward role involves:
Daily data-related decisions
Implementing business requirements in a technology platform
Responsible for maintaining data directly on the IT infrastructure
Responsible for utilizing an organization’s data governance processes to ensure privacy compliance
Data Stewards responsibilities include:
To register data sources
To ensure fitness of data elements, both the content and metadata
To incorporate processes, policies, guidelines and responsibilities while administering organization's data
To ensure compliance with policy and or regulatory obligations
When conducting a roundtrip import/export, we suggest the following fields in the spreadsheet for a successful import:
Name and asset type
Data asset definition
Asset status (Candidate, Approved, Obsolete)
Relation between business term and acronym
In our example of the Digital Marketing glossary domain, business terms consist of:
Characteristics which include attributes and relations
Relations, such as between a business term and acronym
Attributes, such as a definition
Several definitions for different lines of business
To complete the roundtrip import process, complete the following steps:
Map the columns that don't align, such as Full Name
Configure the import to create new assets and domains if they do not exist, replace existing assets or update them
Configure how to map attributes by either replacing them or creating them as new attributes
Choose whether to delete existing assets from the domain that are not in the file
The following content can be shown on diagrams for business term assets:
Relation to an acronym
Stewardship for data assets
The community and domain where the business term is located
A preview of the business term containing relations, status, and acronyms
Assets are defined as:
Represent the structural concepts of the operating model
Building blocks of your data governance initiative
Are grouped together according to their function, project or knowledge area
Represent the organizational concepts of the operating model
Characteristics that you can assign to an asset include:
An attribute is a literal value that captures information about an asset
An attribute is an instance of exactly one attribute type
A relation defines how two assets are related to each other
A relation can be defined by multiple relation types
Examples of assets and asset types include:
Column names and table names are technology asset types
Business term, Customer Lifetime Value, is a business asset type
A definition is not correct ticket is an issue type
Retention Policy is a governance asset type
The Collibra Platform includes five core asset types to start your data governance structure based on their use, including:
Technology assets
Business assets
Policy assets
Data assets
In Settings, information regarding assets includes the following:
A list of our asset types that are out-of-the-box
A list of our domain types that are out-of-the-box
Configurations to create new asset types
No custom asset types are permitted in the Platform
The overview section provides business stewards access to metadata, including:
Business process that generates report
Frequency of reporting
Source system
Tasks and issues
Field mappings indicate the following:
Transformation the data undergoes as it's flowing each system.
Organizational structures
Metadata Management
Ingestion sources
Using traceability, the Report Business Data Lineage provides the following information:
KPIs or business terms
Critical data elements or report attributes
Business process and owner
Privacy dependencies
Critical data assets and attributes that are required for reports include:
Data quality
Various systems of record
Decentralized structures
Ownership of data
After reaching a Level 3 certification, the following criteria have been approved:
Lineage and standards
Definition and ownership
Data quality monitored
Watermark as seal of approval
Changing an asset type icons requires that you:
Modify the asset type widget.
Alter the dashboard’s settings.
Request a specific instance of the DGC from Collibra.
Alter the DGC settings.
The text box widget also doubles as a:
HTML field.
Bulletin-board or forum-type widget.
Open search box.
PDF reader.
Creating a new dashboard from scratch is beneficial when:
You want to use the same widget twice.
The widgets aren’t functioning properly.
Modifying an existing dashboard would be more difficult than starting fresh.
You want to create different dashboards for different users.
In order to choose the colors you want different data sets to have in a bar graph, you must:
Assign the colors using the color scheme widget.
Add the data in the order the desired colors are assigned.
Add the colors in the order that the data sets are listed.
Modify the color scheme for the whole dashboard.
Adding the same widget a second time will cause the dashboard to:Remove both the first and second instance of that widget.
Remove both the first and second instance of that widget.
Remove the first instance of that widget.
Add a second instance of that widget.
Prevent you from adding the second instance of that widget.
Complete the following steps to create the configuration of data quality rules for a business term, for a table and for a column:
Access the data quality rulebook
Add characteristics for each of the data quality rules
Create a relationship between that data quality rule and between the asset type
Link the data quality rule to the asset type
To create a data quality rule, complete the following configurations:
Access the aggregation path
Select Create in the Data Quality Rulebook domain
Enter descriptions under Create Asset > Name field
Add characteristics to the quality rule
Data quality dashboards provide access to the following:
A method for business owners to look at their business terms and review the quality and how it has evolved over time
Accountability to the business owner and the data owner
Reviewing the current state of the data quality for a business term in a single column only
Reviewing the current state of the data quality for a business term accumulated from different columns that are present in different tables and schemas
To add a relationship between data quality rule and a data quality dimension, follow the next steps:
Go to Settings > characteristics, to review the attributes and type of attribute
Create a rule book to store all the data quality rules applicable for the select community
Add a new relationship between the data quality rule and classified by data quality dimension
Connect the relationship by choosing classifies
Examples of available metrics in an aggregation path include the following:
Passing Fraction
Customer Data Monitoring Result
Rows Failed
Rows Passed
Referencing our example of creating a relation between a data set and governance asset, complete the following steps:
From the data set, navigate to the More area to create an issue to attach the standard to our data set
Classify issue as Policy is Missing
Navigate back to data set and add the relation, complies to Governance Asset
Issue assignee accepts the review, completes analysis, and proposes a resolution
Data Helpdesk provides functionality to achieve the following:
Automates issue management
Automatically assigns roles in Settings to resolve issues
Issues are escalated to the right people based on their roles and responsibilities
Integration with IT ticketing system, such as ServiceNow
The Policy Manager provides the following:
Centralized access to governance assets
Create, review and update data policies
Issue management
Easily identifiable logic and rules
Workflows are designed to:
Support only technical users to create and modify workflows
Model your data processes
Provide a graphical representation modeling business processes by using the BPMN standard
Support business and technical users to create and modify workflows
A workflow in the Collibra Platform:
Provides an automated series of actions that produces a specified outcome
Requires actions from the Collibra Platform users in the form of tasks
Helps people collaborate on assets and automate processes
Ensures compliance with policy and or regulatory obligations
