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. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations
Application Objects
Characteristics of Nested Metrics
Homogeneous Attribute
'View of a Report'
2. Metrics you create within a report using only those objects in the report.
Advantage of a completely denormalized schema
Configuration Wizard
Derived Metrics
Fact Expression
3. 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
3 types of Attributes
3 components of a Report
Default Project folder structure
Report Prompts
4. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Thresholding
Sample Metrics commonly performed on Facts
2 types of Attribute Relationships
Report Objects
5. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form
3 functions of Attribute Forms
Level Prompts
OLAP
Configuration Wizard
6. ID columns - Description columns - Fact columns
3 column types of a Physical Schema
Data Pivoting
Fact Tables
Filter Definition Prompts
7. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
Tasks when defining a User Hierarchy
Sorting
Project Creation Wizard
Required on the report for Outline Model to work
8. How users can share comments for reports to other users
Notes
Unlimited
Source system characteristics
Thresholding
9. Level of OLAP integration
Very high; part of ETL process
Project Creation Wizard
3 Types of Objects in MSTR Desktop
Components of Compound Metrics
10. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
Source system characteristics
Report Formatting
Attribute Elements
Hierarchies
11. A feature that enables users to delivers reports to the history list - cache or mobile
View Filters
Fact Expression
Report Subscription
Outline Mode
12. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
2 options for Sorting
4 properties you must know in order to create attributes using the Attribute Editor
Rollback your changes
2 types of Fact Expressions
13. MS Excel - MS Word - MS Access - PDF - HTML - Plain text
Banding
File types are allowed for exporting a Report
File > Email Reports As
To "drill down" on a report
14. The Attribute Form maps to the same column name in multiple tables
Report Objects
Homogeneous Attribute
Required on the report for Outline Model to work
Derived Attribute Expression
15. It contains the ID column of the parent attribute
Value Prompts
Architect Graphical Interface
Components of the Logical Data Model
Lookup Table structure of a completely normalized schema
16. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
3-Tier Architecture
Unlimited
Search-based prompts
Report Filter operators
17. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Schema
Facts
MSTR applications
MSTR Desktop
18. Direct: 2-tier - Server: 3-tier
Lookup Table structure of a moderately denormalized schema
View Filters
2 ways you can configure the Project Source to connect to the Metadata database
4 tasks of the Attribute Creation Wizard
19. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
3 column types of a Physical Schema
Sorting
Cannot create project objects
The System
20. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
File types are allowed for exporting a Report
Attribute Relationships
The System
21. Create the Project Source - Create the Database Instance
Factors to consider when designing a logical data model
To create the Project connectivity
Homogeneous Fact
Architect Graphical Interface
22. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data
Attribute Forms
MSTR Desktop Architect
Source system characteristics
Relationship Tables
23. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Limitations of the Attribute Creation Wizard
Sorting
Desktop Architec
Derived Metrics
24. To define the level of aggregation for a specific metric - Used for qualifications
Attributes
File > Email Reports As
Table Keys
Fact Tables
25. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions
Rollback your changes
4 types of Report Filters
Facts
The 3 MSTR Tools
26. 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
27. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
Characteristics of a Compound Table Key
To save a Report Format
Schema Objects
3 functions of Attribute Forms
28. 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
Desktop Administrative Functions
Heterogeneous Attribute
Minimal or none
Logical Data Model
29. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
2 components of a Physical Schema
File > Email Reports As
5 Report display views
Filter Definition Prompts
30. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse
Stored
Sample Metrics commonly performed on Facts
Notes
To create the Project connectivity
31. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Compound Metric
User Hierarchies
Aggregate a Metric
32. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.
2 types of Fact Expressions
4 tasks of the Attribute Creation Wizard
Object Prompts
View Filter
33. The Attribute Form maps to different column names in multiple tables
Metrics
Heterogeneous Attribute
Reference Report Objects
Report Subscription
34. What tool do you use to create the Metadata shell?
Long-term (2 - 5 years)
Report Template
Configuration Wizard
Attributes
35. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Compound Metric
To create the Project connectivity
Search-based prompts
Components of a Derived Metric
36. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Heterogeneous Attribute
OLAP
Very high; part of ETL process
Physical Schema
37. OLAP Services does not add any ______ to the report query.
Characteristics of a Simple Table Key
New SQL
Schema
Attribute Creation Wizard good for
38. Enables you to select which tables from the data-warehouse to store in the Metadata database
Cannot create project objects
Warehouse Catalog
To create a Report Prompt
Report Objects
39. Must have Subtotals enabled - or you won't see any data for higher-level attributes
Simple Attribute Expression
Report Objects
Required on the report for Outline Model to work
2 components of a Physical Schema
40. Used for - Initially populating the Metadata - Creating schema objects
2 options for Sorting
2 types of Attribute Relationships
MSTR Desktop Architect
3 components of a Report
41. Subtotals reflect accumulations at selected attribute levels
Heterogeneous Fact
Subtotals
3 project creation interfaces
4 types of Metrics
42. Descriptive data that provides context for Facts.
Architect Graphical Interface
Heterogeneous Attribute
Characteristics of Nested Metrics
Attribute Forms
43. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Relationship Tables
Architect Graphical Interface
Components of a MSTR architecture
Heterogeneous Attribute
44. It contains links to specific folders in the Folder List
Shortcut Bar
3 Sections of the MSTR Desktop interface
Limitations of the Attribute Creation Wizard
Attributes
45. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Attribute Creation Wizard good for
4 types of Report Filters
Report Subscription
46. User requirements - Existing source data - Technical and performance considerations
Compound Attribute
Factors to consider when designing a logical data model
Attribute Forms
New SQL
47. Primary keys
Different methods for creating Page-by fields
2-Tier Architecture
Attribute Forms
Table Keys
48. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
4 parts of the Project Design Process
2 ways you can configure the Project Source to connect to the Metadata database
Types of drilling
To "drill down" on a report
49. Used to modify a Report
Report Editor
Thresholding
Sorting
4 types of Prompts
50. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.
Attributes
Schema
User Hierarchies
Outline Mode