which is the correct answer?
You are developing a SQL Server 2008 Analysis Services (SSAS) solution for
Company.com.
There is a key performance indicator (KPI) named PerKey in your solution.
You configure the Value expression of the KPI below.
[Measures].[Amount],[Account].[Accounts].[Operating Expenses]
/[Measures].[Amount],[Account].[Accounts].
[Gross Margin]
There is a time dimension called TestTime in your solution Multidimensional Expressions
(MDX)
statement are listed below
11 IIf(
12
13 ParallelPeriod
14 ( [TestTime].[Calendar].[Quarter],1,[ TestTime].[Calendar].CurrentMember
15 ) ), 2, -10 )
In order to configure a Trend expression of the KPI to show a difference in the values
compared with the before quarter.In order to solve the problem, which is the correct answer?
Which Transact-SQL operator should you use?
You use Microsoft SQL Server 2012 database to develop a shopping cart application.
You need to rotate the unique values of the ProductName field of a table-valued expression into
multiple columns in the output.
Which Transact-SQL operator should you use?
Which action will you perform?
You are a professional level SQL Sever 2008 Database Administrator. A database is hosted
by the instance, and sensitive data is included in the database. A database backup strategy
will be implemented for the database. You need to have all backups of the database
encrypted. The backups should not be accessed by unauthorized users. Which action will
you perform?
Which is the correct answer?
You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com.
You need to include a parent-child hierarchy for the dimension.
The child key feature is named CKUser and the parent key feature is named CKManager. As
the root member you need to ensure that the top user is included.
As the root member, you should make sure that the topmost employee should be included.
Which is the correct answer?
Which is the correct answer?
You are developing a SQL Server 2008 Analysis Services (SSAS) solution which includes a
time dimension called TestTime which includes a hierarchy called Year-By-Day for
Company.com. You own a measure called Number from a measure group called
MeasureTester. In the previous time period for the current level of the Yer-Bet-Day
hierarchy, you should make sure that you develop a calculated member to show the Number
measure. Which is the correct answer?
You need to design an appropriate synchronization solution
You are a database developer. You provide solutions by using SQL Server 2008 in an
enterprise environment. Your online transaction processing (OLTP) database contains a
tabled named SalesOrders. Your data warehouse contains a table named factBuyingHabits.
The factBuyingHabits table has no indexes. You need to synchronize data between the two
tables on a weekly basis. The synchronization process has the following requirements:
·New records in the SalesOrders table are inserted in the factBuyingHabits table. ·When a
record is modified in the SalesOrders table, the modification is updated in the
factBuyingHabits table. ·Records that are deleted from the SalesOrders table are also
deleted from the factBuyingHabits table. You need to design an appropriate synchronization
solution. You want to achieve this goal by using minimum amount of coding and
administrative efforts. What should you do?
Which is the correct answer?
You are developing a SQL Server 2008 Analysis Services (SSAS) solution which contains a
data source view (DSV) which owns a table called Worker for Company.com.
There are some columns in the Worker below
* WorkerKey
* BossKey
The BossKey column references the manager of the Workers.
You should make sure that you should create the relationship between the workers and their
boss in the DSV.
Which is the correct answer?
Which action will you perform to finish the task?
You are a professional level SQL Sever 2008 Database Administrator. A large database is
hosted by the instance. The company utilizes the following backup strategy for the
database. First, the performance of a full database backup is implemented at 02:00 hr every
Monday. Secondly, the performance of a differential backup is implemented at 23:00 hr
every day. Thirdly, the performance of a transaction log backup is implemented on an hourly
basis. A reboot is caused on the SQL Server 2008 server by a power failure at 09:15 hr,
Thursday. Fifteen minutes after the reboot of the server, it is reported that certain queries
that access customer data cannot be executed. You find that the customer data remains
unvaried after the power failure. When the DBCC CHECKDB command is executed on the
database, the following error message is received. Object ID 2814307832, index ID 2,
partition ID 83127819437122157, alloc unit ID 82134587923221126 (type In-row data):
Page (3421:169) could not be processed. See other errors for details. Table error: Object ID
2814307832, index ID 2, partition ID 83127819437122157, alloc unit ID
82134587923221126 (type In-row data), page (3421:169). Test (IS_OFF (BUF_IOERR,
pBUF->bstat)) failed. Values are 16928422 and -8.CHECKDB found 0 allocation errors and
2 consistency errors in table ‘tbl_Customer’ (object ID 2814307832). When the sp_help
‘tbl_customer’ stored procedure is executed, the following result set is received:
index_name index_description ————————————————————————- PK
clustered located on PRIMARY NCIX nonclustered located on PRIMARY Since you are the
technical support, you are required to make sure that the data should be accessible in the
shortest time. And the impact on users should be cut to the least. Which action will you
perform to finish the task?
Which is the correct answer?
You are managing a SQL Server 2008 Analysis Services (SSAS) method which includes a
dimension called TimeTester for Company.com.
There is a table called SalesTester which includes the two columns named OrderTester and
ShipTester. they are connected with TimeTester.
You should make sure that you could get information by measures using the DimTime
TimeTester.
Which is the correct answer?
Which is the correct answer?
You are developing a SQL Server 2008 Analysis Services (SSAS) method for
Company.com.
There are some components in the method
A dimension called TestTime which includes a property called Year
A measure group called TestProduct that connects with the TestTime dimension
You should make sure that the designed on TestProduct contain the Year property.
Which is the correct answer?