You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.
A. The credentials must be embedded.
B. The data source must use a live connection.
C. The data source must be stored as a hyper file.
D. The data must be extracted.
正解:A,D
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
You have the following chart that sorts states by the number of products each state has purchased.
Which formula should you use to include a number with the position of each state within each region?
A. LOOKUP (SUM ([Quantity]))
B. INDEX ()
C. WINDOW_SUM(SUM ([Quantity]))
D. FIRST ()
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
You have the following map.
You need the map to appear as shown in the following visualization.
What should you do?
A. Change the opacity to 75%
B. Change the mark type to Density
C. Drag Population to Size on the Marks card
D. Drag Location to Size on the Marks card
E. Change the mark type to Map
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?
A. Change Population to a discrete dimension
B. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
C. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
D. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
正解:
Explanation:
Select
Where
The correct way to complete the query is:
SELECT * FROM [dbo] . [Students]
WHERE [Students].[City] = 'Berlin'
The SELECT statement is used to retrieve data from a table or a view. The * symbol means that all columns will be returned. The FROM clause specifies the table or view name and the schema name.
The WHERE clause is used to filter the data based on a condition. The condition is [Students].[City] =
'Berlin', which means that only rows where the City column of the Students table is equal to 'Berlin' will be returned.
The other options are not relevant for this query. CAST is a function that converts a value from one data type to another. JOIN is a clause that combines data from two or more tables based on a common field. ON is a keyword that specifies the join condition. UNION is a set operation that combines the results of two or more queries into one result set.
References: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/where-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-transact-sql?view=sql-server-ver15#join
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-server-v
質問 6:
You have the following dashboard that contains two sheets.
You want to minimize the whitespace between the sheets.
What should you configure?
A. The background
B. The border
C. The padding
D. The size
E. The position
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
You have the following dataset
You need to create the following visualization.
Which quick table calculation should you drag to Text on the Marks card?
A. Compound Growth Rate
B. Percent Difference
C. Percentile
D. Percent of Total
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 8:
You have the following dashboard that contains two visualizations.
You want to show only one visualization at time. Users must be able to switch between visualizations.
What should you me?
A. A parameter and a calculated filed
B. Worksheet actions
C. Show/hide buttons
D. Dashboard actions
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 9:
You have a data source that contains 20 tables.
You want the tables to be organized within the Data pane based on the type of data contained within the tables.
What should you use?
A. Groups
B. Hierarchies
C. Folders
D. Sets
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
有沢** -
出題内容は単純に暗記すれば解けるものと、仕組みを理解していないと解けないものがありますが、それらを仕分けて掲載されているので受かるためには何を覚え、何を理解してのぞむべきかがわかり、効率的にTDA-C01勉強することができます。