100% candidates have passed the MCTS 70-452 exam by the help of CertBus pass guaranteed MCTS 70-452 preparation materials. The CertBus Microsoft PDF and VCEs are the latest and cover every knowledge points of MCTS 70-452 PRO:MS SQL Server 2008, Designing a Business Intelligence certifications. You can try the Q and As for an undeniable success in 70-452 exam.
We CertBus has our own expert team. They selected and published the latest 70-452 preparation materials from Microsoft Official Exam-Center: http://www.certgod.com/70-452.html
QUESTION NO:14
You are designing a SQL Server 2008 Reporting Services (SSRS) solution. You have a
report that has several parameters that are populated when users execute the report.
You need to ensure that the solution meets the following requirements:
Which feature should you use?
A. My Reports
B. Linked Reports
C. Standard Subscription
D. Data-Driven Subscription
Answer: B
Explanation:
With a linked report, our report is deployed to one folder. It is then pointed to by links
placed elsewhere within the Report Catalog. To the user, the links look just like a report.
Because of these links, the report appears to be in many places. The sales department
sees it in their folder. The personnel department sees it in their folder.
The fact of the matter is the report is only deployed to one location, so it is easy to
administer and maintain. An execution snapshot is another way to create a cached report
instance. Up to this point, we have discussed situations where cached report instances are
created as the result of a user action. A user requests a report, and a copy of that report
QUESTION NO:67
You design a Business Intelligence (BI) solution by using SQL Server 2008.
You plan to transform sales data from a retail sales outlet database to a SQL Server 2008
data warehouse by using SQL Server 2008 Integration Services (SSIS).
The retail sales database is an online transaction processing (OLTP) database that
processes large amounts of transactions twenty-four hours a day.
You need to design the structure of the SSIS packages such that the performance of the
source system is minimally affected.
What should you do?
A. Load and transform data from the source directly to the data warehouse once a day.
B. Load data from the source to a staging database once a day. Then, transform the data
to the datawarehouse.
C. Load and transform data from the source directly to the data warehouse four times a day
at regular intervalsof time.
D. Load data from the source to a staging database four times a day at regular intervals of
time.Then, transform the data to the data warehouse once a day.
Answer: D
Explanation:
Using a Staging Server
In most situations (whether we
QUESTION NO:75
You design a Business Intelligence (BI) solution by using SQL Server 2008.
You plan to design a logging strategy for all SQL Server 2008 Integration Services (SSIS)
packages for your company.
You want to log errors that occur in all existing and future packages to a SQL Server 2008
table.
You need to design the strategy to meet the following requirements:
What should you do?
A.
. Enable and configure logging in a package.
. Create all other packages by using the first package as the template.
B.
. Create an event handler in a package.
. Configure the event handler to perform logging.
. Create all other packages by using the first package as the template.
C.
. Enable and configure logging in a package.
. Save the log settings to an XML file.
. Enable logging in all other packages.
. Load the log settings on each package by using the XML file.
D.
. Create an event handler in a package.
. Configure the event handler to perform logging.
. Enable package configurations in the package.
. Store the properties of the event handler in an XML configuration file.
. Configure all the packages to use the configuration file during execution.
Answer: C
Explanation:
Logging
Because Integration Services packages are, for the most part, designed for unattended
operation, it can be extremely important to create a log documenting the execution of the
package. This type of execution log can also be helpful for testing and debugging during
the creation of the package. We control the logging performed by an Integration Services
package using the Configure SSIS Logs dialog box.
We can create the following types of logs:
Comma-separated values text file
File to be read by the SQL Profiler
SQL Server Table named sysdtslog90
Windows Event Log
Extensible Markup Language (XML) text file
All of the log types, with the exception of the Windows Event Log, need to be configured to
specify exactly where the logged information is to be stored.
Finally, we need to determine which events should be logged for the package or for a
package item.
QUESTION NO:60
You design a Business Intelligence (BI) solution by using SQL Server 2008.
The solution has a cube that is processed periodically. The cube takes several hours to
process.
Cube processing results in a considerable amount of downtime.
You need to minimize the downtime while maintaining the best possible query performance
of the cube.
What should you do?
A.
. Use the multidimensional online analytical processing (MOLAP) cube storage model.
. Process the cube on a staging server.
. Use database synchronization to copy the cube to a production server.
B.
. Use the relational online analytical processing (ROLAP) cube storage model.
. Process the cube on a staging server.
. Use database synchronization to copy the cube to a production server.
C.
. Use the hybrid online analytical processing (HOLAP) cube storage model.
. Process the cube on a production server.
D.
. Partition the cube into several partitions.
. Use the relational online analytical processing (ROLAP) cube storage model for each
partition.
. Process the cube on a production server.
Answer: A
Explanation:
MOLAP
The MOLAP storage mode causes the aggregations of the partition and a copy of its
source data to be stored in
a multidimensional structure in Analysis Services when the partition is processed. This
MOLAP structure is highly optimized to maximize query performance. The storage location
can be on the computer where the partition is defined or on another computer running
Analysis Services. Because a copy of the source data resides in the multidimensional
structure, queries can be resolved without accessing the partition\’s source data.
Query response times can be decreased substantially by using aggregations. The data in
the partition\’s MOLAP structure is only as current as the most recent processing of the
partition.
As the source data changes, objects in MOLAP storage must be processed periodically to
incorporate those changes and make them available to users. Processing updates the data
in the MOLAP structure, either fully or incrementally. The time between one processing and
the next creates a latency period during which data in
OLAP objects may not match the source data. You can incrementally or fully update
objects in MOLAP storage without taking the partition or cube offline.
ROLAP will not improve performance. HOLAP storage mode is generally suited for
partitions in cubes that require rapid query response for summaries based on a large
amount of source data
QUESTION NO:11
You design a Business Intelligence (BI) solution by using SQL Server 2008.
Employees use a Windows Forms application based on Microsoft .NET Framework 3.5.
SQL Server is not installed on the employees\’ computers.
You write a report by using Report Definition Language (RDL).
You need to ensure that if the employees are disconnected from the corporate network, the
application renders the report.
What should you do?
A. Configure the application to use an SSRS Web service by using the Render method.
B. Configure the application to use an SSRS Web service by using the RenderStream
method.
C. Embed ReportViewer in the application and configure ReportViewer to render reports by
using the local processing mode.
D. Embed ReportViewer in the application and configure ReportViewer to render reports by
using the remote processing mode.
Answer: C
Explanation:
Embedding Custom ReportViewer Controls
Microsoft provides two controls in Visual Studio 2008 that allow you to embed SSRS
reports (or link to an existing SSRS report hosted on an SSRS instance) in your custom
Windows Forms or Web Forms applications. Alternatively, you can also design some types
of reports from within Visual Studio and then host them in your customapplications. The
two report processing modes that this control supports are remote processing mode and
local processing mode.
Remote processing mode allows you to include a reference to a report that has already
been deployed to a report server instance. In remote processing mode, the ReportViewer
control encapsulates the URL access method we covered in the previous section. It uses
the SSRS Web service to communicate with the report server.Referencing deployed
reports is preferred for BI solutions because the overhead of rendering and processing the
often large BI reports is handled by the SSRS server instance or instances. Also, you can
choose to scale report hosting to multiple SSRS servers if scaling is needed for your
solution. Another advantage to this mode is that all installed rendering and data extensions
are available to be used by the referenced report. Local processing mode allows you to run
a report from a computer that does not have SSRS installed on it.
Local reports are defined differently within Visual Studio itself, using a visual design
interface that looks much like the one in BIDS for SSRS. The output file is in a slightly
different format for these reports if they
QUESTION NO:71
You design a Business Intelligence (BI) solution by using SQL Server 2008.
You develop a SQL Server 2008 Integration Services (SSIS) package to perform an
extract, transform, and load (ETL) process from a Microsoft Access database to a SQL
Server 2008 data warehouse. The package is developed on a computer that runs a 32-bit
operating system.
You deploy the package to a server that runs a 64-bit operating system. You create a SQL
Server Agent job to run the package. The package fails to run when the job starts.
You need to ensure that the package runs successfully.
What should you do?
A. Redeploy the package to the Program Files (x86) folder.
B. Enable the Use 32 bit runtime option in the job step of the SQL Server Agent job.
C. Rebuild the package on a computer that runs a 64-bit operating system. Redeploy the
package to the server.
D. Modify the project of the package by setting the Run64BitRuntime property to TRUE.
Rebuild and redeploy the package to the server.
Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/ms141766.aspx
64-bit Considerations for Integration Services
Selecting 32-bit or 64-bit Package Execution in a SQL Server Agent Job
To run a package in 32-bit mode from a 64-bit version of SQL Server Agent, select Use 32
bit runtime on the Execution options tab of the New Job Step dialog box.
QUESTION NO:26
You design a Business Intelligence (BI) solution by using SQL Server 2008.
You create a SQL Server 2008 Reporting Services (SSRS) solution. The solution has a
report named SalesDetails that contains a parameter named EmployeeID.
You have the following constraints:
You need to ensure that the constraints are met before you deliver the report to the
employees.
What should you do?
A. Create a data-driven subscription.
B. Create a SharePoint Report Center site.
C. Create a subscription for each employee.
D. Create a report model for each employee.
Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/ms159150.aspx
A data-driven subscription provides a way to use dynamic subscription data that is
retrieved from an external data source at run time. A data-driven subscription can also use
static text and default values that you specify when the subscription is defined.
You can use data-driven subscriptions to do the following:
-Distribute a report to a fluctuating list of subscribers. For example, you can use data-
driven subscriptions to distribute a report throughout a large organization where
subscribers vary from one month to the next, or use other criteria that determines group
membership from an existing set of users.
-Filter the report output using report parameter values that are retrieved at run time.
-Vary report output formats and delivery options for each report delivery.
A data-driven subscription is composed of multiple parts. The fixed aspects of a data-driven
subscription are defined when you create the subscription, and these include the following:
-The report for which the subscription is defined (a subscription is always associated with a
single report).
-The delivery extension used to distribute the report. You can specify report server e-mail
delivery, file share delivery, the null delivery provider used for preloading the cache, or a
custom delivery extension. You cannot specify multiple delivery extensions within a single
subscription.
-The subscriber data source. You must specify a connection string to the data source that
contains subscriber data when you define the subscription. The subscriber data source
cannot be specified dynamically at run time.
-The query that you use to select subscriber data must be specified when you define the
subscription. You cannot change the query at run time.
Dynamic values used in a data-driven subscription are obtained when the subscription is
processed. Examples of variable data that you might use in a subscription include the
subscriber name, e-mail address, preferred report output format, or any value that is valid
for a report parameter. To use dynamic values in a data-driven subscription, you define a
mapping between the fields that are returned in the query to specific delivery options and to
report parameters. Variable data is retrieved from a subscriber data source each
processed.
QUESTION NO:6
You design a Business Intelligence (BI) solution by using SQL Server 2008.
The solution includes a SQL Server 2008 Analysis Services (SSAS) database. The
database contains a cube named Financials. The cube contains objects as shown in the
exhibit.
A calculated member named Gross Margin references both Sales Details and Product
Costs.
You need to ensure that the solution meets the following requirements:
What should you do?
A. Add dimension-level security and enable the Visual Totals option.
B. Add cell-level security that has read permissions on the Gross Margin measure
C. Add cell-level security that has read contingent permissions on the Gross Margin
measure.
D. Change the permissions on the Managers dimension level from Read to Read/Write.
Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/ms174927.aspx
User Access Security Architecture
Microsoft SQL Server Analysis Services relies on Microsoft Windows to authenticate users.
By default, only authenticated users who have rights within Analysis Services can establish
a connection to Analysis Services. After a user connects to Analysis Services, the
permissions that user has within Analysis Services are determined by the rights that are
assigned to the Analysis Services roles to which that user belongs, either directly or
through membership in a Windows role.
Dimension-Level Security
A database role can specify whether its members have permission to view or update
dimension members in specified database dimensions. Moreover, within each dimension to
which a database role has been granted rights, the role can be granted permission to view
or update specific dimension members only instead of all dimension members. If a
database role is not granted permissions to view or update a particular dimension and
some or all the dimension\’s members, members of the database role have no permission
to view the dimension or any of its members.
Note Dimension permissions that are granted to a database role apply to the cube
dimensions based on the database dimension, unless different permissions are explicitly
granted within the cube that uses the database dimension.
Cube-Level Security
A database role can specify whether its members have read or read/write permission to
one or more cubes in a database. If a database role is not granted permissions to read or
read/write at least one cube, members of the database role have no permission to view any
cubes in the database, despite any rights those members may have through the role to
view dimension members.
Cell-Level Security
A database role can specify whether its members have read, read contingent, or read/write
permissions on some or all cells within a cube. If a database role is not granted
permissions on cells within a cube, members of the database role have no permission to
view any cube data. If a database role is denied permission to view certain dimensions
based on dimension security, cell level security cannot expand the rights of the database
role members to include cell members from that dimension. On the other hand, if a
database role is granted permission to view members of a dimension, cell-level security
can be used to limit the cell members from the dimension that the database role members
can view.
QUESTION NO:35
You design a Business Intelligence (BI) solution by using SQL Server 2008.
The solution has been deployed by using default settings on a SQL Server 2008 Analysis
Services (SSAS) instance. The solution has a large cube that processes 10 million fact
rows.
You frequently encounter out-of-memory exceptions when the cube is processed.
You need to recommend a solution to resolve the out-of-memory exceptions when the cube
is processed. You want to achieve this task by using the minimum amount of development
effort.
What should you do?
A. Reduce the number of aggregations.
B. Partition the cube. Process the cube based on each partition.
C. Increase the physical memory available to the SSAS instance by modifying the
Memory\TotalMemoryLimit server property.
D. Increase the physical memory available to the SSAS instance by modifying the
OLAP\Process \BufferMemoryLimit server property.
Answer: D
Explanation:
QUESTION NO:63
You are the lead developer for a SQL Server 2008 data warehousing project.
The source database for the project is an online transaction processing (OLTP) system.
The OLTP system executes 4,000 transactions every minute during business hours.
The OLTP system records only the date and time of insertion of a new row and not for the
updates of existing rows.
You plan to design an extract, transform, and load (ETL) process for the project that
populates a data warehouse from the source database.
The ETL process must be configured in the following manner:
You need to ensure that only new rows or modified rows from the database tables are
processed by the ETL process.
What should you do?
A. Configure the data warehouse database to support the Type I Slowly Changing
Dimension transformation.
B. Configure the data warehouse database to support the Type II Slowly Changing
Dimension transformation.
C. Configure the Change Data Capture feature on all the source database tables that will
be processed by the ETL process.
D. Configure the Change Data Capture feature on all the data warehouse database tables
that will be processed by the ETL process.
Answer: C
Explanation:
Change Data Capture
One of the biggest challenges of the Extract, Transform, and Load (ETL) process is
determining which records need to be extracted from the source data and loaded into the
data mart. For smaller dimensional tables that
are not used to populate slowly changing dimensions, we may choose to truncate the
target table and refill it with all of the data from the source with every load
There are several methods for determining which data has changed since the last extract.
They include:
c Adding create and last update fields to the database table
c Adding flag fields to indicate when records have been extracted
c Creating triggers or stored procedures to replicate changes to change capture tables
If our source data is coming from a SQL Server 2008 database, we have a new feature to
make this process much easier. That feature is known as change data capture (CDC).
The transaction information is converted into a more readily usable format and stored in a
change table. One change table is created for each table that is being tracked by change
data capture.
(McGraw-Hill – Delivering Business Intelligence with Microsoft SQL Server 2008 (2009))
http://msdn.microsoft.com/en-us/library/bb522489.aspx
Change Data Capture
Change data capture is designed to capture insert, update, and delete activity applied to
SQL Server tables, and to make the details of the changes available in an easily consumed
relational format. The change tables used by change data capture contain columns that
mirror the column structure of a tracked source table, along with the metadata needed to
understand the changes that have occurred.
Change data capture is available only on the Enterprise, Developer, and Evaluation
editions of SQL Server.
Change data capture provides information about DML changes on a table and a database.
By using change data capture, you eliminate expensive techniques such as user triggers,
timestamp columns, and join queries.
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the 70-452 exam successfully with our Microsoft materials. CertBus PRO:MS SQL Server 2008, Designing a Business Intelligence exam PDF and VCE are the latest and most accurate. We have the best Microsoft in our team to make sure CertBus PRO:MS SQL Server 2008, Designing a Business Intelligence exam questions and answers are the most valid. CertBus exam PRO:MS SQL Server 2008, Designing a Business Intelligence exam dumps will help you to be the Microsoft specialist, clear your 70-452 exam and get the final success.
70-452 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mZzdSd2tKME5rTVU/view?usp=sharing
70-452 Microsoft exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/70-452.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.
 |  |  |  |  | |
|---|---|---|---|---|---|
 |  | | |  | |
| Brand | Certbus | Testking | Pass4sure | Actualtests | Others |
| Price | $45.99 | $124.99 | $125.99 | $189 | $69.99-99.99 |
| Up-to-Date Dumps |  |  | | | |
| Free 365 Days Update | | | | | |
| Real Questions | | | | | |
| Printable PDF | | | | | |
| Test Engine | | | | | |
| One Time Purchase | | | | | |
| Instant Download | | | | | |
| Unlimited Install | | | | | |
| 100% Pass Guarantee | | | | | |
| 100% Money Back | | | | | |
| Secure Payment | | | | | |
| Privacy Protection | | | | | |