Mcitp Cards Vol 1

Front 1

Are Repoting Services WMIs backwards compatible?

Back 1

no

Front 2

Does SSRS 2008 use IIS services?

Back 2

no, but previous versions did

Front 3

What's an ISAPI filter for?

Back 3

Web security/filtering on IIS services, like that in SSRS 2005 or earlier. Not needed in SSRS 2008, so you have to create new HTTP modules instead.

Front 4

What's the relationship between RSWebApplication.Config and RSReportServer.config?

Back 4

RSWebapplication.Config is for SSRS 2005. Everything in it besides ReportServerVirtualDirectorty and MaxAvtiveReqForOneUser are automatically upgraded/migrated to RSReportServer.config.

Front 5

Define roles: Browser, content Manager, Publisher, Report Builder

Back 5

Browser views reports, content manager manages content in the report server, publisher publishes reports to report server, report builder may view report definitions

Front 6

Can you give a windows login Administrator permissions for a database?

Back 6

No. You cannot directly give database permissions to a Windows user account. You must grant the permissions to a role in the database.

Front 7

Where must SSAS stored procedures be registered?

Back 7

Analysis services server or a SSAS database, not the GAC. You can use SSMS to register the assembly in the Assemblies folder of the SSAS server.

Front 8

Partitioning of a data mining structure requires what?

Back 8

SQL Server 2008. SQL Server 2005 won't do it.

Front 9

What does MSRS 2008 Web Service and Windows service monitor respectively?

Back 9

MSRS 2008 Web Service monitors report server performance for interactive reports. MSRS 2008 Windows Service monitors scheduled operations and report delivery.

Front 10

What product is the Resource Govenor for?

Back 10

Database engine instances of SQL Server 2008--not SSAS or others.

Front 11

How do you monitor SSAS performance?

Back 11

$system.discover_object_activity_dynamic managment view

Front 12

What do you do with credentials for reports that are distibuted via a data-driven subscription?

Back 12

Check Credentials stored securely in the report server

Front 13

If you want to retain interactive veatures in a delivered report, how should you deliver it?

Back 13

Email delivery, not file share delivery

Front 14

If you want to reset the symmetric key and the encypted dayta in SSRS 2008 what do you do?

Back 14

Set the IsWebServiceEnabled property in the rsreportserver.config file to false, issue the rskeymgmt -s command, set the IsWebServiceEnabled property to true and restart SSRS

Front 15

What does the -s switch of rskeymgmt do?

Back 15

-s Resets the symmetric key

Front 16

What does the -e switch of rskeymgmt do?

Back 16

-e Creates a backup

Front 17

Whats the difference between SCD transformation type 1 and type 2?

Back 17

Type 1 SCD transformation will update the columns in a dimension row, but will not preserve any change history. Type 2 slowly changing dimensions transofrmation will preserver the change history and create a new row when new changes occur

Front 18

What's the difference between parent-child dimensions and conformed dimensions?

Back 18

Conformed dimensions are dimensions that is shared across facts, such as customer, time, or geography across multiple fact tables. Parent-child dimensions are based on two columns that have a relationship to each other, such as employee and manager.

Front 19

What is a fact dimension relationship?

Back 19

Represents a relation between the attributes of a fact table; removes duplication from the table if values are stored multiple times

Front 20

When can you use a regular dimension relationship?

Back 20

When a key column of the dimension is directly joined with the fact table

Front 21

If you want to configure logging in a package or task, what format should you use to store the configuration?

Back 21

XML file. databases cannot store the logging configurations.

Front 22

If indirect configuration is used, packages deployed to different servers and location of configuration variables are subject to change, how should you store configuration?

Back 22

XML

Front 23

Paramater markers for executive SQL tasks?

Back 23

@<parameter name> for ADO.NET, ? for everything else

Front 24

Name an advantage of using SQL Server Log Provider over XML file provider?

Back 24

Multiple logs from multiple packages can all be stored in the same place

Front 25

If you want a dimension talbe to include columns with some null values, what do you need to enable?

Back 25

Inferred member support.

Front 26

Give an example of a semiadditive measure:

Back 26

Inventory (anything that is additive, but not by time)

Front 27

What happens when you configure the processing mode of the cube to LazyAggregations?

Back 27

The Analysis server automatically build bitmap indexes and aggregations for dimensions and partitions in the background

Front 28

If you need to provide support for different languages on cubes and dimensions, what should you do?

Back 28

Use translations for all Analysis Services objects.

Front 29

If you want logging to generate SQL traces, what logging provider should you use?

Back 29

SSIS log provider for SQL Server Profiler

Front 30

Where should you save Report Definition Language (.rdl) files?

Back 30

c:\Program Files\Microsoft Visual Studio 9.0\common7\ide\privateassemblies\projectitems\reportproject

Front 31

Data-driven subscriptions in SharePoitn integrated mode require what SQL Server?

Back 31

SQL Server 2008 developer, standard, or enterprise

Front 32

What versions of MOSS 2007 support SharePoint integrated mode?

Back 32

WSS 3.0, MOSS 2007 Standard, or MOSS 2007 Enterprise. The Small Business edition of MOSS 2007 won't do.

Front 33

What setting must you configure in order to allow Table Analysis Tools Add-in Excel 2007?

Back 33

Allow temporary mining models

Front 34

What version of SQL Server 2008 do you need for Data Mining Add-ins for Office 2007?

Back 34

Standard edition will do

Front 35

If you Encrypt with User Key can a group of user use the item?

Back 35

No! If a group needs access, use a password

Front 36

What does the "DontSaveSensitve" protection level do and when might it be used?

Back 36

It suppresses values of sensitive properties when the package is saved, such as the password in the connection string. If a different user is getting errors when trying to access someone else's package, not saving sensitive might be good

Front 37

What statement would dyou use to find SSIS packages stored on a server?

Back 37

SELECT name id, description FROM VMSQL01.msdb.dbo.sysssispackages

Front 38

Do you use an XML element or a script to back up an SSAS database to file?

Back 38

XML script

Front 39

What kind of volume must reporting data be on in a scalable shared database?

Back 39

Read-only

Front 40

Do clustered databases improve query performance?

Back 40

No

Front 41

What must be defined in order to perform currency conversion in a cube?

Back 41

At least one currency dimension, at least one time dimension, and at least one rate measure group

Front 42

If an SSAS data source table name changes, what command should you use?

Back 42

Replace Table