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. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views
Short-term (2 - 6 months)
3 components of a Report
2 options for Sorting
Objects you are allowed to Page-by
2. 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.
Configuration Wizard
Report Prompts
To "drill down" on a report
Attributes
3. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)
Cannot create project objects
Search-based prompts
Heterogeneous Attribute
Report Objects
4. Create the Project Source - Create the Database Instance
Components of a Derived Metric
Column Aliases
To create the Project connectivity
To drill through User Hierarchies
5. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...
To save a Report Format
Very high; part of ETL process
OLAP
Long-term (2 - 5 years)
6. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
5 steps to creating a logical data model
Aggregate a Metric
To drill through User Hierarchies
3 column types of a Physical Schema
7. The actual column name for a fact. Every fact must have at least 1 expression.
Logical Data Model
Fact Expression
Project Creation Wizard
Very high; part of ETL process
8. View Filters can only ___________.
Compound Metric
Metrics
Schema
Reference Report Objects
9. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema
5 Report display views
2 methods to creating Facts
4 parts of the Project Design Process
Highest-level attributes
10. 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
4 factors to consider when designing a data-warehouse schema
To "drill down" on a report
2 ways you can configure the Project Source to connect to the Metadata database
11. The System Hierarchy is automatically updated whenever you make a change to an __________________.
Table Keys
Advantage of a completely denormalized schema
Attribute or its relationship(s)
4 properties you must know in order to create attributes using the Attribute Editor
12. Facts - Attributes - Hierarchies
Components of the Logical Data Model
Report Objects
Reports
Lookup Tables
13. One that uses 2 or more columns as its ID
Homogeneous Attribute
To edit the appearance of a Graph in a report
Compound Attribute
Desktop Architec
14. Used to limit a possibly overwhelming set of potential prompt answers
Notes
Facts
Search-based prompts
Desktop Designer
15. What tool do you use to create the Metadata DSN connection?
2 types of Facts
MSTR Connectivity Wizard
Report Editor
Relationship Tables
16. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Components of Compound Metrics
Rollback your changes
Desktop Architec
Schema
17. Specifies a condition data must meet in order to be included in a report
MSTR Connectivity Wizard
The System
Report Filter
New SQL
18. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
Report Formatting
Unlimited
File types are allowed for exporting a Report
MSTR OLAP Services
19. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Thresholding
To create the Project connectivity
OLAP
User Hierarchies
20. More storage - Complex SQL - Simple ETL
Long-term (2 - 5 years)
To edit the appearance of a Graph in a report
2 components of a Physical Schema
Characteristics of a Compound Table Key
21. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
File > Email Reports As
Facts
MSTR OLAP Services
2 types of Fact Expressions
22. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Long-term (2 - 5 years)
Desktop Analyst
Components of a MSTR architecture
Fact Tables
23. A new tool for project design tasks - used for fine-tuning a project after initial creation
2 types of Attribute Relationships
Logical Data Model
Architect Graphical Interface
Source system characteristics
24. 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
Lookup Table structure of a completely normalized schema
Report Filter
Characteristics of Nested Metrics
MSTR applications
25. Store info on relationships between 2 or more tables (attributes) - like an Index table.
Report Template
Relationship Tables
2 ways you can configure the Project Source to connect to the Metadata database
'View of a Report'
26. Template - Filter - View of a Report
Short-term (2 - 6 months)
3 functions of Attribute Forms
3 components of a Report
2 types of Attribute Relationships
27. A development environment to create BI applications - allowing users to edit the Metadata database
Facts
3 Methods of MSTR Desktop navigation
Desktop Architec
2 options for Sorting
28. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
ETL process
Column Aliases
3 components of a Report
29. Top menu/dropdowns - Toolbar - Right-click popup menus
Attribute Relationships
Methods are there to creating Attributes
3 Methods of MSTR Desktop navigation
By default
30. An environment in which the MSTR Desktop connects directly to the Metadata database.
Project Creation Wizard
Attribute Forms
Characteristics of a Simple Table Key
2-Tier Architecture
31. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
File > Email Reports As
OLTP
Search Object
32. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
Characteristics of Nested Metrics
Desktop Designer
2 methods to creating Facts
Attribute Creation Wizard good for
33. Reduced number of JOINS in the generated SQL
Highest-level attributes
Advantage of a completely denormalized schema
Characteristics of a Simple Table Key
Lookup Table structure of a moderately denormalized schema
34. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics
Types of analysis you can perform with OLAP Services
2 ways you can configure the Project Source to connect to the Metadata database
Lookup Table structure of a moderately denormalized schema
4 factors to consider when designing a data-warehouse schema
35. Used to "fine-tune" your Project
Data Pivoting
Architect Graphical Interface
Project Creation Wizard
5 steps to creating a logical data model
36. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
Cannot create project objects
Value Prompts
2 types of Facts
Characteristics of a Compound Table Key
37. Enables you to lock column headers so that they always appear when scrolling
Aggregate a Metric
Types of drilling
Locking and Resizing
Nested Metrics
38. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
3 project creation interfaces
2 components of a Physical Schema
Fact Tables
3 Sections of the MSTR Desktop interface
39. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
To create a Report Prompt
MSTR Connectivity Wizard
Report Formatting
Project
40. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Long-term (2 - 5 years)
Display views you can Print by
Data warehouse characteristics
Logical Data Model
41. Homogeneous - Heterogeneous
Page-by
2 types of Facts
Project
Banding
42. Level of OLAP integration
4 factors to consider when designing a data-warehouse schema
Desktop Administrative Functions
Very high; part of ETL process
Shortcut Bar
43. Enables you to select and display subsets of a report as separate pages.
Heterogeneous Attribute
Page-by
2 options for Sorting
Report Filter operators
44. Compound - Homogeneous - Heterogeneous
3 types of Attributes
2 types of Attribute Relationships
Search Object
Filter Definition Prompts
45. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report
Facts
Data Pivoting
Compound Metric
'View of a Report'
46. All report-level options overwrite ___________.
Outline Mode
2 types of Table Keys
Schema Object Editor
Project-level options/settings
47. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Simple Attribute Expression
Desktop Analyst
Architect Graphical Interface
Schema Object Editor
48. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Logical Data Model
Column Aliases
Report Template
Project Creation Wizard
49. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
Architect Graphical Interface
Project Source
The System
50. Filter definition prompts - Object prompts - Value prompts - Level prompts
Data warehouse characteristics
4 types of Prompts
Methods are there to creating Attributes
3 column types of a Physical Schema
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