Last
weekend I tried my knowledge with the practice tests of the 445 Training Kit. I
enjoyed it because larger part of the questions was explained well in the book.
But I've
found 3 wrong answers. I've showed it to one of my friends and he has confirmed
me. Let's see those:
1.
You want to back up an SSAS database in SQL Server
Management Studio (SSMS). You want to save the backup file in the C:\Temp
folder on the server on which SSAS is installed. What do you need to do before
you perform the backup operation?
-
The
correct answer according to MS is to add the C:\Temp folder to the
AllowedBrowsingFolders server property.
-
I chose the
"Do nothing. You can save the backup file to any folder by default."
Because I can write any existing folder into the selected path field and it
will be backed up there. I've tried it. If there is a C:\Temp folder you just
have to type or paste it into as selected pat.
2. Can a local
Windows administrator be denied data access to a SQL Server Analysis Services
(SSAS) cube on the same server?
-
MS ansers that "No, local
windows administrators cannot be denied access to SSAS."
-
But read this: (straight from the training kit book,
Lesson 16, Chapter 1)
"You can set the server BuiltinAdminsAreServerAdmins property to False
if you want to revoke the predefined SSAS administrative rights to Windows
local administrators. Before doing so, however, make sure you assign some
Windows users to the SSAS Administrators group to avoid a server lockdown."
3.
You are managing several SQL Server Integration Services
Packages. You have set up package configurations on several of your packages.
Each package configuration is intended to be shared across multiple packages.
The current package that you are working on has three package
configurations in the following order:
a. XMLConfig
b. SQLConfig
c. EnvConfig
A few of the package objects are configured
across the configuration files. You would like to make sure the values in the
package are set by SQLConfig.
What changes to the order of the configurations
in the Package Configuration Wizard must you make for the SQLConfig
configuration's values to have precedence over the other configurations'
values? (Choose all that apply.)
MS tells me to choose these two:
-
Move EnvConfig to the top of
the list of configurations.
-
Move SQLConfig to the bottom of the list of
configurations.
Package configs are run in the order in which
they exist in the Wizard. The last will override every
preceding config. So why would I need to do anything with EnvConfig?
I intend to write an email to MS to clarify the situation :) Any comment would be welcome!
Cheers,
MartinIsti