- What is the difference between SSAS 2005 and SSAS2008?
- In 2005 its not possible to create an empty cube but in 2008 we can create an empty cube.
- A new feature in Analysis Services 2008 is the Attribute Relationships tab in the Dimension Designer . to implement attribute relationship is complex in ssas 2005
- we can create ONLY 2000 partitions per Measure Group in ssas 2005 and the same limit of partitions is removed in ssas 2008.
- What is datawarehouse in short DWH?
The datawarehouse is an informational environment that
- Provides an integrated and total view of the enterprise
- Makes the enterprise’s current and historical information easily available for decision making
- Makes decision-support transactions possible without hindering operational systems
- Renders the organization’s information consistent
- Presents a flexible and interactive source of strategic information
OR a warehouse is a
- Subject oriented
- Integrated
- Time variant
- Non volatile for doing decision support
OR
Collection of data in support of management’s decision making process”. He defined the terms in the sentence as follows.
OR
Subject oriented:
It define the specific business domain ex: banking, retail, insurance, etc…..
Integrated:
It should be in a position to integrated data from various source systems
Ex: sql,oracle,db2 etc……
Time variant:
It should be in a position to maintain the data the various time periods.
Non volatile:
Once data is inserted it can’t be changed
- What is data mart?
A data mart is a subset of an organizational data store, usually oriented to a specific purpose or major data subject that may be distributed to support business needs. Data marts are analytical data stores designed to focus on specific business functions for a specific community within an organization.
Data marts are often derived from subsets of data in a data warehouse, though in the bottom-up data warehouse design methodology the data warehouse is created from the union of organizational data marts.
They are 3 types of data mart they are
- Dependent
- Independent
- Logical data mart
- What are the difference between data mart and data warehouse?
Datawarehouse is complete data where as Data mart is Subset of the same.
Ex:
All the organisation data may related to finance department, HR, banking dept are stored in data warehouse where as in data mart only finance data or HR department data will be stored. So data warehouse is a collection of different data marts.
- Have you ever worked on performance tuning, if yes what are the steps involved in it?
We need to identify the bottlenecks to tune the performance, to overcome the bottleneck we need to following the following.
- Avoid named queries
- Unnecessary relationships between tables
- Proper attribute relationships to be given
- Proper aggregation design
- Proper partitioning of data
- Proper dimension usage design
- Avoid unnecessary many to many relationships
- Avoid unnecessary measures
- Set AttributeHierarchyEnabled = FALSE to Attributes that is not required
- Won’t take even single measure which is not necessary.
- What are the difficulties faced in cube development?
This question is either to test whether you are really experienced or when he doesnot have any questions to ask .. 😉
You can tell any area where you feel difficult to work. But always the best answers will be the following.
- Giving attribute relationships
- Calculations
- Giving dimension usage (many to many relationship)
- Analyzing the requirements
- Explain the flow of creating a cube?
Steps to create a cube in ssas
- Create a data source.
- Create a datasource view.
- Create Dimensions
- Create a cube.
- Deploy and Process the cube.
- What is a datasource or DS?
The data source is the Physical Connection information that analysis service uses to connect to the database that host the data. The data source contains the connection string which specifies the server and the database hosting the data as well as any necessary authentication credentials.
- What is datasourceview or DSV?
A data source view is a persistent set of tables from a data source that supply the data for a particular cube. BIDS also includes a wizard for creating data source views, which you can invoke by right-clicking on the Data Source Views folder in Solution Explorer.
- Datasource view is the logical view of the data in the data source.
- Data source view is the only thing a cube can see.
- What is named calculation?
A named calculation is a SQL expression represented as a calculated column. This expression appears and behaves as a column in the table. A named calculation lets you extend the relational schema of existing tables or views in a data source view without modifying the tables or views in the underlying data source.
Named calculation is used to create a new column in the DSV using hard coded values or by using existing columns or even with both.
- What is named query?
Named query in DSV is similar to View in Database. This is used to create Virtual table in DSV which will not impact the underlying database. Named query is mainly used to merge the two or more table in the datasource view or to filter columns of a table.
- Why we need named queries?
A named query is used to join multiple tables, to remove unnecessary columns from a table of a database. You can achieve the same in database using Views but this Named Queries will be the best bet whe you don’t have access to create Views in database.
- How will you add a new column to an existing table in data source view?
By using named calculations we can add a new column to an existing table in the data source view. Named Calculation is explained above.
- What is dimension table?
A dimension table contains hierarchical data by which you’d like to summarize. A dimension table contains specific business information, a dimension table that contains the specific name of each member of the dimension. The name of the dimension member is called an “attribute”
The key attribute in the dimension must contain a unique value for each member of the dimension. This key attribute is called “primary key column”
The primary key column of each dimension table corresponding to the one of the key column in any related fact table.
- What is fact table?
A fact table contains the basic information that you wish to summarize. The table that stores the detailed value for measure is called fact table. In simple and best we can define as “The table which contains METRICS” that are used to analyse the business.
It consists of 2 sections
1) Foregine key to the dimesion
2) measures/facts(a numerical value that used to monitor business activity)
- What is Factless fact table?
This is very important interview question. The “Factless Fact Table” is a table which is similar to Fact Table except for having any measure; I mean that this table just has the links to the dimensions. These tables enable you to track events; indeed they are for recording events.
Factless fact tables are used for tracking a process or collecting stats. They are called so because, the fact table does not have aggregatable numeric values or information. They are mere key values with reference to the dimensions from which the stats can be collected
- What is attribute relationships, why we need it?
Attribute relationships are the way of telling the analysis service engine that how the attributes are related with each other. It will help to relate two or more attributes to each other.Processing time will be decreased if proper relationships are given. This increases the Cube Processing performance and MDX query performance too.
In Microsoft SQL Server Analysis Services, attributes within a dimension are always related either directly or indirectly to the key attribute. When you define a dimension based on a star schema, which is where all dimension attributes are derived from the same relational table, an attribute relationship is automatically defined between the key attribute and each non-key attribute of the dimension. When you define a dimension based on a snowflake schema, which is where dimension attributes are derived from multiple related tables, an attribute relationship is automatically defined as follows:
- Between the key attribute and each non-key attribute bound to columns in the main dimension table.
- Between the key attribute and the attribute bound to the foreign key in the secondary table that links the underlying dimension tables.
- Between the attribute bound to foreign key in the secondary table and each non-key attribute bound to columns from the secondary table.
- How many types of attribute relationships are there?
They are 2 types of attribute relationships they are
- Rigid
- Flexible
Rigid: In Rigid relationships where the relationship between the attributes is fixed, attributes will not change levels or their respective attribute relationships.
Example: The time dimension. We know that month “January 2009” will ONLY belong to Year “2009” and it wont be moved to any other year.
Flexible : In Flexible relationship between the attributes is changed.
Example: An employee and department. An employee can be in accounts department today but it is possible that the employee will be in Marketing department tomorrow.
- How many types of dimensions are there and what are they?
They are 3 types of dimensions:
- confirm dimension
- junk dimension
- degenerate attribute
- What are confirmed dimensions, junk dimension and degenerated dimensions?
Confirm dimension: It is the dimension which is sharable across the multiple facts or data model. This is also called as Role Playing Dimensions.
junk dimension: A number of very small dimensions might be lumped (a small irregularly shaped) together to form a single dimension, a junk dimension – the attributes are not closely related. Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension is known as junk dimension.
Degenerated dimension: In this degenerate dimension contains their values in fact table and the dimension id not available in dimension table. Degenerated Dimension is a dimension key without corresponding dimension.
Example: In the PointOfSale Transaction Fact table, we have:
Date Key (FK), Product Key (FK), Store Key (FK), Promotion Key (FP), and POS Transaction Number
Date Dimension corresponds to Date Key, Production Dimension corresponds to Production Key. In a traditional parent-child database, POS Transactional Number would be the key to the transaction header record that contains all the info valid for the transaction as a whole, such as the transaction date and store identifier. But in this dimensional model, we have already extracted this info into other dimension. Therefore, POS Transaction Number looks like a dimension key in the fact table but does not have the corresponding dimension table.
- What are the types of database schema?
They are 3 types of database schema they are
- Star
- Snowflake
- Starflake
- What is star, snowflake and star flake schema?
Star schema: In star schema fact table will be directly linked with all dimension tables. The star schema’s dimensions are denormalized with each dimension being represented by a single table. In a star schema a central fact table connects a number of individual dimension tables.
Snowflake: The snowflake schema is an extension of the star schema, where each point of the star explodes into more points. In a star schema, each dimension is represented by a single dimensional table, whereas in a snowflake schema, that dimensional table is normalized into multiple lookup tables, each representing a level in the dimensional hierarchy. In snow flake schema fact table will be linked directly as well as there will be some intermediate dimension tables between fact and dimension tables.
Star flake: A hybrid structure that contains a mixture of star(denormalized) and snowflake(normalized) schema’s.
- How will you hide an attribute?
We can hide the attribute by selecting “AttributeHierarchyVisible = False” in properties of the attribute.
- How will you make an attribute not process?
By selecting “ AttributeHierarchyEnabled = False”, we can make an attribute not in process.
- What is use of IsAggregatable property?
In Analysis Service we generally see all dimension has All member. This is because of IsAggregatable property of the attribute. You can set its value to false, so that it will not show All member. Its default member for that attribute. If you hide this member than you will have to set other attribute value to default member else it will pick some value as default and this will create confusion in browsing data if someone is not known to change in default member.
- What are key, name and value columns of an attribute?
Key column of any attribute: Contains the column or columns that represent the key for the attribute, which is the column in the underlying relational table in the data source view to which the attribute is bound. The value of this column for each member is displayed to users unless a value is specified for the NameColumn property.
Name column of an attribute: Identifies the column that provides the name of the attribute that is displayed to users, instead of the value in the key column for the attribute. This column is used when the key column value for an attribute member is cryptic or not otherwise useful to the user, or when the key column is based on a composite key. The NameColumn property is not used in parent-child hierarchies; instead, the NameColumn property for child members is used as the member names in a parent-child hierarchy.
Value columns of an attribute: Identifies the column that provides the value of the attribute. If the NameColumn element of the attribute is specified, the same DataItem values are used as default values for the ValueColumn element. If the NameColumn element of the attribute is not specified and the KeyColumns collection of the attribute contains a single KeyColumn element representing a key column with a string data type, the same DataItem values are used as default values for the ValueColumn element.
- What is hierarchy, what are its types and difference between them?
A hierarchy is a very important part of any OLAP engine and allows users to drill down from summary levels hierarchies represent the way user expect to explore data at more detailed level
hierarchies is made up of multipule levels creating the structure based on end user requirements.
->years->quarter->month->week ,are all the levels of calender hierarchy
They are 2 types of hierarchies they are
- Natural hierarchy
- Unnatural hierarchy
Natural hierarchy: This means that the attributes are intuitively related to one another. There is a clear relationship from the top of the hierarchy to the bottom.
Example: An example of this would be date: year, quarter and month follow from each other, and in part, define each other.
Unnatural hierarchy: This means that the attributes are not clearly related.
Example: An example of this might be geography; we may have country -> state -> city, but it is not clear where Province might sit.
- What is Attribute hierarchy?
An attribute hierarchy is created for every attribute in a dimension, and each hierarchy is available for dimensioning fact data. This hierarchy consists of an “All” level and a detail level containing all members of the hierarchy.
you can organize attributes into user-defined hierarchies to provide navigation paths in a cube. Under certain circumstances, you may want to disable or hide some attributes and their hierarchies.
- What is use of AttributeHierarchyDisplayFolder property ?
AttributeHierarchyDisplayFolder: Identifies the folder in which to display the associated attribute hierarchy to end users. For example if I set the property value as “Test” to all the Attributes of a dimension then a folder with the name “Test” will be created and all the Attributes will be placed into the same.
- What is use of AttributeHierarchyEnabled?
AttributeHierarchyEnabled: Determines whether an attribute hierarchy is generated by Analysis Services for the attribute. If the attribute hierarchy is not enabled, the attribute cannot be used in a user-defined hierarchy and the attribute hierarchy cannot be referenced in Multidimensional Expressions (MDX) statements.
- What is use of AttributeHierarchyOptimizedState?
AttributeHierarchyOptimizedState: Determines the level of optimization applied to the attribute hierarchy. By default, an attribute hierarchy is FullyOptimized, which means that Analysis Services builds indexes for the attribute hierarchy to improve query performance. The other option, NotOptimized, means that no indexes are built for the attribute hierarchy. Using NotOptimized is useful if the attribute hierarchy is used for purposes other than querying, because no additional indexes are built for the attribute. Other uses for an attribute hierarchy can be helping to order another attribute.
- What is use of AttributeHierarchyOrdered ?
AttributeHierarchyOrdered: Determines whether the associated attribute hierarchy is ordered. The default value is True. However, if an attribute hierarchy will not be used for querying, you can save processing time by changing the value of this property to False.
- What is the use of AttributeHierarchyVisible ?
AttributeHierarchyVisible : Determines whether the attribute hierarchy is visible to client applications. The default value is True. However, if an attribute hierarchy will not be used for querying, you can save processing time by changing the value of this property to False.
- What are types of storage modes?
There are three standard storage modes in OLAP applications
- MOLAP
- ROLAP
- HOLAP
- Compare the Three Storage Modes ?
Summary and comparison
Basic Storage Mode | Storage Location for Detail Data | Storage Location for Summary/ Aggregations | Storage space requirement | Query Response Time | Processing Time | Latency |
MOLAP | Multidimensional Format | Multidimensional Format | MediumBecause detail data is stored in compressed format. | Fast | Fast | High |
HOLAP | Relational Database | Multidimensional Format | Small | Medium | Fast | Medium |
ROLAP | Relational Database | Relational Database | Large | Slow | Slow | Low |
- What is MOLAP and its advantage?
MOLAP (Multi dimensional Online Analytical Processing) : MOLAP is the most used storage type. Its designed to offer maximum query performance to the users. the data and aggregations are stored in a multidimensional format, compressed and optimized for performance. This is both good and bad. When a cube with MOLAP storage is processed, the data is pulled from the relational database, the aggregations are performed, and the data is stored in the AS database. The data inside the cube will refresh only when the cube is processed, so latency is high.
Advantages:
- Since the data is stored on the OLAP server in optimized format, queries (even complex calculations) are faster than ROLAP.
- The data is compressed so it takes up less space.
- And because the data is stored on the OLAP server, you don’t need to keep the connection to the relational database.
- Cube browsing is fastest using MOLAP.
- What is ROLAP and its advantage?
ROLAP (Relational Online Analytical Processing) : ROLAP does not have the high latency disadvantage of MOLAP. With ROLAP, the data and aggregations are stored in relational format. This means that there will be zero latency between the relational source database and the cube.
Disadvantage of this mode is the performance, this type gives the poorest query performance because no objects benefit from multi dimensional storage.
Advantages:
- Since the data is kept in the relational database instead of on the OLAP server, you can view the data in almost real time.
- Also, since the data is kept in the relational database, it allows for much larger amounts of data, which can mean better scalability.
- Low latency.
- What is HOLAP and its advantage?
Hybrid Online Analytical Processing (HOLAP): HOLAP is a combination of MOLAP and ROLAP. HOLAP stores the detail data in the relational database but stores the aggregations in multidimensional format. Because of this, the aggregations will need to be processed when changes are occur. With HOLAP you kind of have medium query performance: not as slow as ROLAP, but not as fast as MOLAP. If, however, you were only querying aggregated data or using a cached query, query performance would be similar to MOLAP. But when you need to get that detail data, performance is closer to ROLAP.
Advantages:
- HOLAP is best used when large amounts of aggregations are queried often with little detail data, offering high performance and lower storage requirements.
- Cubes are smaller than MOLAP since the detail data is kept in the relational database.
- Processing time is less than MOLAP since only aggregations are stored in multidimensional format.
- Low latency since processing takes place when changes occur and detail data is kept in the relational database.
- What are Translations and its use?
Translation: The translation feature in analysis service allows you to display caption and attributes names that correspond to a specific language. It helps in providing GLOBALIZATION to the Cube.
- What is Database dimension?
All the dimensions that are created using NEW DIMENSION Wizard are database dimensions. In other words, the dimensions which are at Database level are called Database Dimensions.
- What is Cube dimension?
A cube dimension is an instance of a database dimension within a cube is called as cube dimension. A database dimension can be used in multiple cubes, and multiple cube dimensions can be based on a single database dimension
- Difference between Database dimension and Cube dimension?
- The Database dimension has only Name and ID properties, whereas a Cube dimension has several more properties.
- Database dimension is created one where as Cube dimension is referenced from database dimension.
- Database dimension exists only once.where as Cube dimensions can be created more than one using ROLE PLAYING Dimensions concept.
- How will you add a dimension to cube?
To add a dimension to a cube follow these steps.
- In Solution Explorer, right-click the cube, and then click View Designer.
- In the Design tab for the cube, click the Dimension Usage tab.
- Either click the Add Cube Dimension button, or right-click anywhere on the work surface and then click Add Cube Dimension.
- In the Add Cube Dimension dialog box, use one of the following steps:
- To add an existing dimension, select the dimension, and then click OK.
- To create a new dimension to add to the cube, click New dimension, and then follow the steps in the Dimension Wizard.
- What is SCD (slowly changing dimension)?
Slowly changing dimensions (SCD) determine how the historical changes in the dimension tables are handled. Implementing the SCD mechanism enables users to know to which category an item belonged to in any given date.
- What are types of SCD?
It is a concept of STORING Historical Changes and when ever an IT guy finds a new way to store then a new Type will come into picture. Basically there are 3 types of SCD they are given below
- SCD type1
- SCD type2
- SCD type3
- What is Type1, Type2, Type3 of SCD?
Type 1: In Type 1 Slowly Changing Dimension, the new information simply overwrites the original information. In other words, no history is kept.
In our example, recall we originally have the following table:
Customer Key | Name | State |
1001 | Christina | Illinois |
After Christina moved from Illinois to California, the new information replaces the new record, and we have the following table:
Customer Key | Name | State |
1001 | Christina | California |
Advantages: This is the easiest way to handle the Slowly Changing Dimension problem, since there is no need to keep track of the old information.
Disadvantages: All history is lost. By applying this methodology, it is not possible to trace back in history.
Usage: About 50% of the time.
When to use Type 1: Type 1 slowly changing dimension should be used when it is not necessary for the data warehouse to keep track of historical changes.
Type 2: In Type 2 Slowly Changing Dimension, a new record is added to the table to represent the new information. Therefore, both the original and the new record will be present. The new record gets its own primary key.
In our example, recall we originally have the following table:
Customer Key | Name | State |
1001 | Christina | Illinois |
After Christina moved from Illinois to California, we add the new information as a new row into the table:
Customer Key | Name | State |
1001 | Christina | Illinois |
1005 | Christina | California |
Advantages: This allows us to accurately keep all historical information.
Disadvantages:
- This will cause the size of the table to grow fast. In cases where the number of rows for the table is very high to start with, storage and performance can become a concern.
- This necessarily complicates the ETL process.
Usage: About 50% of the time.
Type3 : In Type 3 Slowly Changing Dimension, there will be two columns to indicate the particular attribute of interest, one indicating the original value, and one indicating the current value. There will also be a column that indicates when the current value becomes active.
In our example, recall we originally have the following table:
Customer Key | Name | State |
1001 | Christina | Illinois |
To accommodate Type 3 Slowly Changing Dimension, we will now have the following columns:
Customer Key,Name,OriginalState,CurrentState,Effective Date
After Christina moved from Illinois to California, the original information gets updated, and we have the following table (assuming the effective date of change is January 15, 2003):
Customer Key | Name | OriginalState | CurrentState | Effective Date |
1001 | Christina | Illinois | California | 15-JAN-2003 |
Advantages:
- This does not increase the size of the table, since new information is updated.
- This allows us to keep some part of history.
Disadvantages: Type 3 will not be able to keep all history where an attribute is changed more than once. For example, if Christina later moves to Texas on December 15, 2003, the California information will be lost.
Usage: Type 3 is rarely used in actual practice.
- What is role playing dimension with two examples?
Role play dimensions: We already discussed about this. This is nothing but CONFIRMED Dimensions. A dimension can play different role in a fact table you can recognize a roleplay dimension when there are multiple columns in a fact table that each have foreign keys to the same dimension table.
Ex1: There are three dimension keys in the factinternalsales,factresellersales tables which all refer to the dimtime table,the same time dimension is used to track sales by that contain either of these fact table,the corresponding role-playing dimension are automatically added to the cube.
Ex2 : In retail banking, for checking account cube we could have transaction date dimension and effective date dimension. Both dimensions have date, month, quarter and year attributes. The formats of attributes are the same on both dimensions, for example the date attribute is in ‘dd-mm-yyyy’ format. Both dimensions have members from 1993 to 2010.
- What is measure group, measure?
Measure groups : These measure groups can contain different dimensions and be at different granularity but so long as you model your cube correctly, your users will be able to use measures from each of these measure groups in their queries easily and without worrying about the underlying complexity.
Creating multiple measure groups : To create a new measure group in the Cube Editor, go to the Cube Structure tab and right-click on the cube name in the Measures pane and select ‘New Measure Group’. You’ll then need to select the fact table to create the measure group from and then the new measure group will be created; any columns that aren’t used as foreign key columns in the DSV will automatically be created as measures, and you’ll also get an extra measure of aggregation type Count. It’s a good idea to delete any measures you are not going to use at this stage.
Measures : Measures are the numeric values that our users want to aggregate, slice, dice and otherwise analyze, and as a result, it’s important to make sure they behave the way we want them to. One of the fundamental reasons for using Analysis Services is that, unlike a relational database it allows us to build into our cube design business rules about measures: how they should be formatted, how they should aggregate up, how they interact with specific dimensions and so on.
- What is attribute?
An attribute is a specification that defines a property of an object, element, or file. It may also refer to or set the specific value for a given instance of such.
- What is surrogate key?
A surrogate key is the SQL generated key which acts like an alternate primary key for the table in database, Data warehouses commonly use a surrogate key to uniquely identify an entity. A surrogate is not generated by the user but by the system. A primary difference between a primary key and surrogate key in few databases is that primarykey uniquely identifies a record while a Surrogatekey uniquely identifies an entity.
Ex: An employee may be recruited before the year 2000 while another employee with the same name may be recruited after the year 2000. Here, the primary key will uniquely identify the record while the surrogate key will be generated by the system (say a serial number) since the SK is NOT derived from the data.
- How many types of relations are there between dimension and measure group?
They are six relation between the dimension and measure group, they are
- No Relationship
- Regular
- Refernce
- Many to Many
- Data Mining
- Fact
- What is regular type, no relation type, fact type, referenced type, many-to-many type with example?
No relationship: The dimension and measure group are not related.
Regular: The dimension table is joined directly to the fact table.
Referenced: The dimension table is joined to an intermediate table, which in turn,is joined to the fact table.
Many to many:The dimension table is to an intermediate fact table,the intermediate fact table is joined , in turn, to an intermediate dimension table to which the fact table is joined.
Data mining:The target dimension is based on a mining model built from the source dimension. The source dimension must also be included in the cube.
Fact table: The dimension table is the fact table.
- What are calculated members and what is its use?
Calculations are item in the cube that are eveluated at runtime
Calculated members: You can create customized measures or dimension members, called calculated members, by combining cube data, arithmetic operators, numbers, and/or functions.
Example: You can create a calculated member called Marks that converts dollars to marks by multiplying an existing dollar measure by a conversion rate. Marks can then be displayed to end users in a separate row or column. Calculated member definitions are stored, but their values exist only in memory. In the preceding example, values in marks are displayed to end users but are not stored as cube data.
- What are KPIs and what is its use?
In Analysis Services, a KPI is a collection of calculations that are associated with a measure group in a cube that are used to evaluate business success. We use KPI to see the business at the particular point, this is represents with some graphical items such as traffic signals,ganze etc
- What are actions, how many types of actions are there, explain with example?
Actions are powerful way of extending the value of SSAS cubes for the end user. They can click on a cube or portion of a cube to start an application with the selected item as a parameter, or to retrieve information about the selected item.
One of the objects supported by a SQL Server Analysis Services cube is the action. An action is an event that a user can initiate when accessing cube data. The event can take a number of forms. For example, a user might be able to view a Reporting Services report, open a Web page, or drill through to detailed information related to the cube data
Analysis Services supports three types of actions..
Report action: Report action Returns a Reporting Services report that is associated with the cube data on which the action is based.
Drill through: Drillthrough Returns a result set that provides detailed information related to the cube data on which the action is based.
Standard: Standard has five action subtypes that are based on the specified cube data.
Dataset: Returns a mutlidimensional dataset.
Proprietary: Returns a string that can be interpreted by a client application.
Rowset: Returns a tabular rowset.
Statement: Returns a command string that can be run by a client application.
URL: Returns a URL that can be opened by a client application, usually a browser.
- What is partition, how will you implement it?
You can use the Partition Wizard to define partitions for a measure group in a cube. By default, a single partition is defined for each measure group in a cube. Access and processing performance, however, can degrade for large partitions. By creating multiple partitions, each containing a portion of the data for a measure group, you can improve the access and processing performance for that measure group.
- What is the minimum and maximum number of partitions required for a measure group?
In 2005 a MAX of 2000 partitions can be created per measure group and that limit is lifted in later versions.
In any version the MINIMUM is ONE Partition per measure group.
- What are Aggregations and its use?
Aggregations provide performance improvements by allowing Microsoft SQL Server Analysis Services (SSAS) to retrieve pre-calculated totals directly from cube storage instead of having to recalculate data from an underlying data source for each query. To design these aggregations, you can use the Aggregation Design Wizard. This wizard guides you through the following steps:
- Selecting standard or custom settings for the storage and caching options of a partition, measure group, or cube.
- Providing estimated or actual counts for objects referenced by the partition, measure group, or cube.
- Specifying aggregation options and limits to optimize the storage and query performance delivered by designed aggregations.
- Saving and optionally processing the partition, measure group, or cube to generate the defined aggregations.
- After you use the Aggregation Design Wizard, you can use the Usage-Based Optimization Wizard to design aggregations based on the usage patterns of the business users and client applications that query the cube.
- What is perspective, have you ever created perspective?
Perspectives are a way to reduce the complexity of cubes by hidden elements like measure groups, measures, dimensions, hierarchies etc. It’s nothing but slicing of a cube, for ex we are having retail and hospital data and end user is subscribed to see only hospital data, then we can create perspective according to it.
- What is deploy, process and build?
Bulid: Verifies the project files and create several local files.
Deploy: Deploy the structure of the cube(Skeleton) to the server.
Process: Read the data from the source and build the dimesions and cube structures
Elaborating the same is given below.
Build: Its is a used to process the data of the cube database. Build is a version of a program. As a rule, a build is a pre-release version and as such is identified by a build number, rather than by a release number. Reiterative (repeated) builds are an important part of the development process. Throughout development, application components are collected and repeatedly compiled for testing purposes, to ensure a reliable final product. Build tools, such as make or Ant, enable developers to automate some programming tasks. As a verb, to build can mean either to write code or to put individual coded components of a program together.
Deployment: During development of an Analysis Services project in Business Intelligence Development Studio, you frequently deploy the project to a development server in order to create the Analysis Services database defined by the project. This is required to test the project.
for example, to browse cells in the cube, browse dimension members, or verify key performance indicators (KPIs) formulas.
- What is the maximum size of a dimension?
The maximum size of the dimension is 4 gb.
- What are the types of processing and explain each?
They are 6 types of processing in ssas ,they are
- Process Full
- Process Data
- Process Index
- Process Incremental
- Process Structure
- UnProcess
Process Full: Processes an Analysis Services object and all the objects that it contains. When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is required when a structural change has been made to an object, for example, when an attribute hierarchy is added, deleted, or renamed. This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions.
Process Data: Processes data only without building aggregations or indexes. If there is data is in the partitions, it will be dropped before re-populating the partition with source data. This processing option is supported for dimensions, cubes, measure groups, and partitions.
Process Index: Creates or rebuilds indexes and aggregations for all processed partitions. This option causes an error on unprocessed objects. This processing option is supported for cubes, dimensions, measure groups, and partitions.
Process Increment: Adds newly available fact data and process only to the relevant partitions. This processing option is supported for measure groups, and partitions.
Process Structure: If the cube is unprocessed, Analysis Services will process, if it is necessary, all the cube’s dimensions. After that, Analysis Services will create only cube definitions. If this option is applied to a mining structure, it populates the mining structure with source data. The difference between this option and the Process Full option is that this option does not iterate the processing down to the mining models themselves. This processing option is supported for cubes and mining structures.
Unprocess : Drops the data in the object specified and any lower-level constituent objects. After the data is dropped, it is not reloaded. This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions.
Process Default: Detects the process state of an object, and performs processing necessary to deliver unprocessed or partially processed objects to a fully processed state. This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions.
- What is a cube?
The basic unit of storage and analysis in Analysis Services is the cube. A cube is a collection of data that’s been aggregated to allow queries to return data quickly.
For example, a cube of order data might be aggregated by time period and by title, making the cube fast when you ask questions concerning orders by week or orders by title.
- What is AMO?
The full form of AMO is Analysis Managament Objects. This is used to create or alter cubes from .NET code.
- After creating the cube, if we added a new column to the OLTP table then how you add this new attribute to the cube?
Just open the datasourceview and on right click we find the option REFRESH. Click the REFRESH then it will add new attributes to the table which can be added to Cube.
REAL TIME INTERVIEW QUESTIONS –
- What is the size of the Cube in your last Project?
Answer to this question varies from project to project and mainly depends on how BIG is your database and how COMPLEX the database design is. Generally for the database with a TRANSACTION TABLE of 50 crore records, the cube size will be around 100GB. So, better go with 100GB as answer to this question.
- What is size of the database in your last Project?
- What is size of the fact(Transaction) table in your last Project?
- How frequently you process the cube?
- How frequently you get DATA from clients?
- What type of Processing Options you used to process the cube in your Project?
- If the database is SMALL, let’s say it has only 1 crore records then people do FULL PROCESS as it wont take much time.
- If the database is MEDIUM, let’s say it has only 15 crore records then people prefer to do INCREMENTAL PROCESS unless CLIENTS ask us to do FULL PROCESS as it takes little bit of time.
- If the database is HUGE, let’s say it has more than 35 to 40 crore records then people prefer to do INCREMENTAL PROCESS unless CLIENTS ask us to do FULL PROCESS as it takes lot of time. In this case we TRY to convince clients for INCREMENTAL and if they don’t agree then we don’t have any other option.
- Incremental process will come into picture ONLY when there is no updates to the OLD data i.e no changes to already existing data else NO OTHER OPTION than FULL PROCESS.
- How you provide security to cube?
- Define Role
- Set Permission
- Add appropriate Users to the role
- How you move the cube from one server to another?
- Backup and restore – This is the simplest way. Take the Backup from development server and copy the backup to FTP folder of clients. After doing this drop a mail to Client’s Admin and he will take care of RESTORE part.
- Directly PROCESS the cube in PRODUCTION environment. For this you need access to Production which will not be given by clients unless the clients are *********. One of the client I worked for given FULL access to me .. 😉
- Under Srart –> All Programs –> Sql Server –> Analysis Services you can see deployment wizard. This is one way of moving the cube. This method has some steps to follow. First deploy your cube and FOUR files will be created in BIN folder of PROJECT folder. Copy those FOUR files and paste in Production server in any directory. Then OPEN this DEPLOYMENT Wizard in production and when it ask for Database file then point to the location where you copied the files. After that NEXT,NEXT,NEXT … OK .. Cube will be deployed and processed.
- This way is most beautiful one. Synchronization, In this we will first deploy and process the cube in STAGING ENVIRONMENT and then we will go to production server. Connect to Analysis services in SSMS and select Synchronize by right clicking on Databases folder in SSMS of analysis services. Then select source as STAGING SERVER and then click on OK. The changes in the cube present in the Staging server will be copied to the production server.
- What is the toughest challenge you face in your Project?
- While working on RELATIONSHIPS between Measure Groups and Dimensions.
- Working on Complex calculations
- Performance tuning
- How you created Partitions of the cube in your Last Project?
- How many dimensions in your last cube?
- How many measure groups in your last cube?
- What is the Schema of your last cube?
- Why not STAR Schema ?
My data base design doesn’t support STAR Schema.
- What are the different relationships that you are used in your cube?
- Regular
- Referenced
- Many to Many
- Fact
- No Relationship
- Have you created the KPI’s , If then Explain?
- How you define Aggregations in your Project?
- Size of SSAS team in your last Project?
Just 2 guys as we guys are really in demand and lot of scarcity:)
- How many Resources worked on same Cube in your Project?
- How much time it take to Process the Cube?
- How many Calculation you done in Your Project?
Roopesh Valluru…… we gained a lot from your QA. excellent work.. much appreciated… your Question and answer shows your level of experience and they knowledge you have on MSBI
thanks a lot roopesh
actually I am looking for an PM in MSBI please do provide any openings details.
chandrasekar and Hari from chennai
Very helpful….many thanks
i think you have removed the vidoes
rohit
many many thanks i got lot of stuff.very useful for interviews.
really you have provided very good questions, thanks a lot
Hi roopesh.valluru ,
This is the Ever Best Q & A online i have read. You have covered Complete SSAS.
The REAL TIME INTERVIEW QUESTIONS is the masterpiece.
Great Job !
viagra or cialis
With thanks, Numerous information!
cost viagra 100mg – viagra price purchase viagra for sale
define hydrochloric https://keys-chloroquinehydro.com/
cost prednisolone 5mg – neurontin 100mg without prescription tadalafil tablet
buy clavulanate pills – buy cialis 10mg online cheap cialis prices
trimethoprim brand – buy sulfamethoxazole online cheap buy generic sildenafil 150mg
order sildenafil 50mg – buy fildena 50mg generic where to buy ivermectin cream
ceftin price – methocarbamol cost order cialis 10mg without prescription
ampicillin 500mg generic – buy ampicillin 250mg generic tadalafil price
amoxil 500mg canada – order vardenafil online cheap levitra ca
price of ivermectin – buy vardenafil 20mg online cheap buy vardenafil 20mg generic
buy doxycycline 100mg generic – order cialis 5mg generic buy cialis 40mg
amoxil order online – order generic sildenafil 50mg viagra for sale
albuterol inhalers for asthma
order prednisolone 20mg for sale – neurontin 100mg usa order sildenafil 100mg pill
lasix drug – furosemide 40mg us ivermectin 1%cream
furosemide 40 mg
furosemide
40 mg lasix too much
[url=https://furosemidevs.com/]lasix tablet[/url]
furosemide 20 mg tab cost
purchase glucophage generic – order metformin without prescription brand norvasc 10mg
cheap lisinopril – order lisinopril 2.5mg without prescription cost tenormin 100mg
order vardenafil 20mg generic – order vardenafil 20mg online clomid 100mg cheap
buy ventolin sale – slots games buy dapoxetine 60mg online
albuterol sulfate hfa ventolin tablet crush ok
cost levothyroxine – order plaquenil pills buy generic plaquenil 200mg
benefits of viagra for men sildenafil tablets 100 mg
brand prednisone 20mg – order prednisone no prescription amoxil usa
order diltiazem generic – buy azithromycin generic purchase neurontin online
cenforce 100mg brand – ezetimibe without prescription purchase motilium online
https://buynolvadex.store/# liquid tamoxifen
[url=https://buymetformin.best/#]otc metformin[/url] metformin canada online
lipitor generics buy brand lipitor
buy isotretinoin 20mg pills – purchase tetracycline pill tetracycline 250mg pill
nolvadex pills tamoxifen pill
https://buymetformin.best/# metformin er 500mg
buy plavix 75mg generic – order metoclopramide 10mg sale buy metoclopramide 20mg without prescription
anti parasite meds for humans canine ivermectin for sale
buy prescription drugs online without prescription drugs online without
https://cipro.best/# ciprofloxacin
https://cipro.best/# cipro
buy cipro online canada buy cipro
https://gabapentin.icu/# neurontin 200 mg price
https://dostromectolit.com/ ivermectin
diflucan tablet uk diflucan 150 cost
https://gabapentin.icu/# neurontin 100mg discount
ed meds online without doctor prescription buy prescription drugs online without
https://diflucan.icu/# buy cheap diflucan online
https://clomidonline.icu/# clomid 100mg for sale
finasteride buy online – propecia ca cipro 1000mg uk
ed causes and treatment buy generic ed pills online
https://edpills.best/# buy ed pills online
flagyl 200mg for sale – augmentin price buy cephalexin without prescription
[url=https://doxycyclineonline.store/#]doxycycline[/url] doxycycline hyc
ventolin hfa 90 mcg inhaler $10 ventolin inhaler coupons 2015 with insurance
ed meds ed pills
https://stromectol.life/# buy stromectol
https://edpills.best/# best ed treatment
sildenafil 100mg over the counter – viagra in usa viagra 100mg usa
ed medications list best erectile dysfunction pills
male erection pills – sildenafil 100mg kaufen ohne rezept original Viagra rezeptfrei sicher kaufen
where can i find ivermectin for humans parasite medication
generic ivermectin ivermectin 2ml
generic name for ivermectin stromectol 12 mg tablets
https://stromectoltrust.com/# order stromectol over the counter
https://stromectoltrust.com/# stromectol 12 mg tablets
cheap gabapentin generic – doxycycline 100mg over the counter ivermectin pill cost
stromectol 3 mg tablets price stromectol 12 mg tablets
[url=https://stromectoltrust.com/#]stromectol 12 mg tablets[/url] order stromectol over the counter
https://stromectoltrust.com/# topical ivermectin for scabies
https://pharmacyizi.com/# amoxicillin without a doctor’s prescription
buy hydroxychloroquine hydroxychloroquine
order baricitinib 2mg online – baricitinib brand order lisinopril 10mg online cheap
https://pharmacyizi.com/# online canadian drugstore
[url=https://pharmacyizi.com/#]ed vacuum pumps[/url] canadian drugs
https://pharmacyizi.com/# erectional dysfunction
https://pharmacyizi.com/# cvs prescription prices without insurance
prilosec for sale buy omeprazole for sale methylprednisolone generic
https://pharmacyizi.com/# cheap erectile dysfunction pills
[url=https://pharmacyizi.com/#]cheap online pharmacy[/url] male enhancement products
https://pharmacyizi.com/# ed meds online without prescription or membership
buy priligy 30mg pills zyloprim 100mg tablet allopurinol 300mg sale
[url=https://pharmacyizi.com/#]dysfunction erectile[/url] ed online pharmacy
purchase sildenafil online cialis 5mg cost order cialis 40mg online cheap
https://canadiandrugs.best/# pet meds without vet prescription canada
[url=https://canadiandrugs.best/#]canadian drug pharmacy[/url] prescription drugs without prior prescription
[url=https://onlinepharmacy.men/#]canadian pharmacy mall[/url] uk pharmacy no prescription
zithromax 200mg 5ml suspension dosage azithromycin z pack cost
ed meds online without doctor prescription discount prescription drugs
[url=https://canadiandrugs.best/#]how to get prescription drugs without doctor[/url] best ed pills non prescription
https://allpharm.store/# Cytoxan
https://canadiandrugs.best/# prescription drugs without prior prescription
[url=https://allpharm.store/#]Aurogra[/url] Cefadroxil
https://allpharm.store/# pharmacy uk
https://onlinepharmacy.men/# viagra canadian pharmacy vipps approved
[url=https://canadiandrugs.best/#]prescription drugs without prior prescription[/url] canadian drug
methotrexate 10mg tablet viagra 25 mg purchase reglan pills
[url=https://canadiandrugs.best/#]best non prescription ed pills[/url] ed drugs online from canada
https://onlinepharmacy.men/# canadadrugpharmacy com
https://allpharm.store/# Benicar
ed pills that work cheap erectile dysfunction pills online
order viagra 100mg online cheap usa pharmacy viagra deltasone online
https://erectionpills.shop/# erectile dysfunction medications
https://erectionpills.shop/# generic ed drugs
accutane 20mg price suhagra canada sildenafil 50mg uk
stromectol price comparison http://stromectol.bond/ ivermectin 6mg
[url=https://stromectolbestprice.com/#]what worms does ivermectin kill in dogs[/url] how much ivermectin paste to give a dog for mange
https://stromectolbestprice.com/# ivermectin products
sildenafil 25 mg purchase losartan pill order losartan 50mg pills
[url=http://stromectolbestprice.com/#]ivermectin topical dosage for humans[/url] horse ivermectin for humans
http://stromectolbestprice.com/# ivermectin dosage for mice
https://stromectolbestprice.com/# where can i buy stromectol
buy esomeprazole 20mg generic purchase esomeprazole sale rx pharmacy online cialis
https://drugsbestprice.com/# vitality ed pills
buy tadalafil 5mg generic order sumatriptan 25mg online cheap order avodart 0.5mg generic
[url=https://drugsbestprice.com/#]carprofen without vet prescription[/url] buy prescription drugs from india
zantac 150mg without prescription order celebrex 200mg online cheap tamsulosin 0.4mg cost
https://medrxfast.com/# how to get prescription drugs without doctor
https://medrxfast.com/# pain medications without a prescription
[url=https://medrxfast.com/#]buy prescription drugs online without[/url] tadalafil without a doctor’s prescription
ed prescription drugs canadian drug prices
diflucan 200mg drug buy ampicillin 250mg without prescription viagra 50mg drug
https://medrxfast.com/# buy prescription drugs online legally
buy cialis 20mg without prescription buy cialis 20mg pill order sildenafil 50mg generic
circa sports betting draftkings sports betting smart money sports betting
zithromax generic order generic prednisolone glucophage sale
https://medrxfast.com/# amoxicillin without a doctor’s prescription
order flagyl 400mg sildenafil 50mg ca order metformin 1000mg for sale
[url=https://medrxfast.com/#]tadalafil without a doctor’s prescription[/url] pain medications without a prescription
legal sports betting pa pa sports betting sky sports bet
albuterol asthma inhalers for sale albuterol nebulizer solution dosage albuterol sulfate hfa 90 mcg inhaler albuterol inhaler cost
clindamycin without prescription buy cleocin pill buy rhinocort
[url=https://medrxfast.com/#]canadian pharmacy[/url] prescription drugs online without doctor
https://medrxfast.com/# canadian pharmacy
[url=https://medrxfast.com/#]buy prescription drugs without doctor[/url] best online canadian pharmacy
https://medrxfast.com/# amoxicillin without a doctor’s prescription
https://medrxfast.com/# pain meds without written prescription
oral sildenafil 150mg order cialis without prescription generic cialis canada
[url=https://medrxfast.com/#]buy prescription drugs from india[/url] cheap pet meds without vet prescription
https://medrxfast.com/# canadian pharmacy online
[url=https://gabapentin.top/#]neurontin 204[/url] generic neurontin cost
https://wellbutrin.best/# wellbutrin online order
buy indocin 75mg pill buy trimox 500mg generic order amoxicillin for sale
disulfiram online uk buy disulfiram online india
https://wellbutrin.best/# average cost of wellbutrin
https://diflucan.life/# buying diflucan without prescription
– ivermectin for humans amazon ivermectin tablets for humans ivermectin for sale uk.
https://diflucan.life/# diflucan pill uk
minocin 50mg brand minocycline 50mg usa arava 20mg uk
[url=https://finasteride.top/#]propecia tablets[/url] generic propecia for cheap without precscription
buy stromectol for dogs Cialis Viagra Effet
https://deltasone.icu/# prednisone online
purchase sulfasalazine for sale olmesartan 20mg drug order depakote 250mg
best online casino payouts online casino real money no deposit lucky casino online
https://glucophage.top/# metformin 1000 mg tablets cost
https://glucophage.top/# metformin for sale in usa
[url=https://glucophage.top/#]where can i purchase metformin 1000 mg[/url] can i buy metformin over the counter
https://glucophage.top/# order metformin 500 mg online
[url=https://azithromycin.blog/#]zithromax 500mg over the counter[/url] zithromax 500 mg lowest price pharmacy online
where can i buy zithromax uk ethermine
https://finasteride.top/# propecia generic finasteride
[url=https://amoxicillin.pro/#]cheap amoxicillin 500mg[/url] where to buy amoxicillin 500mg
order xenical 120mg online order cyclobenzaprine pills buy lioresal online
https://tadalafil.pro/# pharmacy online tadalafil
buy tizanidine generic buy zanaflex sale purchase reglan
https://amoxicillin.pro/# amoxicillin cost australia
how to buy from the darknet markets biggest darknet market 2022
casino games online buy ed pills gb pay for essay writing uk
darknet market credit cards what is escrow darknet markets
darknet market reddits darkmarket website
onion seiten darknet live markets
dark web in spanish versus project darknet market
Also Cialis has a few contraindications for the use in comparison with other drugs for the treatment of erectile dysfunction online cialis pharmacy
Write a review and get 20 more tabs cialis super active
blue lady e pill red ferrari pills
black market net cypher market url
tor market list good dark web search engines
deep web cc shop most popular darknet markets 2022
deep website search engine dark web market reviews
alphabay link darkmarket url
darknet selling drugs crypto darknet drug shop
access the dark web reddit cypher darknet market
black market url deep web deep web search engine url
мега кокаин мега onion
trusted darknet markets best darknet markets for marijuana
новое зеркало мега mega onion зеркала
darknet drug store underground black market website
brucelean darknet market onion domain and kingdom
best deep web markets guide to using darknet markets
darknet market links buy drugs darknet
mega ссылка мега онион
duckduckgo dark web search working dark web links
which darknet markets are still open cannahome url
how to get on the dark web android the real deal market darknet
fake id onion dark market sites
reddit darknet reviews tor2door market
2022 darknet market best black market websites
dark web links 2022 reddit black market illegal drugs
darkmarkets darknet black market url
mega onion зеркало mega onion
site darknet liste reliable darknet markets lsd
darknet markets alphabay market
black market prices for drugs darknet drug market
dark web marketplace dark markets denmark
darknet markets dread onion seiten 2022
reddit darknet markets uk what darknet markets are still up
dark web drug marketplace darknet markets japan
Abacus Market the dark web links 2022
reddit darknet markets list black market sites 2022
магазин даркнет магазин даркнет
drugs from darknet markets onion websites for credit cards
deep web weed prices top dark net markets
black market deep deep market
illegal black market wiki darknet market
credit card black market websites hire an assassin dark web
[url=https://antibiotic.icu/#]how to buy doxycycline online[/url] antibiotic side effects
buying drugs off darknet darknet search
tor best websites r darknet market
what is the best darknet market tor darknet sites
darknet market list url darkmarket list
2022 working darknet market darknet market script
мега нарко мега onion зеркало
berlin telegram group drugs deep web weed prices
mega ссылка сайт даркнет
dumps shop darknet links market
reddit darknet market superlist cannahome market
dark web search engines link darknet markets reddit links
versus market link darknet illegal market
mega onion ссылка зеркало мега
incognito link new darknet markets 2022
tor market darknet the armory tor url
darknet reddit market pills how to access the dark web through tor
step by step dark web asap market
which darknet markets are up how to access darknet markets reddit
мега onion магазин mega зеркало
darknet markets onion address best darknet market 2022
darknet drugs reddit dark web sites drugs
deep web link 2022 xanax on darknet
darknet links 2022 drugs
dark markets bulgaria best lsd darknet market
darknet links markets darknet markets list
darknet list market tor2door darknet market
мега вход мега официальный сайт
cannahome darknet market tma drug
onion websites for credit cards the dark web links 2022
ьупф ьфклуе мега onion зеркало
darknet market search engine darknet drug vendors
drugs from darknet markets tramadol dark web
black market website review lsd drug wiki
tor market darknet darknet drugs safe
darknet market redit dark web search engines 2022
black market websites credit cards cannazone
hidden wiki tor onion urls directories blue lady e pill
сайты даркнет mega onion
buying drugs online on openbazaar dark markets portugal
darknet drug market dark web in spanish
best deep web markets dark web market list
back market trustworthy darknet market links safe
dark markets south korea darknet drugs australia
onion sex shop darknet market search
официальный сайт мега mega онион
verified darknet market how to get on the dark web on laptop
dark markets lithuania reddit darknet markets 2022
what darknet markets are live underground market online
darknet market noobs reddit dark web hitman
monkey xtc pill hitman for hire dark web
darknet магазин mega онион сайт
darknet market links 2022 how to access darknet markets
vice city market darknet market black
darknet market listing Cocorico Market
current darknet markets reddit australian darknet vendors
мега onion оффициальный сайт сайт мега
магазины даркнета сылка на мегу
we amsterdam best deep web markets
how to use deep web on pc darknet drug markets 2022
the darknet drugs top 10 dark websites
darknet gun market dark web links adult
darkweb форум illegal black market
best darknet market for weed 2022 darknet market xanax
cypher market link
deep web links 2022 dark web market list
darknet reddit market pills darknet список сайтов
darknet market alternatives darknet marketplace
onion directory how to buy from the darknet markets lsd
darknet stock market dark markets luxembourg
darkweb sites reddit reddit where to buy drugs
мега onion ссылка ссылка мега
link de hiden wiki ethereum darknet markets
decentralized darknet market weed darknet market
dark markets venezuela Heineken Express darknet Market
darknet markets guide dark markets indonesia
access the black market darknet websites
verified dark web links bitcoin darknet drugs
buy bank accounts darknet counterfeit money onion
reliable darknet markets darkmarket url
black market alternative archetyp market link
dark markets peru fake id dark web 2022
cannazon market url versus market link
deep dot web replacement core market darknet
dark web search engine 2022 darknet marketplace drugs
marijuana dark web best darknet markets for marijuana
dark markets montenegro oniondir deep web link directory
alphabay darknet market darknet drug market list
black market online best darknet drug sites
мега сайт ссылка мега онион сайт
darknet market steroids dark web sites name list
dark markets belgium darknet market sites and how to access
dark markets south korea darknet market controlled delivery
dark markets iceland darknet credit card market
decentralized darknet market tor drugs
versus project market link naked lady ecstasy pill
best darknet markets for marijuana tor2door market url
как зайти на мегу ссылка мега
best black market websites black market reddit
canazon darknet market alphabay
dark markets greece darknet selling drugs
dark markets italy blacknet drugs
black market bank account dark web counterfeit money
dark markets hungary
darkfox market link adresse onion black market
archetyp market link darknet drugs sales
darknet vendor reviews dark markets montenegro
best darknet market for psychedelics how to access the dark web reddit
мега мефедрон мега даркнет
best darknet drug market 2022 dark markets bolivia
darknet markets reddit darknet market drug
top 10 dark websites darknet market noobs step by step
how to install deep web darknet bank accounts
brucelean darknet market dark markets belgium
cheapest drugs on darknet pink versace pill
what darknet market to use now deep web drugs
top ten dark web sites darknet market links safe
darknet market adressen darknet markets reddit
drug market new onion darknet market
biggest darknet markets 2022 darknet onion markets
online onion market where to find onion links
currently darknet markets cheap darknet websites dor drugs
сайты даркнет мега onion зеркала
как зайти на мегу мега сайт
dark markets san marino dark web trading
versus project market darknet dark web links market
best darknet market for counterfeit alpha market url
reddit darknet market list dread onion
mega ссылка даркнет магазин
Kingdom Market darknet hidden uncensored wiki
dark web drug markets market street darknet
how to get on darknet market darknet drugs sales
vice city market link darknet guns market
how big is the darknet market deep net websites
ьупф ьфклуе зайти на мегу
adresse dark web dark markets turkey
darknet adress dark web hitman for hire
darknet market links buy ssn drug market darknet
darknet markets ranked 2022
deep web url links top ten deep web
tor search engine link what darknet markets are still up
mega сайт mega зеркало
reddit best darknet markets duckduckgo dark web search
reddit best darknet market new alphabay darknet market
darknet vendor reviews we amsterdam
brick market how to anonymously use darknet markets
dn market reddit darknet markets uk
Vegan diets also have been found to lack B12, but this can easily be countered with a multivitamin generic 5mg cialis best price How is Tadalista 20 mg used
where to find darknet market links redit darknet market list
underground market place darknet darknet market guide reddit
darknet seiten liste escrow market darknet
dark web links adult counterfeit money dark web reddit
dark markets guyana buying drugs online on openbazaar
darknet seiten liste crypto market darknet
зеркало мега мега onion зеркала
phenazepam pills black market website
dark markets poland dark web illegal links
drug markets dark web the dark market
market onion versus project link
mega онион сайт даркнет магазин
tor darknet markets dark web buy bitcoin
даркнет сайты магазин мэги сайт
most popular darknet market buying on dark web
free deep web links vice city darknet market
dark markets usa how to install deep web
dark web drugs australia buying drugs online on openbazaar
buy ssn and dob bitcoin darknet drugs
deep web drug markets bitcoin darknet drugs
what is the best darknet market tor2door market darknet
dark markets greece live onion market
сайт даркнет мэги сайт
darknet drug dealer versus link
black market sites 2022 deep web canada
deep web directory onion
darknet drug vendor that takes paypal reddit where to buy drugs
current list of darknet markets how to buy from darknet
cannazon link cp onion
deep web marketplaces reddit asap market
даркнет магазин ссылка мега
steroid market darknet bitcoins and darknet markets
darknet market list darknet markets norway 2022
reddit darknet markets noobs darknet market search engine
darknet market script top ten dark web
darknet market reddits darkshades marketplace
active darknet markets black market drugs
buying drugs on the darknet deep web directory onion
dark market french deep web link
dn market dark web site list
berlin telegram group drugs how to access darknet markets reddit
how to get on the dark web darknet market package
dark web xanax deep web links reddit 2022
dark market link onion market url
мега мефедрон официальный сайт мега
darknet markets reddit links active darknet markets
dark markets korea cannazon market link
xanax darknet reddit monkey xtc pill
how to shop on dark web darknet markets deepdotweb
darknet black market darknet markets onion address
how to use deep web on pc black market websites tor
reddit darknet market list deep web cc sites
darknet drugs safe best darknet market may 2022 reddit
darknet search engine url dark markets russia
Abacus Market url darknet market dmt
cheapest drugs on darknet dark web login guide
мега onion зеркало mega market
darknet market avengers dark web drug marketplace
deep web search engine url darknet xanax
current darknet market
brucelean darknet market which darknet markets are up
dark web hitmen the dark web url
asap market link dark net market list
which darknet market are still up darknet market listing
how to get to darknet market safe russian darknet market
darknet market links 2022 reddit vice city link
darknet market ddos darknet bitcoin market
darknet market fake id darknet market comparison chart
deep web software market best darknet market reddit
which darknet market are still up decabol pills
hire an assassin dark web darkfox market link
new darknet markets 2022 reddit darknet market noobs bible
cypher market cypher url
сайт даркнет зайти на мегу
best dark web search engine link how to use darknet markets
wired darknet markets darknet links 2022 drugs
buy bitcoin for dark web r darknet market
мега ссылка мега шишки
darknet website for drugs how to buy from the darknet markets
bitcoin darknet drugs active darknet markets 2022
dark web drug markets top ten deep web
mega onion зеркала мега onion зеркала
anadrol pills dark markets finland
darknet dream market darknet market onions
alphabay market tor markets
darkmarket darknet market updates 2022
black market buy online credit card dumps dark web
darknet markets financial times deep web software market
darknet onion links drugs asap link
bitcoin darknet markets
deep web cc shop versus project darknet market
hire an assassin dark web hacking tools darknet markets
darknet markets list 2022 darknet drug markets reddit
agora darknet market which darknet markets are up
новое зеркало мега мега onion зеркала
urls for darknet markets cannahome url
deep net access underground website to buy drugs
Cocorico Market url darkweb markets
darkfox market darknet dark web drugs
black market bank account guide to darknet markets
best darknet markets 2022 black market website
weed only darknet market onion market
deep web link 2022 dark markets russia
escrow dark web top darknet markets
darknet markets reddit deep web shopping site
free deep web links r darknet market
working darknet markets new darknet market reddit
Kingdom Market what darknet markets are open
best darknet markets 2022 cannazon market
dark web engine search dark web poison
deep net access darknet guide
Kingdom darknet Market buying drugs online
french dark web buying drugs off darknet
euroguns deep web dark web drugs
новое зеркало мега даркнет магазин
bitcoin black market how to buy bitcoin for the dark web
dark markets moldova dark web adderall
underground black market website dark web weed
Heineken Express darknet darknet markets deepdotweb
tor drugs dark web sites xxx
dark web sites links deep net websites
pink versace pill darknet market links 2022
deep web shopping site darknet live markets
duckduckgo dark web search working dark web links
darknet сайт даркнет сайты магазин
open darknet markets how to get on the dark web
darknet steroid markets
Cocorico Market link deep net access
market cypher cannazon market darknet
best darknet market uk deep web search engines 2022
darknet markets norway 2022 tor search engine link
darknet market noobs darknet market noobs guide
online drug market credit card dumps dark web
online onion market nike jordan pill
how to access deep web safely reddit dark markets colombia
darknet market noobs bible darknet reddit market
darknet markets 2022 updated Heineken Express url
магазин мега мега сайт
versus project market url reliable darknet markets
buy bank accounts darknet how to get to darknet market
bitcoin cash darknet markets dark websites
onion directory deep web canada
monero darknet markets alpha market url
tor market adress darknet
buying things from darknet markets darknet sites url
deep cp links archetyp market
tor market links dark markets peru
monkey xtc pill deep web hitmen url
alphabay link reddit
мега купить соль официальный сайт мега
darknet market links 2022 monero darknet market
dark markets spain buy bank accounts darknet
drugs dark web reddit darknet credit card market
сайты даркнет ссылки мега onion зеркала
bohemia link buying drugs online
dark web shop tor market nz
urls for darknet markets darknet search engine
hire essay writer buy tadalafil without prescription tadalafil 20mg cheap
reddit where to buy drugs french dark web
dbol steroid pills darknet drug prices reddit
best darknet market for weed uk darknet market guide reddit
what darknet markets are available dark market link
darknet markets darknet market vendor guide
cypher market darknet darknet onion links drugs
best dark web counterfeit money dark chart
deep web drugs reddit drug market darknet
мега onion зеркало магазин даркнет
deep web drug prices darknet links market
cannazon market drug markets onion
darknet market carding black market website names
darknet market dash dark web in spanish
outlaw darknet market url archetyp market
black market websites tor 2022 darknet market
deep web drug url deep web cc sites
dark web electronics deep web deb
darknet drug prices darknet market black
best darknet market for guns bohemia darknet market
мега onion зеркала сайт мега
cannahome url how to access deep web safely reddit
darkweb marketplace russian anonymous marketplace
tor markets links darknet market reddit
dark web cheap electronics how to search the dark web reddit
access the dark web reddit darknet market sites and how to access
darknet websites wiki counterfeit money onion
магазин даркнет мега onion зеркало
darknet market search dark markets croatia
darknet market url list drug markets dark web
Cocorico url reddit darknet market noobs
Heineken Express link fake id onion
darknet marketplace darknet wiki link
bitcoin darknet drugs darknet market 2022 reddit
cvv black market online black market uk
darknet market script dark web prostitution
reddit darknet markets uk black market credit card dumps
darknet market reviews tor markets links
магазин мега мега нарко
how to use the darknet markets darkfox market
mega ссылка сылка на мегу
black market credit card dumps darknet market guide reddit
pink versace pill deep web links reddit 2022
darknet websites drugs deep dark web markets links
darknet gun market darknet markets 2022 updated
tor2door darknet market dark web links
darknet drugs safe reddit darknet market australia
dark chart open darknet markets
dark markets indonesia darkweb форум
darknet bank accounts dark web marketplace
зайти на мегу мега onion ссылка
versus project market darknet darknet market drug
best dark net markets darknet market reddit
escrow dark web reddit where to buy drugs
buying drugs off darknet back market trustworthy
agora darknet market fake id dark web 2022
Heineken Express url
counterfeit euro deep web back market legit
adresse onion black market best darknet markets for marijuana
mega зеркало сайты даркнет ссылки
dark markets luxembourg deep net access
berlin telegram group drugs dark markets switzerland
site darknet liste shop online without cvv code
what are darknet drug markets dark markets brazil
onion seiten tor darknet market
dark markets bulgaria how to dark web reddit
deep web cc shop deep dot web markets
buying drugs on the darknet largest darknet market
how to get on dark web dark market list
updated darknet market list link de hiden wiki
darknet market directory darknet drug trafficking
darknet drug markets 2022 Cocorico darknet Market
darknet sites dark web sites links
darknet сайт ссылка на мегу
drug markets onion darkmarket
dark market link dark web market
мега кокаин мега магазин
darknet market links tor marketplace
tor markets 2022 deep web markets
darknet links dark market link
dark web drug marketplace tor marketplace
finasteride proscar propecia tablet price in india
darknet links dark web links
free dark web bitcoin dark web
dark markets 2022 free dark web
dark web websites darkmarket url
deep dark web deep web links
dark web markets dark web markets
tor darknet dark web drug marketplace
darknet websites dark web sites links
dark web link darknet seiten
darkmarket link deep web markets
dark markets darknet search engine
how to access dark web darkmarkets
dark market 2022 darknet markets
darkweb marketplace dark web site
deep web sites deep web drug store
tor marketplace drug markets dark web
tor darknet darknet websites
dark web market tor dark web
bitcoin dark web darknet links
deep dark web dark internet
dark web market deep web markets
how to get on dark web darknet links
dark web link darknet marketplace
deep dark web darknet drugs
dark web site dark web access
free dark web deep web drug url
tor market links dark market
mega ссылка сайт мега
dark web market dark web sites
dark web market dark market
tor darknet dark market link
the dark internet dark websites
deep web drug links dark websites
dark market onion tor market links
мега onion зеркало мега сайт
darkmarket list deep web sites
dark web site darknet search engine
tor dark web dark web market
darkmarket dark markets 2022
мега онион мега onion оффициальный сайт
darknet links bitcoin dark web
dark web websites deep web search
deep web markets drug markets dark web
tor markets dark web link
deep web drug markets how to access dark web
darkmarket list how to get on dark web
darknet drug links tor markets 2022
dark market list darknet market list
dark markets deep web drug url
drug markets dark web darknet websites
darknet магазин сайт даркнет
dark web site darkmarket link
deep dark web how to get on dark web
deep web drug links darknet seiten
deep web markets darkmarket link
dark web search engine darknet market
dark web link dark web access
best darknet markets dark net
darknet seiten dark market list
mega сайт мэги сайт
tor darknet dark web drug marketplace
darkmarket 2022 deep web drug store
dark web market dark web search engine
best darknet markets dark internet
dark market dark web search engines
darknet market deep dark web
dark market list dark web market links
мега онион сайт сайты даркнет ссылки
blackweb official website dark web market
darkmarket list darknet market lists
darknet market lists tor darknet
deep web markets darkmarket
tor market url dark markets 2022
tor markets links dark net
bitcoin dark web darkmarkets
darknet drug store darknet drug store
darknet websites deep web drug url
black internet deep web drug markets
dark web links darknet drugs
deep web drug links dark web access
bitcoin dark web darknet markets
dark web websites dark web drug marketplace
dark web search engine darknet drug links
darknet market lists darknet search engine
dark web market links best darknet markets
магазины даркнета мега купить соль
dark web markets black internet
darknet drug market deep web sites
dark web search engines dark market 2022
deep web drug url tor market
tor market links deep web drug markets
tor markets links dark web access
dark web market links dark market 2022
darknet markets dark markets 2022
drug markets dark web darknet websites
darknet links dark market url
priligy dapoxetine Headaches are the most common side effect of both medications
buy priligy pills I said to Mueller, I said Why does this have to be, why does this have to be so
darkweb marketplace dark web market list
dark web access how to access dark web
tor market url darknet drugs
deep web drug markets dark web websites
dark web market links deep dark web
dark web site darkmarket 2022
darknet сайт ссылки на даркнет
free dark web dark web site
dark web search engines best darknet markets
darkmarket list darkmarket
best darknet markets darknet sites
dark web site dark web drug marketplace
dark market link tor market links
dark web search engine darknet links
darknet market lists deep web sites
даркнет сайты магазин мега шишки
how to get on dark web deep web drug links
darknet drug market darknet marketplace
магазин даркнет мэги сайт
dark market list tor markets
dark market url darknet marketplace
deep web search darkmarket list
dark markets dark market url
dark web websites dark websites
the dark internet darknet drug store
dark web links free dark web
darknet drugs dark websites
deep dark web darkweb marketplace
dark web sites darknet market links
deep web markets dark markets
dark websites dark markets 2022
dark markets drug markets onion
tor dark web dark market list
darknet sites darkmarket
darkmarket link tor markets
dark website darknet websites
ьупф ьфклуе мега зеркало
bitcoin dark web darknet search engine
dark markets darkmarket list
deep web links deep web drug links
tor market dark web links
deep web markets deep dark web
dark market darknet drug store
tor darknet deep web drug links
dark market url dark market onion
the dark internet tor market
dark web websites darknet sites
tor market url tor markets
best darknet markets darknet drug market
dark market 2022 dark market onion
мега магазин магазин даркнет
dark website dark market
mega онион сайт мега скорость
onion market tor markets
dark web market list dark web site
deep web markets dark market link
free dark web drug markets onion
deep web drug store dark internet
darknet markets deep web search
dark net onion market
dark market 2022 tor market url
the dark internet drug markets onion
dark internet tor market
tor markets links dark web websites
drug markets dark web the dark internet
dark web market list how to get on dark web
tor markets links best darknet markets
dark web links onion market
магазины даркнета официальный сайт мега
deep web markets the dark internet
deep web sites tor dark web
darknet websites darkmarket
best darknet markets tor market url
darknet market list dark web markets
tor markets darknet drug store
black internet tor markets links
darknet sites darknet drug links
мега зеркало зеркало мега
darknet market list deep web drug links
dark net free dark web
darknet магазин mega onion зеркала
tor darknet darknet market list
deep web search tor dark web
tor market url dark net
dark market list darknet seiten
free dark web darkmarket 2022
mega ссылка мега нарко
dark market link darknet links
tor marketplace dark web sites
black internet dark market link
bitcoin dark web deep web drug markets
how to access dark web dark internet
drug markets dark web dark internet
darknet marketplace darkmarket list
mega зеркало мега наркотики
dark market darknet drugs
dark web markets drug markets onion
tor markets deep web search
drug markets dark web darknet drugs
darkweb marketplace darknet websites
deep web drug url darkmarket
darknet marketplace darkweb marketplace
dark web market darknet marketplace
deep web markets deep web search
darknet site dark internet
darkmarket list drug markets dark web
mega зеркало mega onion зеркала
tor marketplace darkmarket
dark web websites how to get on dark web
deep web drug links dark market url
darkmarkets blackweb official website
darkmarket 2022 dark market link
новое зеркало мега сайты даркнет ссылки
сайты даркнет как зайти на мегу
tor market url darknet market list
dark web markets tor market url
dark website deep web drug url
how to get on dark web deep web drug links
darknet drug store darknet drug links
darknet links tor markets 2022
tor markets links darkmarket url