Can Someone Pl Help me with Some SSRS 2008 Interview Question (Mid to Advanced Levels) I am a Sr. SQL DBA and need to conduct several interviews for my Employer right away.... Any Help is appreciated.Maninder

Guys Pl Post any Thing you have worked on; Like a Troubleshooting scenario or something. Try to make it a Single Liners (Q and A)Maninder

Few Question that might be helpful, 1. Difference between Logical Page an Physical Page in SSRS. 2. How to configure SSRS for Disaster recovery. 3. Describe the role of Encrpytion key in Report Server Configuration manager. 4. User want only to display only pdf as export option in report Manager .. Describe Steps to perform this . 5. Name and Describe few console utilities for SSRS. 6. Name few Endpoints exposed by SSRs 2008. 7. How can you access the Code in You report. Describe the Static and intance based method with example. 8. how to add custome Assemblies to Report. 9. What is Linked Report. 10. What are different types of roles provided by SSRS. 11. Describe different Processing Modes offered by SSRS. 12. When to Use Null Data driven Subscription? 13. What Factors need to take into consideration while desigining a international report ( Localaization ). 14. What are different option to deploy report from Dev to Prod. 15. What are the new Controls / Features added in SSRS 2008 / SSRS 2008 R2 16. How can you monitor the report Usage. 17. How can you add a new report User to report manager. 18. How can you create the dynamaic Datasource. Can a Shared Datasource be Dynamic? 19. A report is Performing poorly . What steps you would take to troubleshoot the Issue. 20. Write an Expression to perform a Division of two Integers fields and to avoid NAN error. 21. have you ever used Rank, Dense Rank Ntile, CTE and Pivot.. 22. Is SSRs 2008 dependent on IIS? if not how it perform the operations. ~~ Mark it as Answer if you find it correct~~

what level of SSRS developer you are looking for ?mark it as answer if it answered your question :)

3-5 Yrs Experience Level.Maninder

Sandeep, Thanks for the Quick Reply. Can you also pl post a one Liner Answers to these questions.. I am a Layman to the SSRS Advances...Maninder

Hello Maninder, depending on exactly what kind of a person you are looking for you could take matters like data-insight, helicopterview capability, people-mgmt skills, business intelligence knowledge etc. into consideration. This can be important if you need a 'reporting developer' capable of working independantly but are of lesser importance if you need somebody to get a complex technical architecture up-and-running. Regards, Vulcan900

That is nice. It woudl be nice to post the answers too :)

I will try to cover all the above topics plus more questions with answers in Separate post.~~ Mark it as Answer if you find it correct~~

register and test drive SSRS http://www.hsconsultinginc.com/

