Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
46 Cards in this Set
- Front
- Back
|
Who automatically gets administrative rights to a local SSAS instance?
|
Members of the Windows LocalMaching\Administrators group
|
|
|
What property would you need to change to prevent local Windows admins from having access to SSAS?
|
Analysis Services Property BuitinAdminsAreServerAdmins to False
|
|
|
Where can you create database roles?
|
Either SSMS or BIDS
Only database roles defined in BIDS are included in the SSAS project so BIDS is the recommended method |
|
|
What is one scenario where a user might need access to data sources?
|
They need to compare data in the data source with data in the mining module
|
|
|
What are the three types of cell permisions that you can use to define cell security policies?
|
Read, Read-Contingent, Read/Write
|
|
|
Is a new role allowed cube access by default?
|
No
|
|
|
What do you need to do to prevent a role from viewing calculated members that use a given measure?
|
You need to set a read-contingent permission that revokes that measure
|
|
|
Is backup intrusive?
|
No, users can continue to query the cubes while the backup operation is running
|
|
|
Where are allowed backup folders listed?
|
AllowedBrowsingFolders advanced server property
|
|
|
If you want to move an SSAS database to a new location, what do you have to do?
|
In SSMS, Right-click the SSAS database and then select Detach
|
|
|
What would you use to schedule SSAS backups?
|
SQL Server Agent
|
|
|
What is the Usage of NLB Network Load Balancing?
|
Load balancing TCP and user-defined functions (UDF) traffic
|
|
|
What is the usage of MSCS Microsoft Cluster Services?
|
Failover Support
|
|
|
What editions can the NLB Network Load Balancing run on?
|
Web
Standard Enterprise Datacenter |
|
|
What editions can MSCS Microsoft Cluster Services run on?
|
Enterprise
Datacenter |
|
|
How many nodes can NLB and MSCS support?
|
32 NLB
8MSCS |
|
|
What should you do before using NLB to scale out to two or more servers?
|
Scaling out should be your last resort. First, use good design practices,partition cubes, implement useful aggregations, tune MDX calculations and queries
|
|
|
How many nodes can cluster resources be hosted on at a time?
|
Only one
|
|
|
In MSCS how would one node know that another node is dead?
|
The exchanged packets, called the heartbeat, stop
|
|
|
What SQL Server Agent step type do you need to run a backup script?
|
To run a backup script in a SQL server Agent job, you need to select SQL Server Analysis Services Command as a step type
|
|
|
Where does SSMS read the property values from?
|
\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Config\msmdsrv.ini
|
|
|
What does the AllowedBrowsingFolders (Advanced) SSAS Server Folder Location Property do?
|
Defines a pipe-seperted list of the names of the folders where logs, backups, and other objects are allowed to be created on the server
|
|
|
What does the BackupDir SSAS Server Folder Location property do?
|
Sets the name of the folder in which SSAS backups should bew stored by defaul. The backup location can be overridden, but this assigns the default folder
|
|
|
What does the DataDir SSAS Server Folder Location property do?
|
Sets the folder in which SSAS data should be stored by default. All dimension data will be stored in this location, but partitions and agregates can be customized within the cube and partition properties
|
|
|
What does the LogDir SSAS Server Folder Location property do?
|
Sets the name of the folder in which logs should be written by default
|
|
|
What four steps would you do to move the SSAS data directory to a new drive?
|
1. Detach all SSAS databases
2. Copy the SSAS databases to the new data folder 3. Change the DataDir server property to the new data folder 4. Attach the SSAS databases |
|
|
What is the first step in troubleshooting SSAS server error conditions?
|
Check the Windows even log by using the Event Viewer console
|
|
|
Suppose you don't want to send the Microsoft Product Support team minidumps--what setting shoudl you change?
|
CreateAndSendCrashReports setting in the msmdsrv.ini configuration file:
0 No Minidump generated 1 Minidump generated but not sent 2Create and automatically send minidump file |
|
|
What does the QueryLogSampling QueryLog property do and what is the default setting?
|
The frequency for query sampling. By default, every tenth query is logged
|
|
|
If you want to run the Usage-Based Optimization Wizard to produce an aggregation design based on actual server usage, what do you need to configure?
|
You need to change all of the four Log\QueryLog properties: CreateLogTable, QueryLogConnectionString, QueryLogSampling, and QueryLogTableName
|
|
|
What do 0 and 1 represent in the Dataset column of a query log?
|
The 1s represent the attributes that are used in the query
|
|
|
Do you use BIDS or SSMS to create usage-based aggregations?
|
You can use either. BIDS if you want the aggregation design to become a part of the project and saved in the cube definition
|
|
|
Can you enhance an existing aggregation design with an aggregation design from the Usage-based Optimizaiton Wizard?
|
Yes, on the last page of the usage-Based Optimization Wizard, select the Merge with An Existing Aggregation option
|
|
|
Does query logging let you save the MDX statements for future review?
|
No, you need to use SQL Server Profiler to trace MDX
|
|
|
What is a Trace?
|
A trace is an SSAS object that resides on the server that monitors events you secify. The source application generates events using WMI Windows Management Instrumentation and SQL Server Profiler intercepts them and dispalys them for monitoring purposes
|
|
|
Where do you go to start the SQL Server Profiler?
|
All Programs-->Microsoft SQL Server 2008-->Performance tools-->SQL Server Profiler
|
|
|
If you reuse traces, what should you do to save effort?
|
Create a custom Trace Template
|
|
|
What does an SSAS session store and what is the default time-out?
|
Current catalog, state of calculations in each cube that the session has accessed, etc.The default timeout for a session is one hour with no activity
|
|
|
What are the five most important SQL Server Profiler Event Columns?
|
Duration
EventSubclass IntegerData NTUserName TextData |
|
|
What must you do before changing the Trace Properties?
|
You need to pause the trace first
|
|
|
What is the default length of time the flight recorder records server state before archving it?
|
One hour
|
|
|
Name five important performance counters?
|
MSAS 2008:Connection\Current Connections
MSAS 2008:Memory\Memory Limit High KB MSAS 2008:Memory\Memory Usage KB MSAS 2008:Processing\Rows Read/sec MSAS 2008:Thread\Query pool job queue length |
|
|
What should you do before performance testing the SSAS server by sending MDX queries to avoid skewing performance results?
|
Use the ClearCache command
|
|
|
Which SSAS trace can you use to monitor the server activity for the past hour?
|
Flight recorder trace
|
|
|
Which tool woud you use to detemine how long a given query takes to run?
|
SQL Server Profiler--the Duration column gives the execution talk
|
|
|
What are six interesting Analysis Services Schema Rowsets?
|
DISCOVER_COMMANDS
DISCOVER_COMMAND_OBJECT DISCOVER_CONNECTIONS DISCOVER_OBJECT_ACTIVITY DISCOVER_OBJECT_MEMORY_USAGE DISCOVER_SESSIONS |
