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. You can e-mail reports by going to _____
File > Email Reports As
2 components of a Physical Schema
2 types of Fact Expressions
Homogeneous Fact
2. You can _____________ in the Architect Graphical Interface.
Sorting
Desktop Designer
Rollback your changes
MSTR Connectivity Wizard
3. Enables you to rearrange the columns and rows in a report.
Attributes
Data Pivoting
Derived Metrics
2 types of Facts
4. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.
MSTR OLAP Services
Project Creation Wizard
Application Objects
Lookup Table structure of a completely denormalized schema
5. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
Heterogeneous Fact
Gigabytes (GB)
Attribute Elements
6. The unique values of an attribute obtained from the data-warehouse
Attribute or its relationship(s)
Components of the Logical Data Model
Attribute Elements
Schema
7. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
Types of analysis you can perform with OLAP Services
Stored
Report Filter operators
2 types of Attribute Relationships
8. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).
OLAP
4 types of Prompts
Derived Attribute Expression
Value Prompts
9. Allow you to interact with the BI system - logically organize data to analyze complex relationships
MSTR applications
Schema
ETL process
Report Subscription
10. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.
Physical Schema
Level Prompts
Gigabytes (GB)
To edit the appearance of a Graph in a report
11. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded
Configuration Wizard
Fact Tables
Facts
Factors to consider when designing a logical data model
12. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner
Shortcut Bar
4 properties you must know in order to create attributes using the Attribute Editor
2 components of a Physical Schema
Using a Search Object
13. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Project Source
Page-by
Long-term (2 - 5 years)
Process for creating the Project Metadata
14. Facts - Attributes - Hierarchies
Desktop Analyst
To "drill down" on a report
Report Prompts
Components of the Logical Data Model
15. A shortcut to an existing Object in a Project
Shortcut in MSTR Desktop
MSTR Desktop
Heterogeneous Attribute
Types of drilling
16. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.
MSTR Connectivity Wizard
Types of drilling
Facts
To qualify a Metric in a Set Qualification
17. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types
Cannot create project objects
Column Aliases
Desktop Architec
Hierarchies
18. 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
Factors to consider when designing a logical data model
Simple Metrics
3 functions of Attribute Forms
2 options for Sorting
19. It contains the ID column of all higher-level attributes
Heterogeneous Fact
Object Prompts
Lookup Table structure of a moderately denormalized schema
3 project creation interfaces
20. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling
Sample Metrics commonly performed on Facts
Outline Mode
3 Schema types
Search-based prompts
21. 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
Metrics
Rollback your changes
To qualify a Metric in a Set Qualification
Characteristics of Nested Metrics
22. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
Attribute or its relationship(s)
Components of Compound Metrics
User Hierarchies
Long-term (2 - 5 years)
23. View Filters can only ___________.
Process for creating the Project Metadata
Reference Report Objects
Fact Expression
Schema Object Editor
24. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents
The System
File types are allowed for exporting a Report
Desktop Designer
Components of Compound Metrics
25. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier
2 types of Table Keys
4 basic Schema objects
Homogeneous Fact
Object Prompts
26. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts
Different methods for creating Page-by fields
Objects you are allowed to Page-by
Data Pivoting
View Filters
27. A development environment to create BI applications - allowing users to edit the Metadata database
Methods are there to creating Attributes
3 Sections of the MSTR Desktop interface
The System
Desktop Architec
28. Facts associated to the same column name in 1 or more tables
Page-by
3 column types of a Physical Schema
Homogeneous Fact
Logical Data Model
29. 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
Report Filter
Different methods for creating Page-by fields
Logical Data Model
Warehouse Catalog
30. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data
Sample Metrics commonly performed on Facts
Schema Objects
Very high; part of ETL process
OLTP
31. Compound - Homogeneous - Heterogeneous
To "drill down" on a report
Reference Report Objects
Report Prompts
3 types of Attributes
32. The Attribute Form Expression that maps to a single column - no matter the number of tables
Desktop Architec
Using a Search Object
Simple Attribute Expression
2 components of a Physical Schema
33. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
MSTR Desktop
By default
Hierarchies
Unlimited
34. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound
Project-level options/settings
4 properties you must know in order to create attributes using the Attribute Editor
Components of a Derived Metric
Factors to consider when designing a logical data model
35. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.
Shortcut in MSTR Desktop
Report Definitions
Project
Components of a Metric
36. Create the Project Source - Create the Database Instance
3-Tier Architecture
To create the Project connectivity
Attribute Elements
Drilling
37. View Filters are saved with the _____________.
Attribute Creation Wizard good for
Table Keys
Report Definitions
To "drill down" on a report
38. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field
2 methods to creating Facts
Different methods for creating Page-by fields
Methods are there to creating Attributes
Facts
39. The default entry-points.
Highest-level attributes
Nested Metrics
ETL process
Desktop Administrative Functions
40. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
Unlimited
Very high; part of ETL process
Report Formatting
3-Tier Architecture
41. 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
42. A feature that enables users to delivers reports to the history list - cache or mobile
Report Subscription
2 types of Fact Expressions
3-Tier Architecture
Schema
43. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)
Attribute or its relationship(s)
Attribute Forms
Desktop Designer
Data warehouse characteristics
44. The Attribute Form maps to different column names in multiple tables
Required on the report for Outline Model to work
To qualify a Metric in a Set Qualification
Heterogeneous Attribute
New SQL
45. 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
View Filters
Factors to consider when designing a logical data model
Thresholding
Default Project folder structure
46. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Report Subscription
Fact Tables
Schema Object Editor
MSTR Connectivity Wizard
47. User requirements - Existing source data - Technical and performance considerations
Factors to consider when designing a logical data model
Reference Report Objects
MSTR Connectivity Wizard
Display views you can Print by
48. Must have a one-to-one relationship with all other forms.
Characteristics of a Compound Table Key
Sample Metrics commonly performed on Facts
Attribute Forms
Types of analysis you can perform with OLAP Services
49. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.
Report Definitions
The 3 MSTR Tools
Schema
2 types of Facts
50. Metrics aggregate on the lowest-level attribute __________.
By default
3 types of Attributes
Compound Metric
Report Filter
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