Here I collated answers for most of the questions.... 1. Difference between Logical Page an Physical Page in SSRS. Ø Logical page breaks are page breaks that you insert before or after report items or groups. Page breaks help to determine how the content is fitted to a report page for optimal viewing when rendering or exporting the report. The following rules apply when rendering logical page breaks: Logical page breaks are ignored for report items that are constantly hidden and for report items where the visibility is controlled by clicking another report item. Logical page breaks are applied on conditionally visible items if they are currently visible at the time the report is rendered. Space is preserved between the report item with the logical page break and its peer report items. Logical page breaks that are inserted before a report item push the report item down to the next page. The report item is rendered at the top of the next page. Logical page breaks defined on items in table or matrix cells are not kept. This does not apply to items in lists. 2. How to configure SSRS for Disaster recovery. Depends on daily backup technique. 3. Describe the role of Encrpytion key in Report Server Configuration manager. A> To encrypt credentials, connection strings. Can be taken backup and restore when required from configuration manager. 4. User want only to display only pdf as export option in report Manager .. Describe Steps to perform this . A> using System.Reflection; using Microsoft.Reporting.WebForms; public void DisableUnwantedExportFormats() { foreach(RenderingExtension extension in serverReport.ListRenderingExtensions()) { if(extension.Name == "XML" || extension.Name == "IMAGE" || extension.Name == "MHTML") ReflectivelySetVisibilityFalse(extension); } } 5. Name and Describe few console utilities for SSRS. RSConfig.exe Configuration of connection properties between the Report Server to the repository database. RSKeyMgmt.exe Management of encryption keys via command-line RS.exe Scripting of report deployment http://www.jenstirrup.com/2009/05/command-line-utilities-in-ssrs-2008.html 6. Name few Endpoints exposed by SSRs 2008. o Management Endpoints o Execution Endpoint o SharePoint Proxy Endpoints Ø http://msdn.microsoft.com/en-us/library/ms155398.aspx 7. How can you access the Code in You report. Describe the Static and intance based method with example. A> Static methods within a custom assembly are available globally within the report. You can access static methods in expressions by namespace, class, and method name The following example calls the method ToGBP, which converts the StandardCost field value from dollar to pounds sterling: =CurrencyConversion.DollarCurrencyConversion.ToGBP(Fields!StandardCost.Value) Instance-based methods are available through a globally defined Code member. You access these by referring to the Code member, and then the instance and method name. The following example calls the instance method ToEUR which converts the StandardCost field value from dollar to euro: =Code.m_myDollarCoversion.ToEUR(Fields!StandardCost.Value) 8. how to add custom Assemblies to Report. 1. On the Report menu, click Report Properties 2. On the References tab, do the following: a. In References, click the add (...) button and then select or browse to the assembly from the Add Reference dialog box. b. In Classes, type name of the class and provide an instance name to use within the report. 3. http://msdn.microsoft.com/en-us/library/ms252130(VS.80).aspx 9. What is Linked Report. A> A linked report is a report server item that provides an access point to an existing report. Conceptually, it is similar to a program shortcut that you use to run a program or open a file. http://msdn.microsoft.com/en-us/library/ms155998.aspx 10. What are different types of roles provided by SSRS? A> 1. Browser 2. Content Manager 3. My Reports 4. Publisher 5. Report Builder 11. Describe different Processing Modes offered by SSRS. Local Processing Mode: Processes reports in the client application. Remote Processing Mode: Renders server reports that are processed on a SQL Server Reporting Services report server. 12. When to Use Null Data driven Subscription? Create a data-driven subscription that uses the Null Delivery Provider. When you specify the Null Delivery Provider as the method of delivery in the subscription, the report server targets the report server database as the delivery destination and uses a specialized rendering extension called the null rendering extension. In contrast with other delivery extensions, the Null Delivery Provider does not have delivery settings that you can configure through a subscription definition. 13. What Factors need to take into consideration while designing a international report (Localization). http://www.codeproject.com/KB/reporting-services/SSRSReportLocalized.aspx 14. What are different option to deploy report from Dev to Prod. Ø From Solution Explorer by giving Target Sever URL Ø Uploading the .rdl from Report manager. 15. What are the new Controls / Features added in SSRS 2008 / SSRS 2008 R2 http://www.simple-talk.com/sql/reporting-services/new-features-in-reporting-services-2008-and-2008-r2/ 16. How can you monitor the report Usage. You can query theReportServer database for this information as follows: SELECT ex.UserName, ex.Format, ex.TimeStart, cat.Name, ex.Parameters, CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate FROM ExecutionLog AS ex, Catalog AS cat where ex.ReportID = cat.ItemID ORDER BY ex.TimeStart DESC Regards 17. How can you add a new report User to report manager. 18. How can you create the dynamaic Datasource. Can a Shared Datasource be Dynamic? http://www.simple-talk.com/community/forums/thread/2220.aspx 19. A report is Performing poorly . What steps you would take to troubleshoot the Issue. 20. Write an Expression to perform a Division of two Integers fields and to avoid NAN error. 21. have you ever used Rank, Dense Rank Ntile, CTE and Pivot.. 22. Is SSRs 2008 dependent on IIS? if not how it perform the operations. Venkat

Thanks

link to SSRS Interview questions and answers

Sandeep, I realize this post was quite some time ago, but I am in need of this information at this point and the questions were all very good. However, I have been searching for your separate post with the answers to the aforementioned questions, plus more if you were able to develop them and I cannot locate one. Could you please advise? I realize that "venkat" posted some of the answers and "thavva" proposed the post as answer, but not all of the questions were answered and some of the answers appear to be incomplete (to a novice like myself). For example, Question 1 covers the explanation of the "Logical" page breaks very well and completely, but being a novice, I need the explanation of the "Physical" page breaks as well and when one should be used as opposed to the other. See what I mean? Thanks so much in advance for your help, Sandeep.