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. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked
Very high; part of ETL process
To qualify a Metric in a Set Qualification
Rollback your changes
2 types of Attribute Expression
2. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Default Project folder structure
Compound Metric
Attribute Creation Wizard good for
Factors to consider when designing a logical data model
3. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
Limitations of the Attribute Creation Wizard
Application Objects
Facts
4 types of Report Filters
4. A new tool for project design tasks - used for fine-tuning a project after initial creation
Facts
Architect Graphical Interface
MSTR OLAP Services
Search-based prompts
5. You can _____________ in the Architect Graphical Interface.
Reports
Components of a MSTR architecture
Source system characteristics
Rollback your changes
6. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.
Metrics
MSTR Connectivity Wizard
Desktop Designer
Report Filter
7. The default entry-points.
Lookup Table structure of a moderately denormalized schema
Components of a MSTR architecture
Banding
Highest-level attributes
8. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Lookup Table structure of a completely normalized schema
MSTR Connectivity Wizard
Level Prompts
Source system characteristics
9. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Architect Graphical Interface
4 parts of the Project Design Process
MSTR OLAP Services
3 components of a Report
10. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Gigabytes (GB)
Derived Attribute Expression
2 types of Table Keys
4 factors to consider when designing a data-warehouse schema
11. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Attribute Forms
Desktop Designer
OLAP
4 types of Prompts
12. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
The 3 MSTR Tools
View Filters
4 types of Prompts
Lookup Tables
13. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
MSTR Desktop Architect
3 Types of Objects in MSTR Desktop
Report Subscription
Source system characteristics
14. Formula - Level (Dimensionality) - Conditionality - Transformation
To "drill down" on a report
Components of a Metric
Simple Attribute Expression
2 types of Attribute Expression
15. What tool do you use to create the Metadata DSN connection?
4 types of Prompts
MSTR Connectivity Wizard
Nested Metrics
Object Prompts
16. Facts - Attributes - Hierarchies
The System
3 column types of a Physical Schema
Page-by
Components of the Logical Data Model
17. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
File > Email Reports As
Components of Compound Metrics
Physical Schema
MSTR Desktop
18. What tool do you use to create the Metadata shell?
By default
Configuration Wizard
Architect Graphical Interface
4 tasks of the Attribute Creation Wizard
19. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Objects you are allowed to Page-by
Lookup Table structure of a moderately denormalized schema
Lookup Table structure of a completely denormalized schema
Schema Object Editor
20. Used to limit a possibly overwhelming set of potential prompt answers
Subtotals
3 Methods of MSTR Desktop navigation
Attribute Forms
Search-based prompts
21. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
File types are allowed for exporting a Report
Desktop Designer
5 Report display views
22. Tables - Facts - Attributes - Hierarchies
4 basic Schema objects
The 3 MSTR Tools
MSTR applications
Report Prompts
23. A shortcut to an existing Object in a Project
Object Prompts
4 tasks of the Attribute Creation Wizard
View Filters
Shortcut in MSTR Desktop
24. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Characteristics of a Compound Table Key
Warehouse Catalog
Process for creating the Project Metadata
3-Tier Architecture
25. Attribute Creation Wizard - Attribute Editor
Methods are there to creating Attributes
Reference Report Objects
Desktop Designer
2 types of Table Keys
26. More storage - Complex SQL - Simple ETL
Report Filter
Thresholding
Attribute Forms
Characteristics of a Compound Table Key
27. OLAP retains data ________
Long-term (2 - 5 years)
Attribute Forms
3 components of a Report
Attribute Elements
28. User requirements - Existing source data - Technical and performance considerations
Process for creating the Project Metadata
Source system characteristics
Unlimited
Factors to consider when designing a logical data model
29. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Outline Mode
Data Pivoting
Lookup Tables
ETL process
30. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.
Report Prompts
Simple Attribute Expression
Fact Tables
Object Prompts
31. A user interface for creating and maintaining a BI environment
MSTR Desktop
Desktop Analyst
Attribute or its relationship(s)
Components of a MSTR architecture
32. Columns - Tables
3 functions of Attribute Forms
2 components of a Physical Schema
Level Prompts
Lookup Table structure of a completely normalized schema
33. You can e-mail reports by going to _____
Sorting
4 types of Metrics
Gigabytes (GB)
File > Email Reports As
34. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
ETL process
OLTP
MSTR Desktop
Page-by
35. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
View Filter
Short-term (2 - 6 months)
Characteristics of a Simple Table Key
Types of drilling
36. A method of organizing the appearance of report results in a Grid report based on a criteria
Banding
Attribute Forms
Facts
To create a Report Prompt
37. OLTP data storage measure
Gigabytes (GB)
New SQL
Objects you are allowed to Page-by
View Filter
38. Used for - Initially populating the Metadata - Creating schema objects
Level Prompts
MSTR Desktop Architect
4 basic Schema objects
Application Objects
39. View Filters can only ___________.
Components of a Derived Metric
Reference Report Objects
Different methods for creating Page-by fields
2 types of Fact Expressions
40. Descriptive data that provides context for Facts.
Report Objects
Attribute Forms
Types of analysis you can perform with OLAP Services
Project Creation Wizard
41. You must select "Other directions" when drilling attributes while viewing a report
Fact Expression
5 Report display views
MSTR Desktop
To drill through User Hierarchies
42. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Project Creation Wizard
ID form
4 types of Metrics
Data warehouse characteristics
43. Create the Project Source - Create the Database Instance
Components of a MSTR architecture
Compound Attribute
To create the Project connectivity
2 components of a Physical Schema
44. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Project
4 properties you must know in order to create attributes using the Attribute Editor
Drilling
By default
45. Allow you to interact with the BI system - logically organize data to analyze complex relationships
Attribute Forms
Components of a Metric
Limitations of the Attribute Creation Wizard
MSTR applications
46. Using the Prompt Generation Wizard - Inside the Report Editor
Simple Attribute Expression
Report Definitions
Nested Metrics
To create a Report Prompt
47. All report-level options overwrite ___________.
Project-level options/settings
Limitations of the Attribute Creation Wizard
Architect Graphical Interface
Physical Schema
48. Facts associated to the same column name in 1 or more tables
File types are allowed for exporting a Report
Compound Attribute
Homogeneous Fact
Attribute Elements
49. Filter definition prompts - Object prompts - Value prompts - Level prompts
Architect Graphical Interface
Rollback your changes
Cannot create project objects
4 types of Prompts
50. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Project Creation Wizard
Project-level options/settings
Short-term (2 - 6 months)
Architect Graphical Interface