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. Direct: 2-tier - Server: 3-tier
3 Schema types
2 ways you can configure the Project Source to connect to the Metadata database
Report Filter
Methods are there to creating Attributes
2. Subtotals reflect accumulations at selected attribute levels
The System
Attributes
Subtotals
Physical Schema
3. 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
Characteristics of a Simple Table Key
Relationship Tables
To qualify a Metric in a Set Qualification
Attribute Relationships
4. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
Lookup Table structure of a moderately denormalized schema
Short-term (2 - 6 months)
Components of a Derived Metric
4 parts of the Project Design Process
5. Enables you to rearrange the columns and rows in a report.
Project Source
Search Object
File types are allowed for exporting a Report
Data Pivoting
6. 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
7. Formula - Level (Dimensionality) - Conditionality - Transformation
MSTR OLAP Services
Attribute Creation Wizard good for
2 types of Attribute Expression
Components of a Metric
8. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format
Components of the Logical Data Model
Data Pivoting
4 properties you must know in order to create attributes using the Attribute Editor
Unlimited
9. It contains the ID and DESC columns of all higher-level attributes
Gigabytes (GB)
3 column types of a Physical Schema
Project Source
Lookup Table structure of a completely denormalized schema
10. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Table Keys
Advantage of a completely denormalized schema
Unlimited
To edit the appearance of a Graph in a report
11. A method of organizing the appearance of report results in a Grid report based on a criteria
Report Prompts
Application Objects
Logical Data Model
Banding
12. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
OLAP
4 types of Prompts
Fact Expression
13. It contains the ID column of all higher-level attributes
Characteristics of a Compound Table Key
Object Prompts
Lookup Table structure of a moderately denormalized schema
Rollback your changes
14. Reduced number of JOINS in the generated SQL
To create a Report Prompt
Thresholding
Reports
Advantage of a completely denormalized schema
15. Used to limit a possibly overwhelming set of potential prompt answers
Report Editor
Sorting
3 column types of a Physical Schema
Search-based prompts
16. Used for - Initially populating the Metadata - Creating schema objects
Facts
MSTR Desktop Architect
MSTR OLAP Services
Cannot create project objects
17. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
3 project creation interfaces
Notes
Report Prompts
2 types of Attribute Relationships
18. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Factors to consider when designing a logical data model
Using a Search Object
View Filter
Facts
19. The logical associations between attributes that exist based on a business rule
Configuration Wizard
Desktop Administrative Functions
Attribute Relationships
Thresholding
20. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Shortcut Bar
Thresholding
Default Project folder structure
Heterogeneous Fact
21. It creates the System Hierarchy - when you define Attributes and their corresponding relationships
The System
Types of analysis you can perform with OLAP Services
Facts
Source system characteristics
22. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
Derived Metrics
Terabytes (TB)
Warehouse Catalog
23. Metrics you create within a report using only those objects in the report.
Report Prompts
Physical Schema
Derived Metrics
Schema Objects
24. More storage - Complex SQL - Simple ETL
By default
2 ways you can configure the Project Source to connect to the Metadata database
Characteristics of a Compound Table Key
Different methods for creating Page-by fields
25. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Types of drilling
Desktop Architec
Project Creation Wizard
2 types of Table Keys
26. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Compound Attribute
Simple Attribute Expression
The 3 MSTR Tools
27. Allow you to interact with the BI system - logically organize data to analyze complex relationships
MSTR applications
4 types of Prompts
Types of drilling
Terabytes (TB)
28. Tables - Facts - Attributes - Hierarchies
Search Object
Lookup Table structure of a moderately denormalized schema
Derived Metrics
4 basic Schema objects
29. The unique values of an attribute obtained from the data-warehouse
Components of a Metric
Different methods for creating Page-by fields
Attribute Elements
Banding
30. A new tool for project design tasks - used for fine-tuning a project after initial creation
Architect Graphical Interface
Drilling
Components of a Derived Metric
Report Subscription
31. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
4 tasks of the Attribute Creation Wizard
3 types of Attributes
Desktop Designer
3 Sections of the MSTR Desktop interface
32. Groupings of directly related attributes. Also commonly known as "dimensions".
Gigabytes (GB)
OLAP
Hierarchies
Limitations of the Attribute Creation Wizard
33. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
By default
Report Formatting
3-Tier Architecture
Level Prompts
34. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
3 Sections of the MSTR Desktop interface
2 methods to creating Facts
Compound Metric
Objects you are allowed to Page-by
35. Compound - Homogeneous - Heterogeneous
3 types of Attributes
Components of a MSTR architecture
4 tasks of the Attribute Creation Wizard
Search Object
36. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
Metrics
Different methods for creating Page-by fields
Derived Metrics
4 tasks of the Attribute Creation Wizard
37. Store info on relationships between 2 or more tables (attributes) - like an Index table.
To save a Report Format
Relationship Tables
Fact Tables
File types are allowed for exporting a Report
38. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Drilling
OLTP
Components of Compound Metrics
Gigabytes (GB)
39. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters
4 types of Report Filters
Banding
Filter Definition Prompts
OLAP
40. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling
Compound Metric
Tasks when defining a User Hierarchy
Display views you can Print by
Components of Compound Metrics
41. Level of OLAP integration
Fact Expression
Very high; part of ETL process
MSTR Connectivity Wizard
2-Tier Architecture
42. All report-level options overwrite ___________.
Project-level options/settings
Report Filter
4 basic Schema objects
Components of the Logical Data Model
43. User reporting requirements - Query performance - Data volume - DB Maintenance
Schema
Process for creating the Project Metadata
2 components of a Physical Schema
4 factors to consider when designing a data-warehouse schema
44. Extraction - transformation - loading
ETL
Short-term (2 - 6 months)
Components of a Metric
2 methods to creating Facts
45. Columns - Tables
2 components of a Physical Schema
Shortcut in MSTR Desktop
The System
2 types of Facts
46. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Report Objects
Schema Object Editor
3 column types of a Physical Schema
Facts
47. Primary keys
MSTR applications
Characteristics of a Compound Table Key
Table Keys
Subtotals
48. OLTP data storage measure
Data warehouse characteristics
Gigabytes (GB)
Desktop Designer
Methods are there to creating Attributes
49. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Components of a Metric
To create the Project connectivity
The 3 MSTR Tools
Schema
50. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Using a Search Object
Report Objects
Relationship Tables
Data warehouse characteristics