Quiz
70-463
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (86)
1Reporting from a Star schema is simpler than reporting from a normalized online
transactional processing (OLTP) schema. What are the reasons for wanting simpler
reporting? (Choose all that apply.)- AA Star schema typically has fewer tables than a normalized schema. Therefore,
queries are simpler because they require fewer joins. - BStar schema has better support for numeric data types than a normalized rela-
tional schema; therefore, it is easier to create aggregates. - CThere are specific Transact-SQL expressions that deal with Star schemas.
- DA Star schema is standardized and narrative; you can find the information you
need for a report quickly.
- AA Star schema typically has fewer tables than a normalized schema. Therefore,
2You are creating a quick POC project. Which schema is the most suitable for this kind
of a project?- AStar schema
- BNormalized schema
- CSnowflake schema
- DXML schema
3A Star schema has two types of tables. What are those two types? (Choose all that
apply.)- ALookup tables
- BDimensions
- CMeasures
- DFact tables
4You implement a Type 2 solution for an SCD problem for a specific column. What do
you actually do when you get a changed value for the column from the source system?- AAdd a column for the previous value to the table. Move the current value of the
updated column to the new column. Update the current value with the new value
from the source system. - BInsert a new row for the same dimension member with the new value for the
updated column. Use a surrogate key, because the business key is now duplicated.
Add a flag that denotes which row is current for a member. - CDo nothing, because in a DW, you maintain history, you do not update dimen-
sion data. - DUpdate the value of the column just as it was updated in the source system.
- AAdd a column for the previous value to the table. Move the current value of the
5Which kind of a column is not a part of a dimension?
- AAttribute
- BMeasure
- CKey
- DMember property
- EName
6How can you spot natural hierarchies in a Snowflake schema?
- AYou need to analyze the content of the attributes of each dimension.
- BLookup tables for each dimension provide natural hierarchies.
- CA Snowflake schema does not support hierarchies.
- DYou should convert the Snowflake schema to the Star schema, and then you would
spot the natural hierarchies immediately.
7Over which dimension can you not use the SUM aggregate function for semi-additive
measures?- ACustomer
- BProduct
- CDate
- DEmployee
8Which measures would you expect to be non-additive? (Choose all that apply.)
- APrice
- BDebit
- CSalesAmount
- DDiscountPct
- EUnitBalance
9Which kind of a column is not part of a fact table?
- ALineage
- BMeasure
- CKey
- DMember property
10Which database objects and object properties can you use for autonumbering?
(Choose all that apply.)- AIDENTITY property
- BSEQUENCE object
- CPRIMARY KEY constraint
- DCHECK constraint
11What columns do you add to a table to support Type 2 SCD changes? (Choose all that
apply.)- AMember properties
- BCurrent row flag
- CLineage columns
- DSurrogate key
12What is an inferred member?
- AA row in a fact table added during dimension load
- BA row with aggregated values
- CA row in a dimension added during fact table load
- DA computed column in a fact table
13Which types of data compression are supported by SQL Server? (Choose all that apply.)
- ABitmap
- BUnicode
- CRow
- DPage
14Which operators can benefit from batch processing? (Choose all that apply.)
- AHash Join
- BMerge Join
- CScan
- DNested Loops Join
- EFilter
15Why would you use indexed views? (Choose all that apply.)
- ATo speed up queries that aggregate data
- BTo speed up data load
- CTo speed up selective queries
- DTo speed up queries that involve multiple joins
16The database object that maps partitions of a table to filegroups is called a(n)
- AAligned index
- BPartition function
- CPartition column
- DPartition scheme
17If you want to switch content from a nonpartitioned table to a partition of a partitioned
table, what conditions must the nonpartitioned table meet? (Choose all that apply.)- AIt must have the same constraints as the partitioned table.
- BIt must have the same compression as the partitioned table.
- CIt must be in a special PartitionedTables schema.
- DIt must have a check constraint on the partitioning column that guarantees that all
of the data goes to exactly one partition of the partitioned table. - EIt must have the same indexes as the partitioned table.
18Which of the following T-SQL functions is not very useful for capturing lineage
information?- AAPP_NAME()
- BUSER_NAME()
- CDEVICE_STATUS()
- DSUSER_SNAME()
19You need to move data from a production database into a testing database. You need
to extract the data from several objects in the source database, but your manager
has asked you to only copy about 10 percent of the rows from the largest production
tables. The testing database already exists, but without any tables. How would you ap-
proach this task?- AUse the Import and Export Wizard, copy all tables from the source database to the
empty destination database, and delete the excess rows from the largest tables. - BUse the Import and Export Wizard multiple times—once for all the smaller tables,
and once for each large table, using the Write A Query To Specify The Data To
Transfer option to restrict the rows - CUse the Import and Export Wizard, copy all tables from the source database to the
empty destination database, and restrict the number of rows for each large table
by using the Edit SQL option in the Column Mappings window - DUse the Import and Export Wizard, configure it to copy all tables from the source
database to the empty destination database, save the SSIS package, and then,
before executing it, edit it by using SSDT to restrict the number of rows extracted
from the large tables.
- AUse the Import and Export Wizard, copy all tables from the source database to the
20You need to move data from an operational database into a data warehouse for the
very first time. The data warehouse has already been set up, and it already contains
some reference data. You have just finished preparing views in the operational data-
base that correspond to the dimension and fact tables of the data warehouse. How
would you approach this task?- AUse the Import and Export Wizard and copy data from the dimension and fact
views in the operational database into the tables in the data warehouse, by using
the Drop And Re-create The Destination Table option in the Column Mappings
window for every non-empty destination table. - BUse the Import and Export Wizard, configure it to copy data from the dimension
and fact views in the operational database into the tables in the data warehouse,
save the SSIS package, and then edit it by using SSDT to add appropriate data
merging functionalities for all destination tables. - CUse the Import and Export Wizard and copy data from the dimension and fact
views in the operational database into the tables in the data warehouse, by using
the Merge Data Into The Destination Table option in the Column Mappings win-
dow for every non-empty destination table. - DUse SSDT instead of the Import and Export Wizard, because the wizard lacks ap-
propriate data transformation and merging capabilities
- AUse the Import and Export Wizard and copy data from the dimension and fact
21When SSIS packages are saved to DTSX files, what format is used to store the SSIS
package definitions?- AThey are stored as binary files.
- BThey are stored as plain text files.
- CThey are stored as XML files.
- Dhey are stored as special Microsoft Word documents.
22Which statements best describe SQL Server Development Tools (SSDT)? (Choose all
that apply.)- ASSDT is an extension of the SQL Server Management Studio that can be used to
create SSIS packages by means of a special wizard. - BSSDT is a special edition of the SQL Server Management Studio, designed to pro-
vide an improved user experience to developers who are not particularly familiar
with database administration. - CSSDT is a special edition of Visual Studio, distributed with SQL Server 2012, provid-
ing a rich database development tool set. - DSSDT is a new service in SQL Server 2012 that can be used to perform SQL Server
maintenance tasks, such as data movements and similar data management pro-
cesses.
- ASSDT is an extension of the SQL Server Management Studio that can be used to
23Which of the following statements about simple and complex data movements are
true? (Choose all that apply.)- ASimple data movements only have a single data source and a single data
destination - BComplex data movements require data to be transformed before it can be stored
at the destination. - CIn simple data movements, data transformations are limited to data type
conversion. - DIn complex data movements, additional programmatic logic is required to merge
source data with destination data.
- ASimple data movements only have a single data source and a single data
24Which of the following statements are true? (Choose all that apply.)
- AAn SSIS package can contain one or more SSDT solutions, each performing a
specific data management operation. - BAn SSIS project can contain one or more SSIS packages.
- CAn SSIS project can contain exactly one SSIS package.
- DSSIS packages contain programmatic logic used in data movements and data
transformation operations.
- AAn SSIS package can contain one or more SSDT solutions, each performing a
25The Execute SQL Task allows you to execute SQL statements and commands against
the data store. What tools do you have at your disposal when developing SSIS pack-
ages to develop and test a SQL command? Choose all that apply.- ASQL Server Management Studio (SSMS)
- BSQL Server Data Tools (SSDT)
- CThe Execute SQL Task Editor
- DSQL Server Enterprise Manager (SSEM)
26You need to execute two data flow operations in parallel after an Execute SQL Task has
been completed. How can you achieve that? (Choose all that apply.)- AThere is no way for two data flow operations to be executed in parallel in the same
SSIS package. - BYou can place both data flows inside the same data flow task and create a prece-
dence constraint leading from the preceding Execute SQL Task to the data flow task. - CYou can create two separate data flow tasks and create two precedence constraints
leading from the preceding Execute SQL Task to each of the two data flow tasks. - DYou can create two separate data flow tasks, place them inside a third data flow
task, and create a precedence constraint leading from the preceding Execute SQL
Task to the third data flow task.
- AThere is no way for two data flow operations to be executed in parallel in the same
27Which precedence constraint can you use to allow Task B to execute after Task A even
if Task A has failed?- AThe failure precedence constraint, leading from Task A to Task B
- BThe success precedence constraint, leading from Task A to Task B.
- CThe completion precedence constraint, leading from Task A to Task B.
- DUse two precedence constraints—a success precedence constraint, and a failure
precedence constraint, both leading from Task A to Task B
28You need to extract data from delimited text files. What connection manager type
would you choose?- AA Flat File connection manager
- BAn OLE DB connection manager
- CAn ADO.NET connection manager
- DA File connection manager
29Some of the data your company processes is sent in from partners via email.
How would you configure an SMTP connection manager to extract files from email
messages?- AIn the SMTP connection manager, configure the OperationMode setting to Send
And Receive. - BIt is not possible to use the SMTP connection manager in this way, because it can
only be used by SSIS to send email messages. - CThe SMTP connection manager supports sending and receiving email messages by
default, so no additional configuration is necessary. - DIt is not possible to use the SMTP connection manager for this; use the IMAP (In-
ternet Message Access Protocol) connection manager instead.
- AIn the SMTP connection manager, configure the OperationMode setting to Send
30You need to extract data from a table in a SQL Server 2012 database. What connection
manager types can you use? (Choose all that apply.)- AAn ODBC connection manager
- BAn OLE DB connection manager
- CA File connection manager
- DAn ADO.NET connection manager
31In your SSIS solution, you need to load a large set of rows into the database as quickly
as possible. The rows are stored in a delimited text file, and only one source column
needs its data type converted from String (used by the source column) to Decimal
(used by the destination column). What control flow task would be most suitable for
this operation?- AThe File System task would be perfect in this case, because it can read data from
files and can be configured to handle data type conversions. - BThe Bulk Insert task would be the most appropriate, because it is the quickest and
can handle data type conversions. - CThe data flow task would have to be used, because the data needs to be trans-
formed before it can be loaded into the table. - DNo single control flow task can be used for this operation, because the data needs
to be extracted from the source file, transformed, and then loaded into the desti-
nation table. At least three different tasks would have to be used—the Bulk Insert
task to load the data into a staging database, a Data Conversion task to convert
the data appropriately, and finally, an Execute SQL task to merge the transformed
data with existing destination data.
- AThe File System task would be perfect in this case, because it can read data from
32A part of your data consolidation process involves extracting data from Excel work-
books. Occasionally, the data contains errors that cannot be corrected automatically.
How can you handle this problem by using SSIS?- ARedirect the failed data flow task to an External Process task, open the problematic
Excel file in Excel, and prompt the user to correct the file before continuing the
data consolidation process. - BRedirect the failed data flow task to a File System task that moves the erroneous
file to a dedicated location where an information worker can correct it later. - CIf the error cannot be corrected automatically, there is no way for SSIS to continue
with the automated data consolidation process. - DNone of the answers above are correct. Due to Excel’s strict data validation rules,
an Excel file cannot ever contain erroneous data.
- ARedirect the failed data flow task to an External Process task, open the problematic
33In your ETL process, a few values need to be retrieved from a database at run time,
based on another value available at run time, and they cannot be retrieved as part of
any data flow task. Which task can you use in this case?- AThe Execute T-SQL Statement task
- BThe Execute SQL task
- CThe Expression task
- DThe Execute Process task
34How is the order of execution, or the sequence of operations, defined in an SSIS
package?- AThe SSIS run time engine determines the order of execution automatically, based
on the type of operations, the available software and hardware resources, and the
size of data. - BThe sequence is defined by using precedence constraints.
- CThe sequence is defined by using the Sequence container.
- DThe sequence is defined at design time by using precedence constraints and
Sequence containers, but at run time the SSIS engine executes the operations in
the order set by the most appropriate execution plan for maximum performance.
- AThe SSIS run time engine determines the order of execution automatically, based
35How does the Failure constraint affect the execution order?
- AThe following task will only execute after the preceding task has failed.
- BThe following task will only execute if the preceding task has not failed.
- CThe following task will never execute, because this constraint is only used at
design time. - DThe following task will execute regardless of whether the preceding task has failed,
but an error will be written to the SSIS log.
36In your ETL process, there are three external processes that need to be executed in
sequence, but you do not want to stop execution if any of them fails. Can this be
achieved by using precedence constraints? If so, which precedence constraints can
be used?- ANo, this cannot be achieved just by using precedence constraints.
- BYes, this can be achieved by using completion precedence constraints between the
first and the second and between the second and the third Execute Process tasks,
and by using a success precedence constraint between the third Execute Process
task and the following task. - CYes, this can be achieved by using completion precedence constraints between
the first and the second, between the second and the third, and between the third
Execute Process task and the following task. - DYes, this can be achieved by using failure precedence constraints between the first
and the second, and between the second and the third Execute Process tasks, and
by using a completion precedence constraint between the third Execute Process
task and the following task.
37Which data flow source adapters can you use if you would like to read data from SQL
Server? (Choose all that apply.)- AADO NET source
- BRaw File source
- COLE DB source
- DODBC source
38Which data flow destinations can you use if you would like to temporarily stage data to
a file system? (Choose all that apply.)- AOLE DB destination
- BFlat File destination
- CRaw File destination
- DRecordset destination
39Which statements are true regarding data source adapters? (Choose all that apply.)
- AYou can change how source data is mapped to SSIS data types.
- BYou can have only one data source adapter per data flow task.
- CYou must always select all columns from the source adapter.
- DYou can read data from an XML file by using SSIS.
40Which transformation can you use if you would like to convert data from one data
type to another? (Choose all that apply.)- AAudit
- BDerived Column
- CData Conversion
- DScript Component
41Which transformations are fully blocking? (Choose all that apply.)
- ALookup transformation
- BSort transformation
- CMerge Join transformation
- DAggregate transformation
42Which transformations are new in SQL Server 2012 SSIS? (Choose all that apply.)
- ACDC Splitter
- BPivot
- CFuzzy Lookup
- DDQS Cleansing
43Which data flow transformation would you use if had to combine data from two different database tables that exist on two different servers? (Choose all that apply.)
- AMerge Join transformation
- BUnion All transformation
- CMerge transformation
- DLookup transformation
44Suppose that you want to load the data from a flat file and write it into a SQL Server,
Excel, and Raw File transformation inside one data flow task. How many Data Source
adapters do you need? (Choose all that apply.)- A0
- B1
- C2
- D3
45Which sentence is true regarding Cache connection manager? (Choose all that apply.)
- ACache can be reused by multiple Lookup transformations.
- BYou cannot incrementally update the cache while the package is running.
- CThe Cache connection manager can be set on a project level.
- DYou can do lookups against other (non OLE-DB) sources.
46In your SSIS package you need to retrieve a scalar value from a table in the destina-
tion database, to be used by multiple tasks. What is the most appropriate method to
achieve this?- AEmbed a subquery in every existing query used by the package, so that the database
engine can prepare the most appropriate execution plan to retrieve it at run time - BCreate a variable and use an expression to retrieve the value from the database
once, and then use it throughout the execution. - CCreate a variable and use the Execute SQL task to retrieve the value once, and then
use it throughout the execution. - DCreate a variable and use the Expression task to retrieve the value from the data-
base as many times as needed.
- AEmbed a subquery in every existing query used by the package, so that the database
47In your SSIS package, you created a package-scoped variable to hold a value that you
want to reuse throughout the package. Later you discover that this value must be set
differently in one container, but the original variable should not be affected. What can
you do?- ACreate a new package-scoped variable with a different name and reconfigure the
tasks accordingly, to either use the new variable or the original one - BCreate a new container-scoped variable with a different name and reconfigure
only the tasks that it contains to use the new variable. - CCreate a new container-scoped variable with the same name, and leave the tasks
unchanged. - DUse a package-scoped parameter, because this problem cannot be solved by using
variables.
- ACreate a new package-scoped variable with a different name and reconfigure the
48In your SSIS process, a specific property will be determined by the administrator in the
production environment. The value supplied by the administrator will be used in mul-
tiple properties and will have to be overridden automatically if certain conditions are
met at run time. What is the most appropriate method to achieve this in SSIS?- ACreate a parameter and use expressions to assign its value to the corresponding
properties, but use an expression at the beginning of the execution to change the
parameter value if needed. - BCreate a parameter, use an expression at the beginning of the execution to either
assign its value to a variable or override the value if needed, and use expressions to
assign the value of the variable to the properties. - CCreate a read/write variable, use expressions to assign its value to the appropriate
properties, and assign the correct value to the variable via property paths at run
time. - DCreate a parameter and use expressions to either assign its value to the property
or override it if needed.
- ACreate a parameter and use expressions to assign its value to the corresponding
49In your SSIS package, there are several data flow tasks, each importing data into the
destination database. You need to log the number of rows that have been inserted or
updated in each data flow. What options provided by SSIS can you use to accomplish
this? (Choose all that apply.)- AYou can use the Row Count task to count the rows passed through a data flow.
- BYou can use the Row Count component to count the rows passed through a
data flow. - CYou can store the values in variables before saving them to the log.
- DYou can use an expression to calculate the total number of processed rows.
50In your SSIS package, you need to set the properties of several tasks based on the in-
formation available about the run time environment. Each of the properties you need
to compute can be calculated by using a mathematical expression. What would be the
most appropriate method?- AUse the Expression Builder to build and test the expression, and then copy it to all
of the corresponding task definitions. - BPlace an Expression Task into the control flow, preceding each task whose proper-
ties need to be determined dynamically - CUse as many Expression tasks as necessary to compute as many variables as there
are different calculations, and then use the variables to assign the values to the
corresponding tasks. - DUse a single Expression task and store all required computed values in a row set
(Object) variable to be used in property expressions to configure the correspond-
ing tasks.
- AUse the Expression Builder to build and test the expression, and then copy it to all
51In the control flow of your SSIS package, you need to add a data maintenance task that
will rebuild the indexes of your dimension tables after they have been populated suc-
cessfully. You have implemented each dimension table load in an individual data flow.
The Execute SQL task containing the index rebuild script must be executed after the
preceding data flow has completed successfully, but only on Saturdays. The name of
the current day is stored in a variable. Is it possible to achieve this in SSIS control flow?
If so, how?- ANo, this is not possible in the control flow because the conditional split transforma-
tion is only available in a data flow. - BYes, it is possible to achieve this in the control flow, but only by using a Script task.
- CYes, this can be achieved by using a success precedence constraint leading from
the data flow task to the Execute SQL task, with a precedence constraint expression
checking whether the value of the variable is Saturday. - DYes, this can be achieved by using a regular success precedence constraint leading
from the data flow task to the Execute SQL task.
- ANo, this is not possible in the control flow because the conditional split transforma-
52What methods does SSIS provide for configuring child packages from the master
package?- AProject parameters
- BGlobal variables
- CPackage parameters
- DSolution parameters
53Expressions can be used in precedence constraints to… (one or more answers are
correct)- A…replace constraints.
- B…resolve conflicts between multiple constraints.
- C…add conditions to constraints
- D…determine variables
54Which of the following statements about master packages are true? (Choose all that
apply.)- AMaster packages are used to configure child packages.
- BMaster packages are used to execute child packages.
- CMaster packages prevent child packages from being executed directly.
- DMaster packages are used to control the order in which child packages are
executed.
551. Which functionality does the Slowly Changing Dimension transformation support?
(Choose all that apply.)- AType 1 SCD
- BType 2 SCD
- CType 3 SCD
- DInferred members
56Which transformations can you use to determine whether the values of specific col-
umns have changed between the source data and the destination table? (Choose all
that apply.)- AData Conversion
- BDerived Column
- CConditional Split
- DMulticast
57Which statement is true regarding the Slowly Changing Dimension transformation?
(Choose all that apply.)- AThe Slowly Changing Dimension transformation supports set-based updates.
- BThe Slowly Changing Dimension transformation supports inferred members.
- CYou can have multiple Slowly Changing Dimension transformations in one data flow
- DThe Slowly Changing Dimension Wizard supports only connections with a SQL
Server database.
58Which process modes in a CDC Source can be used directly to load data without ap-
plying the additional ETL process of getting the current value of the row? (Choose all
that apply.)- ANet
- BAll
- CAll with old value
- DNet with merge
59Which method can you use to dynamically set SQL inside SSIS at run time if you are
using an OLE DB source adapter? (Choose all that apply.)- AUse a stored procedure as a source
- BUse parameters inside the SQL statement
- CUse expressions
- DUse an SQL command from a variable.
60Which data flow elements have an error flow? (Choose all that apply.)
- AThe OLE DB Source adapter
- BThe Union All transformation
- CThe Merge transformation
- DThe Lookup transformation
61Which options are available for handling errors on the row level? (Choose all that apply.)
- AIgnore failure
- BFail component
- CRedirect row
- DDelete row
62Which data source adapters have an error flow? (Choose all that apply.)
- AOLE DB source
- BRaw File source
- CODBC source
- DExcel source
63Which task in the control flow supports transactions? (Choose all that apply.)
- AData flow task
- BExecute SQL task
- CFile System task
- DXML task
64Which transaction isolation level does not lock the records being read? (Choose all that
apply.)- ASerializable
- BSnapshot
- CChaos
- DReadUncommitted
65Which T-SQL statements can you use to manually handle a transaction? (Choose all
that apply.)- ABEGIN TRAN
- BROLLBACK TRAN
- CEND TRAN
- DCOMMIT TRAN
66Which properties do you need to set on the package level to enable checkpoints?
(Choose all that apply.)- ACheckpointFileName
- BCheckpointUsage
- CSaveCheckpoints
- DFailPackageOnFailure
67On which SSIS objects can you set checkpoints to be active? (Choose all that apply.)
- AData flow task
- BControl flow tasks
- C Sequence container
- DSort transformation
68Which statements are correct regarding SSIS checkpoints? (Choose all that apply.)
- AYou can have multiple checkpoint files per package.
- BIf the data flow task fails, you can store rows with errors in the checkpoint file.
- CIf the package is successful, the checkpoint file is deleted
- DIf you set the CheckpointUsage property to Always, the checkpoint file must be
present or the package will not start
69Which components in SSIS can act as executable components that trigger an event?
(Choose all that apply.)- ASequence container
- BPackage
- CData flow task
- DData flow transformation
70Which event handler types can you use if you want to log all the package errors?
(Choose all that apply.)- AOnPostExecute
- BOnError
- COnWarning
- DOnTaskFailed
71Which event handler types can you use if you want to log information before the task
starts in the package? (Choose all that apply.)- AOnTaskFailed
- BOnProgress
- COnPreExecute
- DOnWarning
721. Which parameter types are available in SSIS in SQL Server 2012? (Choose all that
apply.)- AProject-level parameters
- BSolution-level parameters
- CControl flow–level parameters
- DPackage parameters
73Which properties can be set by using build configurations? (Choose all that apply.)
- AParameter values
- BVariable values
- CControl flow task properties
- DThe Deployment Server Name property
74Which properties can be set by using property expressions? (Choose all that apply.)
- ASQL statement for the Execute SQL task
- BVariable values
- CData flow task properties
- DThe Lookup task cache mode property
75Which configuration types can you use to store configuration values? (Choose all that
apply.)- AXML Configuration File
- BSQL Server
- CAny relational database system
- DRegistry entry
76On which objects can you set dynamic properties by using package configurations?
(Choose all that apply.)- AParameters
- BVariables
- CData flow transformations
- DThe Sequence Container task
77Which SSIS elements can be configured by using a package configuration? (Choose all
that apply.)- AConnection properties
- BPackage variable properties
- CParameter properties
- DPackage properties
78Which statements about SSIS logging are correct? (Choose all that apply.)
- AEvery task and every operation automatically reports every error to the output file
by default. - BSSIS logging can be configured for individual SSIS tasks or containers or at the
package level - CSSIS logging writes entries into the SQL Server Error Log
- DSSIS log entries are exposed to the environment using a variety of built-in log
providers.
- AEvery task and every operation automatically reports every error to the output file
79Which of the following SSIS properties can be logged? (Choose all that apply.)
- AThe name of the control flow task
- BThe name of the event
- CThe name of the user who started the process
- DThe name of the machine on which the event occurred
80Which feature allows you to configure logging once on a particular task or container,
and then reuse the same settings on other tasks and/or containers?- AA log template
- BA log configuration template
- CA log settings template
- DA package configuration template
81What information can be added to the data flow buffer by using the Audit transforma-
tion? (Choose all that apply.)- AThe name of the event
- BThe identifier of the event
- CThe identifier of the task
- DThe name of the machine
82How can the Audit transformation be configured to provide additional system vari-
ables or user variables to the data flow?- AThe set of properties provided by the Audit transformation is fixed and cannot be
extended. - BThe Audit transformation itself cannot be extended, but by using the Expression
task, you can assign any value to an appropriate system variable used by the Audit
transformation. - CThe Audit transformation can be edited by using the Advanced Editor, which pro-
vides unlimited access to system and user variables, as well as the rest of the data
flow columns. - DThe set of properties provided by the Audit transformation can be extended at
design time by switching to advanced mode.
- AThe set of properties provided by the Audit transformation is fixed and cannot be
83Which of the following pieces of information represent typical examples of audit data?
(Choose all that apply.)- AThe date and time that the row was added to the table
- BThe date and time that the row was last modified
- CA value designating the success or failure of an SSIS process
- DThe name of the SSIS task in which an error has occurred
84What are SSIS package templates used for? (Choose all that apply.)
- AThey can be used to develop new SSIS projects.
- BThey can be used to preconfigure SSIS packages
- CThey can be used to apply log configurations for SSIS objects.
- DThey can be used to create SSIS packages.
85What type is used for SSIS package template files?
- AThe .dotx file type
- BThe .dotsx file type
- CThe .dtsx file type
- DThe .xml file type
86Which of the following statements about package templates are true? (Choose all
that apply.)- ASSIS package templates can be used to reapply log settings to SSIS tasks and/or
containers. - BSSIS package templates can be used to reduce the time needed to develop an SSIS
package. - CSSIS package templates can be used to preconfigure SSIS operations.
- DSSIS package templates can speed up SSIS process execution.
- ASSIS package templates can be used to reapply log settings to SSIS tasks and/or
Informações
- Descrição
- Implementing a Data Warehouse with Microsoft SQL Server 2012
- Autor
- saso70
- Idioma
- English
- Visualizações
- 858
- Avaliação
- 4,0 de 5 · 2 avaliações Avalie este quiz