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. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
To edit the appearance of a Graph in a report
2-Tier Architecture
3 functions of Attribute Forms
Different methods for creating Page-by fields
2. It contains links to specific folders in the Folder List
To edit the appearance of a Graph in a report
Shortcut Bar
ETL
Architect Graphical Interface
3. Used to modify a Report
4 types of Prompts
Notes
Report Editor
Rollback your changes
4. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
OLTP
Fact Tables
Column Aliases
To create a Report Prompt
5. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
Display views you can Print by
Gigabytes (GB)
File > Email Reports As
6. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Outline Mode
2 types of Attribute Relationships
Characteristics of a Compound Table Key
Objects you are allowed to Page-by
7. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships
Highest-level attributes
Report Filter
4 tasks of the Attribute Creation Wizard
Stored
8. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Process for creating the Project Metadata
To "drill down" on a report
MSTR Desktop Architect
Report Prompts
9. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)
Report Filter
2 types of Attribute Relationships
Limitations of the Attribute Creation Wizard
File types are allowed for exporting a Report
10. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
5 Report display views
2 components of a Physical Schema
Components of Compound Metrics
Report Template
11. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Configuration Wizard
View Filters
2 types of Attribute Expression
12. OLAP retains data ________
Aggregate a Metric
Filter Definition Prompts
Long-term (2 - 5 years)
Compound Attribute
13. Metrics you create within a report using only those objects in the report.
Derived Metrics
Characteristics of Nested Metrics
Relationship Tables
Search-based prompts
14. To see data at completely different levels - other than that of the original Grid or Graph
Heterogeneous Fact
2 options for Sorting
Value Prompts
Drilling
15. The default entry-points.
Outline Mode
To save a Report Format
Highest-level attributes
Characteristics of a Simple Table Key
16. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Limitations of the Attribute Creation Wizard
Warehouse Catalog
Aggregate a Metric
Physical Schema
17. A user interface for creating and maintaining a BI environment
MSTR Desktop
Derived Metrics
Homogeneous Fact
The System
18. All report-level options overwrite ___________.
Project-level options/settings
To create the Project connectivity
Homogeneous Attribute
Physical Schema
19. The actual column name for a fact. Every fact must have at least 1 expression.
Fact Expression
Different methods for creating Page-by fields
Display views you can Print by
Components of the Logical Data Model
20. A condition data must meet in order to be included in a report. Does affect the SQL.
Report Filter
3 Methods of MSTR Desktop navigation
MSTR Connectivity Wizard
2 types of Attribute Relationships
21. Direct: 2-tier - Server: 3-tier
2 ways you can configure the Project Source to connect to the Metadata database
Desktop Designer
3 Schema types
Column Aliases
22. Using the Prompt Generation Wizard - Inside the Report Editor
Sorting
Homogeneous Fact
To create a Report Prompt
Outline Mode
23. Contains info that facilitates the transfer of data from the source systems to the data-warehouse
3 types of Attributes
Attribute Creation Wizard good for
4 types of Prompts
ETL process
24. Filter definition prompts - Object prompts - Value prompts - Level prompts
Report Subscription
Column Aliases
Search-based prompts
4 types of Prompts
25. Top menu/dropdowns - Toolbar - Right-click popup menus
Attribute Forms
Objects you are allowed to Page-by
3 Methods of MSTR Desktop navigation
Factors to consider when designing a logical data model
26. It contains the ID and DESC columns of all higher-level attributes
Lookup Table structure of a completely denormalized schema
Components of a Derived Metric
Terabytes (TB)
5 steps to creating a logical data model
27. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View
5 Report display views
Architect Graphical Interface
Cannot create project objects
Aggregate a Metric
28. Homogeneous - Heterogeneous
By default
2 types of Facts
Report Subscription
Report Prompts
29. Store info on relationships between 2 or more tables (attributes) - like an Index table.
3-Tier Architecture
4 properties you must know in order to create attributes using the Attribute Editor
Desktop Analyst
Relationship Tables
30. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Components of a MSTR architecture
Project Source
Desktop Analyst
Report Filter
31. View Filters can only ___________.
To create a Report Prompt
Reference Report Objects
Shortcut in MSTR Desktop
2 types of Attribute Relationships
32. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships
3 project creation interfaces
Level Prompts
3-Tier Architecture
Project Creation Wizard
33. Level of OLTP integration
5 steps to creating a logical data model
Search-based prompts
Minimal or none
2 types of Table Keys
34. 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
Schema Objects
4 tasks of the Attribute Creation Wizard
Tasks when defining a User Hierarchy
3 functions of Attribute Forms
35. More storage - Complex SQL - Simple ETL
User Hierarchies
Filter Definition Prompts
Characteristics of a Compound Table Key
Warehouse Catalog
36. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Attribute Creation Wizard good for
Project Creation Wizard
OLTP
3 Sections of the MSTR Desktop interface
37. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
Derived Attribute Expression
Schema Object Editor
To qualify a Metric in a Set Qualification
2 types of Attribute Relationships
38. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.
Report Editor
Short-term (2 - 6 months)
User Hierarchies
Lookup Table structure of a completely denormalized schema
39. To define the level of aggregation for a specific metric - Used for qualifications
2 types of Table Keys
Compound Attribute
Attributes
Configuration Wizard
40. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
2-Tier Architecture
Compound Metric
2 ways you can configure the Project Source to connect to the Metadata database
View Filters
41. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Reports
Desktop Administrative Functions
2 types of Fact Expressions
Minimal or none
42. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Report Objects
Rollback your changes
Unlimited
Facts
43. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies
4 tasks of the Attribute Creation Wizard
Attribute Relationships
5 steps to creating a logical data model
Column Aliases
44. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Attribute Forms
Report Formatting
Components of a Derived Metric
Long-term (2 - 5 years)
45. Enables you to select and display subsets of a report as separate pages.
Methods are there to creating Attributes
Page-by
Facts
Characteristics of Nested Metrics
46. Descriptive data that provides context for Facts.
Metrics
Report Filter
Attribute Forms
ETL process
47. All Attributes must have an _______.
Metrics
Sorting
Required on the report for Outline Model to work
ID form
48. Attribute Creation Wizard - Attribute Editor
Project-level options/settings
Rollback your changes
Subtotals
Methods are there to creating Attributes
49. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Hierarchies
OLAP
Desktop Analyst
Stored
50. Enables you to lock column headers so that they always appear when scrolling
Object Prompts
Components of a MSTR architecture
Locking and Resizing
Shortcut in MSTR Desktop
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests