SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Certified Project Designer Cpd
Start Test
Study First
Subjects
:
certifications
,
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Sample Metrics commonly performed on Facts
Project Creation Wizard
Fact Expression
Advantage of a completely denormalized schema
2. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
2 ways you can configure the Project Source to connect to the Metadata database
Metrics
Terabytes (TB)
Project Source
3. Used for - Initially populating the Metadata - Creating schema objects
Attribute or its relationship(s)
MSTR Desktop Architect
Display views you can Print by
OLAP
4. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
Simple Attribute Expression
Report Editor
Data Pivoting
5. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.
Source system characteristics
Advantage of a completely denormalized schema
Filter Definition Prompts
ETL
6. Compound - Homogeneous - Heterogeneous
Default Project folder structure
Lookup Table structure of a completely normalized schema
Filter Definition Prompts
3 types of Attributes
7. Metrics that perform multiple aggregations; one calculation inside of another.
Schema Objects
2-Tier Architecture
Stored
Nested Metrics
8. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen
Logical Data Model
2-Tier Architecture
Level Prompts
Lookup Table structure of a completely denormalized schema
9. Extraction - transformation - loading
Lookup Table structure of a moderately denormalized schema
Source system characteristics
Cannot create project objects
ETL
10. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
To qualify a Metric in a Set Qualification
ETL process
Object Prompts
Project
11. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Metrics
Attribute Forms
MSTR applications
Rollback your changes
12. You must select "Other directions" when drilling attributes while viewing a report
Homogeneous Attribute
To drill through User Hierarchies
Search Object
Desktop Architec
13. View Filters can only ___________.
Terabytes (TB)
Reference Report Objects
4 tasks of the Attribute Creation Wizard
2 types of Attribute Expression
14. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h
Required on the report for Outline Model to work
Default Project folder structure
Characteristics of Nested Metrics
Types of drilling
15. Must have a one-to-one relationship with all other forms.
The System
Attribute Forms
Display views you can Print by
3 column types of a Physical Schema
16. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Types of analysis you can perform with OLAP Services
Report Filter
2 types of Table Keys
Data warehouse characteristics
17. Facts associated to different column names in 2 or more tables
Types of analysis you can perform with OLAP Services
Nested Metrics
Heterogeneous Fact
User Hierarchies
18. The Attribute Form Expression that maps to a single column - no matter the number of tables
MSTR Desktop Architect
Object Prompts
Simple Attribute Expression
Terabytes (TB)
19. You can e-mail reports by going to _____
Hierarchies
Compound Metric
File > Email Reports As
ETL
20. Metrics aggregate on the lowest-level attribute __________.
ETL process
By default
Lookup Table structure of a moderately denormalized schema
Attribute Elements
21. The Attribute Form maps to the same column name in multiple tables
Homogeneous Attribute
MSTR applications
Report Objects
3 functions of Attribute Forms
22. A subset of a report that users can manipulate without altering the SQL
Warning
: Invalid argument supplied for foreach() in
/var/www/html/basicversity.com/show_quiz.php
on line
183
23. User reporting requirements - Query performance - Data volume - DB Maintenance
View Filter
2 components of a Physical Schema
MSTR Desktop Architect
4 factors to consider when designing a data-warehouse schema
24. What tool do you use to create the Metadata shell?
Stored
View Filter
Configuration Wizard
Project Creation Wizard
25. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema
2-Tier Architecture
File types are allowed for exporting a Report
Schema Objects
26. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts
2 methods to creating Facts
View Filter
Gigabytes (GB)
Search Object
27. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Attribute Relationships
Subtotals
Rollback your changes
View Filter
28. Groupings of directly related attributes. Also commonly known as "dimensions".
Hierarchies
4 types of Metrics
4 types of Report Filters
Schema Object Editor
29. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Column Aliases
Compound Attribute
To edit the appearance of a Graph in a report
Objects you are allowed to Page-by
30. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Types of analysis you can perform with OLAP Services
Attributes
Required on the report for Outline Model to work
Thresholding
31. Prompts to select a single value on which to qualify a date - number or text string.
Homogeneous Fact
Rollback your changes
To drill through User Hierarchies
Value Prompts
32. A new tool for project design tasks - used for fine-tuning a project after initial creation
Methods are there to creating Attributes
Required on the report for Outline Model to work
Architect Graphical Interface
Minimal or none
33. Direct: 2-tier - Server: 3-tier
3 Types of Objects in MSTR Desktop
2 types of Facts
2 ways you can configure the Project Source to connect to the Metadata database
Homogeneous Fact
34. Filter definition prompts - Object prompts - Value prompts - Level prompts
4 types of Prompts
Drilling
Outline Mode
Report Filter operators
35. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
2 types of Facts
Simple Metrics
Outline Mode
Shortcut in MSTR Desktop
36. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
4 types of Report Filters
Thresholding
Lookup Table structure of a completely denormalized schema
37. One that uses 2 or more columns as its ID
Stored
Characteristics of a Simple Table Key
MSTR Connectivity Wizard
Compound Attribute
38. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
4 properties you must know in order to create attributes using the Attribute Editor
MSTR applications
Facts
Stored
39. Homogeneous - Heterogeneous
2 types of Fact Expressions
2 types of Facts
Report Formatting
Report Filter operators
40. Subtotals reflect accumulations at selected attribute levels
Attribute or its relationship(s)
Types of analysis you can perform with OLAP Services
4 tasks of the Attribute Creation Wizard
Subtotals
41. ID columns - Description columns - Fact columns
To create a Report Prompt
'View of a Report'
Report Prompts
3 column types of a Physical Schema
42. It contains links to specific folders in the Folder List
Subtotals
Rollback your changes
Search-based prompts
Shortcut Bar
43. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns
Attribute Creation Wizard good for
3 Schema types
ETL
2 components of a Physical Schema
44. A condition data must meet in order to be included in a report. Does affect the SQL.
Project
Report Filter
Methods are there to creating Attributes
Report Subscription
45. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
5 steps to creating a logical data model
Architect Graphical Interface
Facts
To save a Report Format
46. You can _____________ in the Architect Graphical Interface.
Factors to consider when designing a logical data model
Components of Compound Metrics
Attribute or its relationship(s)
Rollback your changes
47. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
The 3 MSTR Tools
Gigabytes (GB)
By default
Unlimited
48. OLAP retains data ________
Long-term (2 - 5 years)
Physical Schema
3 components of a Report
Drilling
49. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy
4 types of Metrics
New SQL
Types of drilling
Attribute Forms
50. The default entry-points.
Default Project folder structure
To drill through User Hierarchies
Highest-level attributes
The 3 MSTR Tools