Test your basic knowledge |

Certified Project Designer Cpd

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. Folder List - Object Viewer - Shortcut Bar
4 types of Prompts
4 types of Report Filters
Advantage of a completely denormalized schema
3 Sections of the MSTR Desktop interface

2. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform
Data Pivoting
Logical Data Model
To "drill down" on a report
MSTR OLAP Services

3. Used to create or edit complex attributes - facts - hierarchies - and logical tables
Attribute Forms
Schema Object Editor
MSTR OLAP Services
Architect Graphical Interface

4. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)
Data warehouse characteristics
OLAP
Desktop Architec
3 column types of a Physical Schema

5. User management - Security profiles - Server parameters - like report length - idle time and report prioritization
Desktop Administrative Functions
Homogeneous Fact
To "drill down" on a report
Terabytes (TB)

6. Allow you to interact with the BI system - logically organize data to analyze complex relationships
MSTR applications
Characteristics of a Compound Table Key
Project-level options/settings
Characteristics of a Simple Table Key

7. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.
Drilling
Project Source
3 components of a Report
Report Filter operators

8. Schema Objects - Application Objects - Configuration Objects
2-Tier Architecture
New SQL
3 Types of Objects in MSTR Desktop
User Hierarchies

9. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.
2 types of Facts
To "drill down" on a report
3-Tier Architecture
ETL process

10. Extraction - transformation - loading
ETL
Desktop Administrative Functions
Report Definitions
Report Objects

11. It contains the ID column of all higher-level attributes
3 functions of Attribute Forms
OLAP
Sorting
Lookup Table structure of a moderately denormalized schema

12. You must select "Other directions" when drilling attributes while viewing a report
OLAP
3 types of Attributes
To drill through User Hierarchies
Thresholding

13. You can _____________ in the Architect Graphical Interface.
Rollback your changes
Types of drilling
Display views you can Print by
Project

14. A development environment to create BI applications - allowing users to edit the Metadata database
Desktop Architec
3 Schema types
Report Prompts
2 types of Facts

15. Enables you to select which tables from the data-warehouse to store in the Metadata database
Factors to consider when designing a logical data model
4 tasks of the Attribute Creation Wizard
Warehouse Catalog
Highest-level attributes

16. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities
Tasks when defining a User Hierarchy
Configuration Wizard
Desktop Analyst
Types of analysis you can perform with OLAP Services

17. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar
Stored
3 column types of a Physical Schema
Page-by
To "drill down" on a report

18. User requirements - Existing source data - Technical and performance considerations
Attributes
3-Tier Architecture
Factors to consider when designing a logical data model
2 types of Facts

19. 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
Cannot create project objects
Attribute Elements
Default Project folder structure
The System

20. User reporting requirements - Query performance - Data volume - DB Maintenance
4 factors to consider when designing a data-warehouse schema
Desktop Designer
Lookup Table structure of a moderately denormalized schema
By default

21. Enables you to format report values based on a condition - such as highlights - font colors - etc.
Architect Graphical Interface
Level Prompts
Thresholding
Project Creation Wizard

22. Used for - Initially populating the Metadata - Creating schema objects
MSTR Desktop Architect
New SQL
Page-by
2 ways you can configure the Project Source to connect to the Metadata database

23. A Project Source can house ________ . A single Metadata can be used by multiple Projects.
OLAP
Types of drilling
File types are allowed for exporting a Report
Unlimited

24. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View
Column Aliases
To edit the appearance of a Graph in a report
4 tasks of the Attribute Creation Wizard
Shortcut Bar

25. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save
3 project creation interfaces
Cannot create project objects
4 basic Schema objects
Components of the Logical Data Model

26. Facts - Attributes - Hierarchies
4 parts of the Project Design Process
Project Creation Wizard
Components of the Logical Data Model
Report Filter operators

27. Reduced number of JOINS in the generated SQL
Report Subscription
Components of a Derived Metric
Advantage of a completely denormalized schema
Report Formatting

28. Columns - Tables
2 components of a Physical Schema
Report Prompts
By default
Components of Compound Metrics

29. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell
Lookup Table structure of a completely denormalized schema
Report Definitions
Schema
Process for creating the Project Metadata

30. Level of OLAP integration
Very high; part of ETL process
4 factors to consider when designing a data-warehouse schema
3 components of a Report
Heterogeneous Attribute

31. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.
3 types of Attributes
Search-based prompts
Report Formatting
Logical Data Model

32. Specifies what info to retrieve from a data-warehouse - and how to display it
Report Template
4 parts of the Project Design Process
To save a Report Format
Cannot create project objects

33. The Attribute Form Expression that maps to a single column - no matter the number of tables
Simple Attribute Expression
To create the Project connectivity
Components of a MSTR architecture
The 3 MSTR Tools

34. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.
Using a Search Object
Factors to consider when designing a logical data model
Aggregate a Metric
Logical Data Model

35. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts
2 types of Attribute Relationships
Report Filter operators
Schema
Subtotals

36. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.
Compound Metric
4 factors to consider when designing a data-warehouse schema
Thresholding
MSTR applications

37. Compound - Homogeneous - Heterogeneous
3 types of Attributes
4 properties you must know in order to create attributes using the Attribute Editor
3 project creation interfaces
2 types of Fact Expressions

38. Enables you to select and display subsets of a report as separate pages.
Nested Metrics
3-Tier Architecture
Lookup Table structure of a completely denormalized schema
Page-by

39. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.
Hierarchies
Report Formatting
Reports
2 options for Sorting

40. The Attribute Form maps to the same column name in multiple tables
3 column types of a Physical Schema
Homogeneous Attribute
Search-based prompts
Different methods for creating Page-by fields

41. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations
Simple Metrics
2 ways you can configure the Project Source to connect to the Metadata database
Attribute Elements
Outline Mode

42. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports
Schema Objects
Long-term (2 - 5 years)
Attribute or its relationship(s)
Advantage of a completely denormalized schema

43. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.
Methods are there to creating Attributes
View Filter
Compound Metric
OLAP

44. Create the Project Source - Create the Database Instance
Heterogeneous Attribute
Desktop Architec
To create the Project connectivity
Types of analysis you can perform with OLAP Services

45. OLAP retains data ________
Warehouse Catalog
Long-term (2 - 5 years)
To create a Report Prompt
Required on the report for Outline Model to work

46. A shortcut to an existing Object in a Project
Shortcut in MSTR Desktop
Types of analysis you can perform with OLAP Services
Report Objects
User Hierarchies

47. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition
ETL
MSTR applications
Components of Compound Metrics
Terabytes (TB)

48. OLAP data storage measure
MSTR Connectivity Wizard
Attribute or its relationship(s)
Homogeneous Fact
Terabytes (TB)

49. Using the Prompt Generation Wizard - Inside the Report Editor
3 components of a Report
Long-term (2 - 5 years)
To create a Report Prompt
Architect Graphical Interface

50. 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
4 properties you must know in order to create attributes using the Attribute Editor
Value Prompts
Characteristics of Nested Metrics
Configuration Wizard