Interview Questions by iteanz

These Interview Questions Involves   Microsoft BI(SSIS,SSAS,SSRS) Q1).MSBI Characteristics Ans: Criteria Result Analytics Dashboards, guided navigation and drill down Type of Solution End-to-end Business solution with extended ETL User-friendly Ease of installation, use, maintenance Get a detailed understanding of the  advantages of MSBI  over other business intelligence tools. Q2). Define Query parameter in SSRS? Ans:   Query parameters is revealed in the query of the datasources that are to be included into the SQL script’s where clause of the SQL that can accept parameters. Query parameters begin with the symbol @. Q3). What are the Reporting Service Constituents in SSRS? Ans: A.Report Manager : A Web-based administration tool for managing the Report Server. B Report Server :  Provides services for implementation and delivery of reports. C. Report Designer :  A place where we can create report. Q4). What do you und...

EXPLAIN WHAT IS SALES FORCE? Salesforce is a CRM delivered as a software-as-a-service (SaaS). WHAT ARE CUSTOM OBJECTS IN SALESFORCE? Simply put custom objects are the database tables in Salesforce. All the data related to the enterprise can be stored in Salesforce.com. These custom objects have to be defined first and then the following steps need to be taken: Join records with custom objects. The custom object data are displayed in custom lists. Create a custom tab for custom object. Building page layouts. Creating dashboard & report for analyzing custom object. The custom tab, app and object can be shared MENTION CHANGING WHAT MAY CAUSE DATA LOSS? Data loss may cause due to following reasons Changing data and date-time Altering to percent,number and currency from other data types Changing from multi-select picklist, checkbox, auto number to other types Altering to multi-select picklist from any type except picklist Changing to auto-number exce...

Q1). Explain what is  sales force ? Ans:   Salesforce is a CRM delivered as a software-as-a-service (SaaS). Q2).What are custom objects in Salesforce? Ans:  Simply put custom objects are the database tables in Salesforce. All the data related to the enterprise can be stored in Salesforce.com. These custom objects have to be defined first and then the following steps need to be taken: Join records with custom objects. The custom object data are displayed in custom lists. Create a custom tab for custom object. Building page layouts. Creating dashboard & report for analyzing custom object. The custom tab, app and object can be shared Q3).Mention changing what may cause data loss? Ans:  Data loss may cause due to following reasons Changing data and date-time Altering to percent,number and currency from other data types Changing from multi-select picklist, checkbox, auto number to other types Altering to multi-select picklist from any type except p...